Updated on 2025-04-15 GMT+08:00

Flink SQL Hive Development Rules

Creating a Table in Hive Before Running the Job

  • If the Flink SQL job cannot find the corresponding table in Hive, an error will be reported. You need to create the corresponding table on the Hive client before running the job.
  • FlinkServer interconnects with Hive through MetaStore. Therefore, the MetaStore function must be enabled for Hive.

Check whether the MetaStore function is enabled for Hive.

Log in to FusionInsight Manager, choose Cluster > Services > Hive. On the displayed page, click the Configurations tab and select All Configurations. Search for hive-ext.dlcatalog.metastore.client.enable, and check whether its value is false.

If the value is false, the MetaStore function is enabled for Hive. If the value is true, the LakeFormation function is enabled for Hive but not the MetaStore function.