Skip to main content
Version: v2

Connecting to Hive

Before starting

Before you begin, learn how to Connect Data Sources in Canner Enterprise.

Step 1: Create data sources

You can create a data source through the following two operations. The first is to click the "+" button on the sidebar Data Source or click the Create a Data Source button on the Overview page to create.

1_hive

Step 2: Set connection information

In the pop-up window form, fill in and set the connection information, and click Submit to send.

3_hive

  • Name: database name, for display, can be modified later
  • Data Source Type: database type, please select Hive
  • URL: Please fill in <thrift>://<host>:<port> format
  • Hadoop core-site.xml File: upload core-site.xml configuration file
  • Hadoop hdfs-site.xml File: upload hdfs-site.xml configuration file
  • Authentication Type: Choose None or Kerberos authentication method; if you choose Kerberos authentication method, you need to upload the configuration file below
    • HDFS Client Principal: Fill in the format such as nn/hadoop.docker.com@EXAMPLE.COM
    • Metastore Service Principal: Fill in the format such as nn/hadoop.docker.com@EXAMPLE.COM
    • Metastore Client Principal: Fill in the format such as nn/hadoop.docker.com@EXAMPLE.COM
    • Hive Metastore Keytab File: upload the Hive Metastore Keytab configuration file
    • HDFS Keytab File: upload Hive Metastore Keytab configuration file
    • Kerberos Config File: upload HDFS Keytab configuration file
  • Enable View: If enabled, the View from the Hive Metastore will be synchronized
  • Explore Timeout: If Hive contains a large number of Tables, it is recommended to increase this parameter so that the Explorer can wait for a longer time

Step 3: Complete the build

After submitting, you will jump back to the list page after a while and see Hive appearing in the data source list.

4_hive