Hive / HCatalog Forum
HIVE catalog issue with ODBC
I have successfully installed odbc driver on my w7 32bit machine.
I can browse through schema (table names, column description), but when it comes to sql query (for example from Microsoft Query), I got errors.
Driver automatically adds catalog name and it is not accepted by hive/hive server. UserGuide (http://hortonworks.com/wp-content/uploads/2013/08/Hortonworks-Hive-ODBC-Driver-User-Guide.pdf) sais that it is normal..
select * from foo
driver query (captured with wireshark)
select foo.id from HIVE.default.foo foo
error thrown by hive server/hive:
error code: ‘40000’
error message: ‘Error while processing statement: FAILED: ParseExeption line: 2:17 cannot recognize input near ‘.’ ‘foo’ ‘foo’ in table source
1) odbc knows the structure, reads it properly, changes * to column name.
2) hive server and CLI don’t undersand HIVE prefix before schema name.
3) same error occurs with manual query (select foo.id from HIVE.default.foo foo) in CLI
any configuration changes on server side needed?
Support from the Experts
A HDP Support Subscription connects you experts with deep experience running Apache Hadoop in production, at-scale on the most demanding workloads.
Become HDP Certified
Real world training designed by the core architects of Hadoop. Scenario-based training courses are available in-classroom or online from anywhere in the world