Tableau and HW's Sandbox

Home › Forums › Hortonworks Sandbox › Tableau and HW's Sandbox

This topic contains 14 replies, has 4 voices, and was last updated by  Bob Haffner 2 months, 2 weeks ago.

  • Creator
    Topic
  • March 4, 2013 at 7:56 am #16392

    Bob Haffner
    Member

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

    Thanks
    Bob

  • Creator
    Topic
Viewing 14 replies - 1 through 14 (of 14 total)

You must be logged in to reply to this topic.

  • Author
    Replies
  • March 5, 2013 at 10:46 am #16527

    Bob Haffner
    Member

    Bingo! Thanks Carter!

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

    Collapse
    March 5, 2013 at 10:15 am #16522

    Carter Shanklin
    Member

    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
    March 5, 2013 at 9:48 am #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
    March 4, 2013 at 9:55 pm #16498

    Carter Shanklin
    Member

    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
    March 4, 2013 at 2:14 pm #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
    March 4, 2013 at 1:22 pm #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
    March 4, 2013 at 1:02 pm #16412

    yi zhang
    Member

    Hi Bob,

    Try /etc/hive/conf/hive.conf

    Yi.

    Collapse
    March 4, 2013 at 12:36 pm #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
    March 4, 2013 at 11:58 am #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
    March 4, 2013 at 11:47 am #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
    March 4, 2013 at 11:45 am #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
    March 4, 2013 at 11:23 am #16406

    Sasha J
    Moderator

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

    Sasha

    Collapse
    March 4, 2013 at 10:49 am #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
    March 4, 2013 at 9:01 am #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
  • Author
    Replies
Viewing 14 replies - 1 through 14 (of 14 total)