Impala Development Suggestions

Impala SQL Compilation: Implicit Type Conversion Not Supported

When using field values in a query statement for filtering, Impala does not support the implicit type conversion found in Hive for compiling Impala SQL statements.

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, which includes a default timeout duration of 5 minutes. You can customize this duration using the java.sql.DriverManager.setLoginTimeout(int seconds) method, where the parameter is defined in seconds.