参考：
https://nightlies.apache.org/flink/flink-docs-release-1.16/zh/docs/dev/table/hive-compatibility/hiveserver2/#endpoint-options
https://nightlies.apache.org/flink/flink-docs-release-1.17/zh/docs/dev/table/hive-compatibility/hiveserver2/#endpoint-options

要点：
Endpoint Options
Below are the options supported when creating a HiveServer2 Endpoint instance with YAML file or DDL.

Key         Required         Default         Type         Description
sql-gateway.endpoint.type
        required         "rest"         List<String>         Specify which endpoint to use, here should be 'hiveserver2'.
sql-gateway.endpoint.hiveserver2.catalog.hive-conf-dir
        required         (none)         String         URI to your Hive conf dir containing hive-site.xml. The URI needs to be supported by Hadoop FileSystem. If the URI is relative, i.e. without a scheme, local file system is assumed. If the option is not specified, hive-site.xml is searched in class path.
sql-gateway.endpoint.hiveserver2.catalog.default-database
        optional         "default"         String         The default database to use when the catalog is set as the current catalog.
sql-gateway.endpoint.hiveserver2.catalog.name
        optional         "hive"         String         Name for the pre-registered hive catalog.
sql-gateway.endpoint.hiveserver2.module.name
        optional         "hive"         String         Name for the pre-registered hive module.
sql-gateway.endpoint.hiveserver2.thrift.exponential.backoff.slot.length
        optional         100 ms         Duration         Binary exponential backoff slot time for Thrift clients during login to HiveServer2,for retries until hitting Thrift client timeout
sql-gateway.endpoint.hiveserver2.thrift.host
        optional         (none)         String         The server address of HiveServer2 host to be used for communication.Default is empty, which means the to bind to the localhost. This is only necessary if the host has multiple network addresses.
sql-gateway.endpoint.hiveserver2.thrift.login.timeout
        optional         20 s         Duration         Timeout for Thrift clients during login to HiveServer2
sql-gateway.endpoint.hiveserver2.thrift.max.message.size
        optional         104857600         Long         Maximum message size in bytes a HS2 server will accept.
sql-gateway.endpoint.hiveserver2.thrift.port
        optional         10000         Integer         The port of the HiveServer2 endpoint.
sql-gateway.endpoint.hiveserver2.thrift.worker.keepalive-time
        optional         1 min         Duration         Keepalive time for an idle worker thread. When the number of workers exceeds min workers, excessive threads are killed after this time interval.
sql-gateway.endpoint.hiveserver2.thrift.worker.threads.max
        optional         512         Integer         The maximum number of Thrift worker threads
sql-gateway.endpoint.hiveserver2.thrift.worker.threads.min
        optional         5         Integer         The minimum number of Thrift worker threads