HIVE has a great capability to connect with the reporting solution like Tableau and Qlik. All this property has been garnered by the use of thrift services that allows access to HIVE server over a single port.
Thrift allows the client to access HIVE remotely via programming languages like C++,Java ,Ruby,PHP etc.
⦁ HiveServer2 (HS2) is a service that enables clients to execute queries against Hive.
⦁ HiveServer2 is the successor to HiveServer1 which has been deprecated.
⦁ HS2 supports multi-client concurrency and authentication.
⦁ It is designed to provide better support for open API clients like JDBC and ODBC.
Let us connect the Tableau with the Hive .
Open the Tableau Desktop and you will get a window like this.
Depending upon your Hadoop vendor like Cloudera and Hortonworks ,you can select the server.As i have a cloudera distribution so i have selected Cloudera Hadoop.Once you click on the Cloudera Hadoop .you will get the below window.
Before connecting to any hadoop distribution , we need the required driver, for Cloudera we can get the driver from the below links.
https://www.tableau.com/support/drivers
Once the driver has been installed , kindly submit the details like .
Server - Address on which your hive can be accessed.
Port -10000
Type - Hiveserver2
Authentication - username and password
After filling the details ,click on OK.You will get a similar window.
You can choose you required schema and start the data analysis.
Further Reading :- https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Overview
Thrift allows the client to access HIVE remotely via programming languages like C++,Java ,Ruby,PHP etc.
⦁ HiveServer2 (HS2) is a service that enables clients to execute queries against Hive.
⦁ HiveServer2 is the successor to HiveServer1 which has been deprecated.
⦁ HS2 supports multi-client concurrency and authentication.
⦁ It is designed to provide better support for open API clients like JDBC and ODBC.
Let us connect the Tableau with the Hive .
Open the Tableau Desktop and you will get a window like this.
Depending upon your Hadoop vendor like Cloudera and Hortonworks ,you can select the server.As i have a cloudera distribution so i have selected Cloudera Hadoop.Once you click on the Cloudera Hadoop .you will get the below window.
Before connecting to any hadoop distribution , we need the required driver, for Cloudera we can get the driver from the below links.
https://www.tableau.com/support/drivers
Once the driver has been installed , kindly submit the details like .
Server - Address on which your hive can be accessed.
Port -10000
Type - Hiveserver2
Authentication - username and password
After filling the details ,click on OK.You will get a similar window.
You can choose you required schema and start the data analysis.
Further Reading :- https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Overview
No comments:
Post a Comment