Enrollments Open for Advanced Certification Courses on Data Science, ML & AI by E&ICT Academy IIT RoorkeeApply Now
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.
Let's connect Tableau to Hive.
c.cloudxlab.comas Server and port as
Username and Passwordas Authentication.
Sign inand wait for the connection to establish.
Go to Worksheet.
symbol1to columns and
Price Highto rows.
Show Mebutton on the top right corner and select the recommended chart by tableau.
Ymdto filters and select
2009-12-31then click on
No hints are availble for this assesment
Answer is not availble for this assesment