ClickHouse DB::Exception: Code: 48, e.displayText() = DB::Exception: Unknown function

The function used in the query is not recognized by ClickHouse.

Understanding ClickHouse

ClickHouse is a fast, open-source columnar database management system developed by Yandex. It is designed for online analytical processing (OLAP) and is known for its high performance in processing large volumes of data. ClickHouse is widely used for real-time analytics and can handle complex queries efficiently.

Identifying the Symptom

When working with ClickHouse, you might encounter an error message like: DB::Exception: Code: 48, e.displayText() = DB::Exception: Unknown function. This error indicates that the function you are trying to use in your SQL query is not recognized by ClickHouse.

What You Observe

Upon executing a query, the system throws an exception with code 48, specifically mentioning an unknown function. This halts the execution of your query and prevents you from retrieving the desired results.

Explaining the Issue

The error code 48 in ClickHouse is associated with the use of an unrecognized function in a query. This typically happens when a function is either misspelled, not supported by ClickHouse, or is a custom function that hasn't been properly registered.

Common Causes

  • Typographical errors in the function name.
  • Using functions that are not part of the ClickHouse standard library.
  • Attempting to use a function from another SQL dialect.

Steps to Fix the Issue

To resolve this issue, follow these steps:

Step 1: Verify Function Name

Ensure that the function name is spelled correctly. ClickHouse function names are case-sensitive. Refer to the ClickHouse Function Documentation to verify the correct spelling and usage of the function.

Step 2: Check Function Support

Confirm that the function you are trying to use is supported by ClickHouse. Some functions available in other SQL databases might not be available in ClickHouse. If the function is not supported, look for an alternative function in the ClickHouse Functions List.

Step 3: Implement Custom Functions

If you need a custom function, ensure it is properly defined and registered in ClickHouse. You may need to implement it using ClickHouse's User-Defined Functions (UDFs) feature.

Conclusion

By following these steps, you should be able to resolve the DB::Exception: Code: 48 error in ClickHouse. Always ensure that you are using supported functions and that they are correctly implemented in your queries. For further assistance, consider visiting the official ClickHouse documentation or community forums.

Never debug

ClickHouse

manually again

Let Dr. Droid create custom investigation plans for your infrastructure.

Start Free POC (15-min setup) →
Automate Debugging for
ClickHouse
See how Dr. Droid creates investigation plans for your infrastructure.
Start Free POC →

MORE ISSUES

