Adding Hive as Catalog

After installing Hive as a service on your cluster, you can add it as a Catalog in SQL Stream Builder (SSB) to use it in Flink DDL.

  • Make sure that you have Hive service on your cluster.
  1. Go to your cluster in Cloudera Manager.
  2. Click SQL Stream Builder from the list of services.
  3. Click SQLStreamBuilder Console.
    The Streaming SQL Console opens in a new window.
  4. Click Data Providers from the main menu.
  5. Click Register Catalog.
    The Add Catalog window appears.
  6. Add a Name to your catalog.
  7. Select Hive from the Catalog Type drop-down.
  8. Click on Add Filter.
    1. Provide a Database and Table filter if you want to select specific tables to use from the catalog.
  9. Click on Validate.
  10. If the validation is successful, click Add Tables.
Hive is added as a Catalog and ready to be used in Flink DDL. The already existing tables in Hive are automatically imported to SSB.