Support Questions
Find answers, ask questions, and share your expertise

SQL Sript fail after upgrade to HIVE ODBC driver 2.6.1

New Contributor

Hi All,

 

We recently upgraded to HIVE ODBC version 2.6.1 from version 2.5.24. Post upgrade old sql script does not work anymore and we have to add table prefix for sql to work. Is there s a setting that can desable table prefix requirement in vr 2.6.1.

 

Script that work in 2.5.24

--------------------------------

SQL SELECT `column_name` 
FROM HIVE.`db_name`.`table_name`;

--------------------------------

 

 

Script that work in 2.6.1

--------------------------------

SQL SELECT `table_name.column_name` 
FROM HIVE.`db_name`.`table_name`;

--------------------------------

 

Regards,

Animesh Kumar