Hive metastore

Steps for connecting to Hive Meta Store:

  1. Login to your Zetaris environment.
  2. Click on 'NDP Fabric Builder' on the top left side of the screen.
  3. Click on the plus button next to 'Hive Meta Store'.
  4. A pop-up will appear. Fill all the details in the pop-up and click 'Next'.
    1. Metastore name : Can be any name
    2. JDBC URL : JDBC URL of hive metastore
    3. JDBC Username : Your hive username
    4. JDBC Password : Your hive password
    5. Prefix : Can be anything name. This field is optional

  5. Select the database you want to register. If no database is selected, all the databases will be registered.
  6. Click 'Register'.
  7. A newly created hive connection will appear under 'Hive Meta Store'.

  8. Hive tables can be previewed by clicking on 'Preview' button.
  9. As a quick test, you can navigate to the 'Schema Store View' tab, and run a similar SQL query shown below.