hive catalog如何才能支持insert语句

Viewed 60

我生成了一个hive catalog, 查询数据没有问题,但是insert时报如下错误,如何解决?
'hive_krb' is not allowed in 'NativeInsertStmt'

mysql> insert into hive_krb.`default`.employee values(4,'emp4',332,'ggsssddd');
ERROR 1105 (HY000): errCode = 2, detailMessage = External catalog 'hive_krb' is not allowed in 'NativeInsertStmt'

我也看了优化器,配置是正常的:

mysql> show variables like "%planner%";
+-------------------------------------------+-------+---------------+---------+
| Variable_name                             | Value | Default_Value | Changed |
+-------------------------------------------+-------+---------------+---------+
| enable_fallback_to_original_planner       | true  | true          | 0       |
| enable_variant_access_in_original_planner | false | false         | 0       |
| experimental_enable_nereids_planner       | true  | true          | 0       |
+-------------------------------------------+-------+---------------+---------+
3 rows in set (0.01 sec)

1 Answers

执行这个命令再插入试试

set global enable_nereids_dml=true