Adding Hive as Catalog

You need to add Hive as a Catalog using the Streaming SQL Console in SQL Stream Builder (SSB) to create Hive tables with Flink DDL.

  • Make sure that you have Hive service on your cluster.
  • Make sure that you have the right permissions set in Ranger.
  1. Navigate to the Streaming SQL Console.
    1. Go to your cluster in Cloudera Manager.
    2. Select SQL Stream Builder from the list of services.
    3. Click SQLStreamBuilder Console.
    The Streaming SQL Console opens in a new window.
  2. Click Data Providers from the main menu.
  3. Click Register Catalog.
    The Add Catalog window appears.
  4. Add a Name to your catalog.
  5. Select Hive from the Catalog Type drop-down.
  6. Click on Add Filter.
    1. Provide a Database and Table filter if you want to select specific tables to use from the catalog.
  7. Click on Validate.
  8. 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.