SR 2.1、Hive 3.1.3
建表语句：
CREATE EXTERNAL RESOURCE “hive”
PROPERTIES (
“type” = “hive”,
“hive.metastore.uris” = “thrift://192.168.24.96:9083”
);
CREATE EXTERNAL TABLE test02 (
u string COMMENT ‘资产账户’,
bizdt string COMMENT ‘业务日期’,
prodname string COMMENT ‘产品名称’,
prodno string COMMENT ‘产品代码’,
prodtypecd string COMMENT ‘产品类别代码’,
limitqtty decimal(26,4) COMMENT ‘限售数量’,
limitmrktval decimal(26,4) COMMENT ‘限售市值’,
impawnflag int COMMENT ‘质押标志’,
trademrkt int COMMENT ‘交易市场’
) ENGINE=HIVE
PROPERTIES (
“resource” = “hive”,
“database” = “app_data”,
“table” = “test02”
);
报错信息：
com.starrocks.common.DdlException: get hive table from meta store failed: Your client does not appear to support insert-only tables. To skip capability checks, please set metastore.client.capability.check to false. This setting can be set globally, or on the client for the current metastore session. Note that this may lead to incorrect results, data loss, undefined behavior, etc. if your client is actually incompatible. You can also specify custom client capabilities via get_table_req API.
at com.starrocks.external.hive.HiveMetaClient.getTable(HiveMetaClient.java:137) ~[starrocks-fe.jar:?]
at com.starrocks.external.hive.HiveRepository.getTable(HiveRepository.java:112) ~[starrocks-fe.jar:?]
at com.starrocks.catalog.HiveTable.validate(HiveTable.java:358) ~[starrocks-fe.jar:?]
at com.starrocks.catalog.HiveTable.(HiveTable.java:110) ~[starrocks-fe.jar:?]
at com.starrocks.catalog.Catalog.createHiveTable(Catalog.java:4258) ~[starrocks-fe.jar:?]
at com.starrocks.catalog.Catalog.createTable(Catalog.java:3075) ~[starrocks-fe.jar:?]
at com.starrocks.qe.DdlExecutor.execute(DdlExecutor.java:115) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.handleDdlStmt(StmtExecutor.java:909) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.execute(StmtExecutor.java:429) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:268) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:415) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:651) ~[starrocks-fe.jar:?]
at com.starrocks.mysql.nio.ReadListener.lambda$handleEvent$417(ReadListener.java:55) ~[starrocks-fe.jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_232]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_232]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_232]
请问这个设置在哪里做？