Hortonworks Sandbox Forum

Sandbox 2.1 32-bit ODBC Error

  • #53371
    Marc Sardello
    Participant

    Installed Sandbox 2.1 and followed the tutorial to install the ODBC driver. Configured per the tutorial with user hue and no password. In my application I am using to connect, I am able to test the connection successfully, and also see the tables and fields. When I try to pull data though, I get the following error:

    ERROR [HY000] [Hortonworks] [HiveODBC] (35) Error from Hive: error code: ‘40000’ error message: ‘Error while compiling statement: FAILED: HiveAccessControlException Permission denied. Principal [name=hue, type=USER] does not have the following privileges on Object [type=TABLE_OR_VIEW, name=default.sample_07]: [SELECT]’.
    I’ve seen a similar post or two with no responses. Anybody have any ideas on this one?

    Thanks in advance for any help!

    Regards,
    Marc

to create new topics or reply. | New User Registration

  • Author
    Replies
  • #53496
    Dave
    Moderator

    Hi Marc,

    As discussed, try using root / hadoop and hive / hive
    Also look in /var/log/messages to see if you can see if the connection is coming in, and check in /tmp/hive/ for hive logs which may show the connection.

    Thanks

    Dave

    #53507
    Marc Sardello
    Participant

    Neither root / hadoop or hive / hive seem to work either. From the application I am using to connect, I can actually select my DSN, and test the connection successfully. Next, I am able to browse tables and modify a query if needed. But, then when I save this back to my application… essentially executing the pull, I get this same error message.

    Marc

    #53554
    Dave
    Moderator

    Hi Marc,

    Can you try connecting to hive server and/or hiveserver2 directly? (And not to your application?)
    Let me know if this works as it could be that your application is having the issue (from the sounds of things)
    If the driver was not working – then you would not be able to browse, modify etc.

    Thanks

    Dave

    #53555
    Dave
    Moderator

    Hi Marc,

    Can you try connecting to hive server and/or hiveserver2 directly? (And not to your application?)
    Let me know if this works as it could be that your application is having the issue (from the sounds of things)
    If the driver was not working – then you would not be able to browse, modify etc.

    Thanks

    Dave

    #53562
    Marc Sardello
    Participant

    I was able to resolve this issue this morning by going in and grating permissions to hue for the specific table. Using Hive… input:

    grant SELECT on table <table name> to user hue

    Not sure why this is necessary, but it appears to work.

    Thanks,
    Marc

    #53976
    Markus F
    Participant

    I have the same problem. but even when trying

    grant SELECT on table <table name> to user hue

    I am not able to get data.

    For the password combinations. Do I need to change also the UID in the .odbc.ini file to a certain username? Now it is set to “hue”.
    I also tried the password-combinations in the ODBC connection:

    Username/login: hive/hive, root/hadoop, hive/blank, hadoop/blank, sandbox/blank

    Also …it doesnt matter which password combination I chose, I will see the tables and the fields of the tables. But I am not able to retrieve data.
    The ODBC driver runs on a mac.

    #53978
    Markus F
    Participant

    I have also checked /etc. There are .pipeout file written in /tmp/hive/ for hive logs after trying to retrieve the data from the table.

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

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.

Enterprise Support »

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

Training »

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.