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.
Loading comments...