Manage the Hive Connector
This applies to: Visual Data Discovery
The SymphonyData DiscoveryHive connector lets you access the data available in Hive storage using the Symphony client. It can connect to both Hive on Tez and Hive on Tez with LLAP, depending on the JDBC URL you provide (see Connect to Hive below). The Symphony Hive connector supports Hive versions 2.1 through 3.1.
Before you can establish a connection from Symphony to Hive storage, a connector server needs to be installed and configured. See Manage Connectors and Connector Servers for general instructions and Connect to Hive for details specific to the Hive connector.
After setting up the connector, create data sources that specify the necessary connection information and identify the data you want to use. See Manage Visual Data Discovery Data Sources for more information. After you set up your data sources, create dashboards, self service reports, and visuals from the data in these data sources.
Feature Support
Connector support for specific features is shown in the following table.
Key: Y - Supported; N - Not Supported; N/A - not applicable
Feature | Supported? |
---|---|
Y |
|
Y |
|
Y |
|
Y |
|
Y |
|
N/A |
|
Y |
|
Y |
|
Y |
|
Y |
|
Y |
|
Y |
|
Y |
|
Y |
|
N/A |
|
N/A |
|
Y |
|
Y |
|
Y |
|
N/A |
|
Y |
|
Y |
|
Y |
|
Y |
|
Y |
Connect to Hive
To establish a connection to Hive, you must specify a JDBC URL on the Connection page of your Symphony data source definition for the Hive connection.
Specify the JDBC URL for Hive.
If authentication has been set up, provide the user name and password.
If required, specify the Hive/YARN queue name in the Queue Name box.
Specify the server timezone. If the timezone of your Hive server is in UTC, leave the Server Timezone box blank. Otherwise, specify the timezone abbreviation in all caps for correct handling the time data (for example, EST, EDT, or CST).
Select Validate to test the connection.
To connect to Hive LLAP, the JDBC URL you must specify is different. If you use Hortonworks Data Platform (HDP), you can copy the URL from Ambari. See https://docs.cloudera.com/HDPDocuments/HDP3/HDP-3.1.4/performance-tuning/content/hive_connect_clients_to_llap.html.
See also Connect to Hive Sources on A Kerberized HDP Cluster.
Troubleshooting
If you run into a warning message that is displayed when you try to open a dashboard based on a Hive data source, see Resolve the Hive Timeout Warning Message.
Comments
0 comments
Please sign in to leave a comment.