向一个表中的临时分区,使用Insert into 语句插入数据时,无法指定字段

Viewed 78

ALTER TABLE db.table1
ADD TEMPORARY PARTITION test_temporary_partition VALUES IN ("test_temporary_partition");

INSERT INTO db.table1 TEMPORARY PARTITION (test_temporary_partition) (col1)
SELECT 'test_temporary_partition' AS col1;

[HY000][1105] errCode = 2, detailMessage = Syntax error in line 1: ...ry_partition) (col1) ^ Encountered: EOF Expected

1 Answers

看报错是语法错误,能发一个完整的案例吗?你的具体的版本是什么?