Flink SQL Hive Development Suggestions

Creating a Cluster Connection for FlinkServer to Interconnect with Hive

1. Log in to the FlinkServer web UI as a FlinkServer administrator, choose System Management > Cluster Connection Management. The Cluster Connection Management page is displayed.
2. Click Create Cluster Connection. On the displayed page, enter the cluster connection information and click Test. After the connectivity test is passed, click OK.
   For example, if the cluster connection name is flink_hive, set cluster.name to flink_hive when creating a Hive catalog.

   CREATE CATALOG myhive WITH (   
     'type' = 'hive',   
     'hive-version' = '3.1.0',   
     'default-database' = 'default',   
     'cluster.name' = 'flink_hive' 
   );