Functions
- Last Updated: October 7, 2020
- 1 minute read
- DataDirect Connectors
- ODBC
- Cloudera Impala 7.1
- dBase 7.1
- Flat files/Text 7.1
- MySQL 7.1
- Pervasive (Btrieve) 7.1
- XML 7.1
- Documentation
The following tables show how SQL-92 functions are supported in the Impala Query Language. Additional methods may be supported with ODBC Escapes.
| Set Function | Support in Impala SQL |
|---|---|
| Count | Supported |
| AVG | Supported |
| MIN | Supported |
| MAX | Supported |
| SUM | Supported |
| DISTINCT | Supported |
| ALL | Supported |
| Numeric Function | Support in Impala SQL |
|---|---|
| CHAR_LENGTH CHARACTER_LENGTH | Not supported. Use LENGTH(string) instead. |
| Position...In | Not supported |
| BIT_LENGTH(s) | Not supported |
| OCTET_LENGTH(str) | Not supported |
| EXTRACT TIMEZONE_HOUR FROM | Not supported |
| EXTRACT TIMEZONE_MINUTE FROM | Not supported |
| String Function | Support in Impala SQL |
|---|---|
| Substring | Supported |
| Convert … using | Not supported |
| TRIM | Supported. |
| Leading | Not supported. Use LTRIM. |
| Trailing | Not supported. Use RTRIM. |
| Both | Not supported (default behavior of TRIM) |
| Date/Time Function | Support in Impala SQL |
|---|---|
| CURRENT_DATE( ) | Not supported2 |
| CURRENT_TIME( ) | Not supported3 |
| CURRENT_TIMESTAMP | Not supported. Use UNIX_TIMESTAMP()4. |
| System Function | Support in Impala SQL |
|---|---|
| CASE ... END | Supported. |
| COALESCE | Supported. |
| NULLIF | Not supported.5 |
| CAST | Supported. |
1 Supported by ODBC Escapes
2 Supported by ODBC Escapes
3 Supported by ODBC Escapes
4 Supported by ODBC Escapes
5 Supported by ODBC Escapes