Oracle Cloud Infrastructure Documentation

Connecting to Unsecure Clusters with no Kerberos or SSL Using HiveServer2

  1. Open the navigation menu and click Analytics & AI. Under Analytics, click 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. Click the instance name.
  4. Click Analytics Home Page.
  5. Click 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. Click Save.