Reply
New Contributor
Posts: 1
Registered: ‎03-19-2019

SQL Sript fail after upgrade to HIVE ODBC driver 2.6.1

[ Edited ]

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

 

Announcements