Oracle Cloud Infrastructure Documentation

Connecting to Unsecure Clusters with no Kerberos or SSL Using HiveServer2

  1. Open the navigation menu and select Analytics & AI. Under Analytics, select Analytics Cloud.
  2. To connect to an Oracle Analytics Cloud instance, select the compartment in which you created the instance.

    If needed, create an instance. See Creating an OAC Instance.

  3. Select the instance name.
  4. Select Analytics Home Page.
  5. Select Create, and then select Connection.
  6. Select Apache Hive.
  7. Enter a name for the connection, and then enter the remaining details with the following specifics for Hive:
    • Authentication Type: Select Basic
    • Host: Enter the HiveServer2 node (un0) public IP address
    • Port: Enter 10000
    • Username: Enter hive
    • Password: Enter hive
    • Authentication: Select Always use these credentials
  8. Select Save.