Let us try to connect Tableau from Hive. We can connect to Hive using Tableau and transform data stored in Hive into visually appealing and interactive visualizations. Let's connect to Hive using Tableau. Download Tableau Desktop from the link displayed on the screen. Tableau is a paid software. If you are a student, you can get one-year free license. After the download is finished, install the Tableau desktop. We will connect to Hive using Hive ODBC driver. Download Hortonworks Hive ODBC driver for your operating system using the link displayed on the screen. After the download is finished, install it.
Let's use tableau. Visualize top 10 stocks with highest opening price as on Dec 31, 2009
Open tableau and select hortonworks Hadoop hive as data source. Specify server as c.cloudxlab.com and port as 10000. Select "HiveServer2" as a type and "Username and password" as authentication. Provide your lab username and password. Click on "sign in" and wait for connection to establish. Type in your database name in schema and press enter. Now select your database. Click on "search" under 'table' to list all the tables in your database. Double click on "nyse" table and click on "go to worksheet". Drag and drop "Symbol1" to columns and "Price high" to rows. Click on "show me" on the top right corner and select the recommended chart by Tableau. Now we will fiter the data for "Dec 31, 2009". Drag "Ymd" to Filters and select "2009-12-31" from the list and click on ok. Now sort the data points to see the stocks with the highest opening price. Stocks CME, CEO and CLB have the highest opening price on Dec 31, 2009.
Tableau is a visualization tool. We can connect to Hive using Tableau and transform data stored in Hive into visually appealing and interactive visualizations.
To download Tableau click here.
To download Hortonworks Hive ODBC driver for windows click here and for mac OS click here.
Let's connect Tableau to Hive.
c.cloudxlab.com as Server and port as 10000.HiveServer2 as type.Username and Password as Authentication. Sign in and wait for the connection to establish. nyse table.Go to Worksheet.symbol1 to columns and Price High to rows.Show Me button on the top right corner and select the recommended chart by tableau.Ymd to filters and select 2009-12-31 then click on OK.
Please login to comment
7 Comments
I am also getting the same error. There is no option of 'type' to write 'HiveServer2'.
Upvote ShareCan you share the screenshot of the error?
Upvote Shareit got resolved....I was selecting the binary option in the transport dropdown....but SASL should be selected
1 Upvote ShareHi ,
Facing same issue. Not getting option for Hiveserver2 as Type. Even I am not getting option for SASL.
Could you please help me out to resolve this issue?
Upvote ShareHere are a few things you can try to troubleshoot the issue:
Check the version of Tableau you are using. HiveServer2 and SASL authentication may not be available in older versions of Tableau. If you are using an older version, you may need to upgrade to a newer version.
Check the type of driver you are using to connect to Hive. Make sure you are using a driver that supports HiveServer2 and SASL authentication.
Check the configuration of your Hive server. Make sure HiveServer2 is enabled and that SASL authentication is configured properly.
It's also worth noting that if you are using Tableau Desktop on a Windows machine, you may need to install the Hive ODBC driver to access HiveServer2 and SASL authentication.
Upvote ShareI am getting this error: An error occurred while communicating with the Hortonworks Hadoop Hive data source 'Untitled Data Source'
Upvote ShareUnable to connect to the server. Check that the server is running and that you have access privileges to the requested database.
Error Code: B19090E0
There was an unknown connection error to the database. The error message below has additional information, but you might need to ask the database administrator to review the database logs.
[Hortonworks][ThriftExtension] (5) Error occurred while contacting server: No more data to read.. This could be because you are trying to establish a non-SSL connection to a SSL-enabled server.
Unable to connect to the Hortonworks Hadoop Hive server "c.cloudxlab.com". Check that the server is running and that you have access privileges to the requested database.