Hive

16 / 18

Connect to Apache Hive using Tableau




Not able to play video? Try with vimeo

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.

INSTRUCTIONS

Hive - Connecting to Tableau

Tableau is a visualization tool. We can connect to Hive using Tableau and transform data stored in Hive into visually appealing and interactive visualizations.

Hive - Connecting to Tableau - Steps

  • To download Tableau click here.

  • To download Hortonworks Hive ODBC driver for windows click here and for mac OS click here.

Hive - Connecting to Tableau - Hands-on

Let's connect Tableau to Hive.

  • Open tableau.
  • Go to > To a Server > Hortonworks Hadoop Hive.
  • Enter c.cloudxlab.com as Server and port as 10000.
  • Select HiveServer2 as type.
  • Select Username and Password as Authentication.
  • Enter your lab username and password.
  • Click on Sign in and wait for the connection to establish.
  • Type in your database name in schema and press enter. Now select your database.
  • Click on search under the table to list all the tables in your database.
  • Double click on nyse table.
  • Now click on Go to Worksheet.
  • Drag and drop symbol1 to columns and Price High to rows.
  • Click on the Show Me button on the top right corner and select the recommended chart by tableau.
  • Now drag Ymd to filters and select 2009-12-31 then click on OK.
  • Now sort the data points to see the Top 10 values.

Loading comments...