Updated on 2022-08-16 GMT+08:00

Suggestions

Impala SQL Compilation - Implicit Type Conversion Not Supported

If the query statements use the field value for filtering, the implicit type conversion similar to Hive cannot be used to compile Impala SQL.

Impala example:

select * from default.tbl_src where id = 10001;
select * from default.tbl_src where name = 'TestName';

Hive example (implicit type conversion supported):

select * from default.tbl_src where id = '10001';
select * from default.tbl_src where name = TestName; 

In the tbl_src table, the id field is of the Int type and the name field is of the String type.

JDBC Timeout Limit

Impala uses the Hive JDBC whose implementation has a timeout limit. The default value is 5 minutes. You can set the value using java.sql.DriverManager.setLoginTimeout (int seconds). The unit of seconds is second.