Home Forums Hortonworks Sandbox Tableau and HW's Sandbox

This topic contains 18 replies, has 7 voices, and was last updated by  Claudio Aguirre 1 month, 1 week ago.

  • Creator
    Topic
  • #16392

    Bob Haffner
    Member

    Is it possible to connect to the Sandbox from Tableau? If yes, how?

    Thanks
    Bob

Viewing 18 replies - 1 through 18 (of 18 total)

You must be logged in to reply to this topic.

  • Author
    Replies
  • #56005

    Claudio Aguirre
    Participant

    I have this error after connecting hive from tableau with hortonworks odbc … It happens when i select individual tables –> “tweets” table.
    I don’t have this issue when i open “temperatures” table (also from hive)….is there any issue with tableau and nosql tables?

    I run the query in hive also with “tweets” table and it works great.

    Thanks

    [Hortonworks][HiveODBC] (22) Error from ThriftHiveClient: Query returned non-zero code: 2, cause: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask

    Collapse
    #55461

    Eric Perler
    Participant

    Craig

    I am havin g the exact same issue regarding tableau 8.1 and Hive on HDP 2.1

    Did you ever resolve your issue ?

    Thx!!!!!

    Collapse
    #28084

    Nevermind. I found that I hadn’t installed the 32bit ODBC Driver which Tableau requires.

    http://hortonworks.com/kb/how-to-connect-tableau-to-hortonworks-sandbox/

    Collapse
    #28079

    I have attempted all of these same steps, and am having no success accessing the sandbox using Tableau 8.0

    Results of the ODBC Driver Data Source Test:

    Driver Version: V1.2.0.1005

    Running connectivity tests…

    Attempting connection
    Connection established
    Disconnecting from server

    TESTS COMPLETED SUCCESSFULLY!

    I select the Hortonworks Hadoop Hive Connection in Tableau, and type in the server’s IP address in step 1 (leaving the port untouched), and click connect in step 2 and receive the below message:

    The drivers necessary to connect to this database server are not properly installed. Visit http://www.tableausoftware.com/drivers to download driver setup files.
    [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

    Unable to connect to the server “192.168.24.128″. Check that the server is running and that you have access privileges to the requested database.
    Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database.

    No problems connecting via Excel 2013.

    Any Ideas?

    Collapse
    #16527

    Bob Haffner
    Member

    Bingo! Thanks Carter!

    Also, thanks to Sasha and Yi for all your help!

    Collapse
    #16522

    Carter Shanklin
    Participant

    Bob there is a little configuration widget that ships along with the Hortonworks ODBC driver called Driver Configuration (Windows Key + “Driver Configuration” to launch). Can you try doing the setup through this widget instead of ODBC Admin and see what happens?

    Collapse
    #16519

    Bob Haffner
    Member

    Carter, that helped. Thanks! I was able to get the Test to work in the ODBC Admin and I was able to connect to the Sandbox from Tableau via the generic ODBC.
    I was unable, however, to connect using Hortonworks Hadoop Hive that’s available in Tableau. Times out at 10 seconds. Any ideas?

    Collapse
    #16498

    Carter Shanklin
    Participant

    Bob

    Use hiveserver2 to connect rather than hiveserver1
    Select username authentication and use sandbox as the username
    Use the IP listed on the screen as the endpoint
    In Tableau select Hortonworks as the data source and don’t use generic ODBC

    You don’t need to edit anything in the sandbox to get this working.

    Collapse
    #16423

    Sasha J
    Moderator

    Bob,
    you can ssh to the SandBox (username: root, password: hadoop).
    You need to install PuTty program on windows for ssh.
    file /etc/hive/conf/hive-site.xml is in there.

    Sasha

    Collapse
    #16415

    Bob Haffner
    Member

    Hi Yi,

    If I’m on Windows and I’m running VMware Player, how would I edit that file?

    Thanks
    Bob

    Collapse
    #16412

    Yi Zhang
    Moderator

    Hi Bob,

    Try /etc/hive/conf/hive.conf

    Yi.

    Collapse
    #16411

    Bob Haffner
    Member

    Ok, I do believe its the metastore_conn_timeout of 10 seconds thats causing my latest problem. So how do I change that?

    I see documentation that that setting is contained in hive-site.xml, but I can’t find that file.. I’m guessing because I’m running a sandbox instance.

    Collapse
    #16409

    Bob Haffner
    Member

    I think the answer it staring me in the face :)

    I got a timeout that I need to adjust. most likely metastore_conn_timeout

    I’ll keep on that

    Collapse
    #16408

    Bob Haffner
    Member

    A couple more things

    All (tableau, odbc drivers, sandbox) of this is on one box.

    If I change the Host name or Port number, I get a connect error as opposed to ETIMEDOUT below

    Collapse
    #16407

    Bob Haffner
    Member

    Using Hortonworks Hive ODBC Driver 1.02.00.1005 32 bit version

    Data Source Name: Sample Hortonworks Hive DSN
    Description: Sample Hortonworks Hive DSN
    Host : 192.168.85.128
    Port : 10000
    Database: default
    Hive Server Type: Hive Server 1

    Advanced Options
    Rows Fetched per: 1000
    Default string column: 255
    Use Native Query and Fast SQLPrepare are both unchecked

    Collapse
    #16406

    Sasha J
    Moderator

    Bob,
    what ODBC configuration you provided when setting up connection?

    Sasha

    Collapse
    #16404

    Bob Haffner
    Member

    Thanks Sasha. I installed Tableau and attempted to connect, but was given a ‘no driver ‘ error. I made my way to the driver page on Tableau and was redirected to hortoworks’ driver page. I downloaded the ODBC driver and attempted to set up a connection, but this is what I got. Any ideas?

    Driver Version: V1.2.0.1005

    Running connectivity tests…

    Attempting connection
    Failed to establish connection
    SQLSTATE: HY000[Hortonworks][Hardy] (22) Error from ThriftHiveClient: ETIMEDOUT

    TESTS COMPLETED WITH ERROR.

    Collapse
    #16395

    Sasha J
    Moderator

    Bob,
    it is definitely possible.
    As far as I understand, Tableau should know about namenode and jobtracker locations in order to connect to hadoop cluster.
    You should provide this information and this is it.
    Sandbox shows you IP address for use.

    Hope this helps.
    Thank you!
    Sasha

    Collapse
Viewing 18 replies - 1 through 18 (of 18 total)