【已解决】按照Doris Doc中给定的insert overwrite DDL语句,执行报错

Viewed 77
2.0 docs

Doris 版本: 2.0.5 - rc02

执行doris 文档中的insert overwrite语句报错:

insert overwrite

image.png

报错如下:

[HY000][1105] errCode = 2, detailMessage = Please check your sql, we meet an error when parsing.

image.png

CYOSEI33
2 Answers

可以把注释去掉然后执行，就正常了：

CREATE TABLE IF NOT EXISTS test (
  `c1` int NOT NULL DEFAULT "1",
  `c2` int NOT NULL DEFAULT "4"
) ENGINE=OLAP
UNIQUE KEY(`c1`)
PARTITION BY LIST (`c1`)
(
PARTITION p1 VALUES IN ("1","2","3"),
PARTITION p2 VALUES IN ("4","5","6")
)
DISTRIBUTED BY HASH(`c1`) BUCKETS 3
PROPERTIES (
  "replication_allocation" = "tag.location.default: 1",
  "in_memory" = "false",
  "storage_format" = "V2"
);

后续我修改一下文档

zclllyybb361

文档已提交fix pr：https://github.com/apache/doris-website/pull/853

黄海军@SelectDB2556