HIVE catalog issue with ODBC

to create new topics or reply. | New User Registration

This topic contains 0 replies, has 1 voice, and was last updated by  Radosław Stankiewicz 1 year, 9 months ago.

  • Creator
    Topic
  • #39225

    Hi,
    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..

    my query:
    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

    my conclusions:
    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?
    help? :)

You must be to reply to this topic. | Create Account

Hortonworks Data Platform
The Hortonworks Data Platform is a 100% open source distribution of Apache Hadoop that is truly enterprise grade having been built, tested and hardened with enterprise rigor.
Get started with Sandbox
Hortonworks Sandbox is a self-contained virtual machine with Apache Hadoop pre-configured alongside a set of hands-on, step-by-step Hadoop tutorials.
Modern Data Architecture
Tackle the challenges of big data. Hadoop integrates with existing EDW, RDBMS and MPP systems to deliver lower cost, higher capacity infrastructure.