Knox Hive Server2 JDBC

Configuring Knox Hive Server2 JDBC as a Connection

To connect:

1. Select "+" and then select "Connection" or right-click on a folder in the File Browser and select "Create New" and then "Connection". A 'New Connection' tab opens.
    or 
2. Select "Knox Hive Server2 1.2.1.x" from the drop-down in section 'Type' and confirm with "Next". The section 'Connection Details' opens.
   
   
3. Enter the "Hive Server2 Connection" JDBC URL. 
   
   
4. If needed, enter a database name or pattern to limit the amount of listed databases during an import.
   
   
5. If needed, enter connection valid custom properties.
   
   
6. Select "SSL with user provided truststore" from the drop-down, upload the "Truststore" file with the Apache Knox SSL certificate and and enter the password for truststore. 
   INFO: Leave the field blank when truststore is not password protected.
   
   
7. Enter the "Topology" path. 
   INFO: Entering "/" leads to the default topology path.
   
   
8. Select "Basic (LDAP) - username/password authentication" from the drop-down, enter your credentials and confirm with "Next". The section 'Save' opens.
   
   
9. If needed, enter a description and confirm with "Save". The dialog 'Save Connection' opens.
    
10. Select the name and storage location of the connection and confirm with "Save". The Knox Hive Server2 JDBC connection is saved. 
    

Disabling the Know Hive Server2 Plug-In

To disable the Knox Hive Server2 plugin:

1. Open the "Admin" tab and select "Plug-ins". The plug-in overview page opens. 
    
2. Click the "Disable Extension" icon of the extension "Know Hive Server2 1.2.1.x". The extension is disabled. 
   INFO: To enable the extension, click on the icon again.