ClickHouse DB::Exception: Code: 36, e.displayText() = DB::Exception: Division by zero
An attempt to divide by zero in a query.
ClickHouse DB::Exception: Code: 1038, e.displayText() = DB::Exception: Cannot execute function
The system cannot execute the specified function, possibly due to syntax errors or permissions.
ClickHouse DB::Exception: Code: 1037, e.displayText() = DB::Exception: Cannot drop function
The system cannot drop the specified function, possibly due to permissions or function locks.
ClickHouse DB::Exception: Code: 1036, e.displayText() = DB::Exception: Cannot create function
The system cannot create the specified function, possibly due to syntax errors or permissions.
ClickHouse DB::Exception: Code: 1035, e.displayText() = DB::Exception: Cannot remove role
The system cannot remove the specified role, possibly due to syntax errors or permissions.
ClickHouse DB::Exception: Code: 1029, e.displayText() = DB::Exception: Cannot drop user
The system cannot drop the specified user, possibly due to permissions or user locks.
ClickHouse DB::Exception: Code: 1034, e.displayText() = DB::Exception: Cannot assign role
The system cannot assign the specified role, possibly due to syntax errors or permissions.
ClickHouse DB::Exception: Code: 1033, e.displayText() = DB::Exception: Cannot drop role
The system cannot drop the specified role, possibly due to permissions or role locks.
ClickHouse DB::Exception: Code: 1032, e.displayText() = DB::Exception: Cannot create role
The system cannot create the specified role, possibly due to syntax errors or permissions.
ClickHouse DB::Exception: Code: 1031, e.displayText() = DB::Exception: Cannot revoke privileges
The system cannot revoke the specified privileges, possibly due to syntax errors or permissions.
ClickHouse DB::Exception: Code: 1027, e.displayText() = DB::Exception: Cannot drop index
The system cannot drop the specified index, possibly due to permissions or index locks.
ClickHouse DB::Exception: Code: 1030, e.displayText() = DB::Exception: Cannot grant privileges
The system cannot grant the specified privileges, possibly due to syntax errors or permissions.
ClickHouse DB::Exception: Code: 1028, e.displayText() = DB::Exception: Cannot create user
The system cannot create the specified user, possibly due to syntax errors or permissions.
ClickHouse DB::Exception: Code: 1026, e.displayText() = DB::Exception: Cannot create index
The system cannot create the specified index, possibly due to syntax errors or permissions.
ClickHouse DB::Exception: Code: 1025, e.displayText() = DB::Exception: Cannot drop view
The system cannot drop the specified view, possibly due to permissions or view locks.
ClickHouse DB::Exception: Code: 1024, e.displayText() = DB::Exception: Cannot create view
The system cannot create the specified view, possibly due to syntax errors or permissions.
ClickHouse DB::Exception: Code: 1023, e.displayText() = DB::Exception: Cannot detach table
The system cannot detach the specified table, possibly due to permissions or table locks.
ClickHouse DB::Exception: Code: 1022, e.displayText() = DB::Exception: Cannot attach table
The system cannot attach the specified table, possibly due to syntax errors or permissions.
ClickHouse DB::Exception: Code: 1021, e.displayText() = DB::Exception: Cannot drop database
The system cannot drop the specified database, possibly due to permissions or database locks.
ClickHouse DB::Exception: Code: 1016, e.displayText() = DB::Exception: Cannot delete data
The system cannot delete data from the table, possibly due to permissions.
ClickHouse DB::Exception: Code: 1020, e.displayText() = DB::Exception: Cannot create database
The system cannot create the specified database, possibly due to syntax errors or permissions.
ClickHouse DB::Exception: Code: 1018, e.displayText() = DB::Exception: Cannot optimize table
The system cannot optimize the specified table, possibly due to permissions or table locks.
ClickHouse DB::Exception: Code: 1019, e.displayText() = DB::Exception: Cannot alter table
The system cannot alter the specified table, possibly due to syntax errors or permissions.
ClickHouse DB::Exception: Code: 1017, e.displayText() = DB::Exception: Cannot truncate table
The system cannot truncate the specified table, possibly due to permissions or table locks.
ClickHouse DB::Exception: Code: 48, e.displayText() = DB::Exception: Unknown function
The function used in the query is not recognized by ClickHouse.
ClickHouse DB::Exception: Code: 1015, e.displayText() = DB::Exception: Cannot update data
The system cannot update data in the table, possibly due to schema mismatch or permissions.
ClickHouse DB::Exception: Code: 1011, e.displayText() = DB::Exception: Cannot authenticate
Authentication to the ClickHouse server failed, possibly due to incorrect credentials.
ClickHouse DB::Exception: Code: 1014, e.displayText() = DB::Exception: Cannot insert data
The system cannot insert data into the table, possibly due to schema mismatch or permissions.
ClickHouse DB::Exception: Code: 1013, e.displayText() = DB::Exception: Cannot drop table
The system cannot drop the specified table, possibly due to permissions or table locks.
ClickHouse DB::Exception: Code: 1012, e.displayText() = DB::Exception: Cannot create table
The system cannot create the specified table, possibly due to syntax errors or permissions.
ClickHouse DB::Exception: Code: 1010, e.displayText() = DB::Exception: Cannot connect to server
The client cannot connect to the ClickHouse server, possibly due to network issues or incorrect server address.
ClickHouse DB::Exception: Code: 1009, e.displayText() = DB::Exception: Cannot execute command
The system cannot execute the specified command, possibly due to permissions or incorrect command.
ClickHouse DB::Exception: Code: 1007, e.displayText() = DB::Exception: Cannot read directory
The system cannot read the specified directory, possibly due to permissions.
ClickHouse DB::Exception: Code: 1008, e.displayText() = DB::Exception: Cannot write to directory
The system cannot write to the specified directory, possibly due to permissions.
ClickHouse DB::Exception: Code: 1006, e.displayText() = DB::Exception: Cannot remove directory
The system cannot remove the specified directory, possibly due to permissions or it is not empty.
ClickHouse DB::Exception: Code: 1005, e.displayText() = DB::Exception: Cannot create directory
The system cannot create the specified directory, possibly due to permissions.
ClickHouse DB::Exception: Code: 1003, e.displayText() = DB::Exception: Cannot delete file
The system cannot delete the specified file, possibly due to permissions.
ClickHouse DB::Exception: Code: 1004, e.displayText() = DB::Exception: Cannot rename file
The system cannot rename the specified file, possibly due to permissions or file locks.
ClickHouse DB::Exception: Code: 1002, e.displayText() = DB::Exception: Cannot write to file
The system cannot write to the specified file, possibly due to permissions or disk space.
ClickHouse DB::Exception: Code: 47, e.displayText() = DB::Exception: Unknown identifier
The query references an identifier that does not exist.
ClickHouse DB::Exception: Code: 1000, e.displayText() = DB::Exception: Cannot open file
The specified file cannot be opened, possibly due to permissions or it does not exist.
ClickHouse DB::Exception: Code: 32, e.displayText() = DB::Exception: Syntax error
There is a syntax error in the SQL query.
ClickHouse DB::Exception: Code: 159, e.displayText() = DB::Exception: Limit for number of columns exceeded
The number of columns in the query exceeds the maximum allowed limit.
ClickHouse DB::Exception: Code: 1001, e.displayText() = DB::Exception: Cannot read all data
The data source is incomplete or corrupted.
ClickHouse DB::Exception: Code: 202, e.displayText() = DB::Exception: Cannot parse JSON
The JSON data is malformed or contains errors.
ClickHouse DB::Exception: Code: 241, e.displayText() = DB::Exception: Cannot lock file
The file is locked by another process.
ClickHouse DB::Exception: Cannot parse input: expected 'x', got 'y'
The input data format does not match the expected format.
ClickHouse DB::Exception: Not enough space
The disk space is insufficient for the operation.
ClickHouse DB::Exception: Memory limit (for query) exceeded
The query is consuming more memory than the allocated limit.
ClickHouse DB::Exception: Received from localhost:9000. DB::Exception: Table default.table_name doesn't exist.
The specified table does not exist in the database.
ClickHouse DB::Exception: Too many parts (300). Merges are processing significantly slower than inserts
The number of parts in a table exceeds the optimal threshold, causing slow merges.
ClickHouse DB::Exception: Code: 60, e.displayText() = DB::Exception: Table is read-only
The table is set to read-only mode.

Backed by

Platform

AI OpsAlert Grouping & De-DuplicationPlayBooksKubernetes Bot

Resources

DocumentationGlossaryFun For DevsBlog

Contact

Contact UsAbout UsCareersTerms and ConditionsPrivacy PolicyShipping & and Delivery PolicyCancellation & Refund Policy

Connect

Slack CommunityGithubLinkedInX (Twitter)
Made with ❤️ in Bangalore & San Francisco 🏢

Doctor Droid