Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

SQL Sript fail after upgrade to HIVE ODBC driver 2.6.1

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