第一步：创建主键模型表（建表语句如下）
CREATE TABLE test (
lo_orderkey int(11) NOT NULL COMMENT “”,
lo_linenumber int(11) NOT NULL COMMENT “”,
lo_orderdate int(11) NOT NULL COMMENT “”,
lo_custkey int(11) NOT NULL COMMENT “”,
lo_partkey int(11) NOT NULL COMMENT “”,
lo_suppkey int(11) NOT NULL COMMENT “”,
lo_orderpriority varchar(16) NOT NULL COMMENT “”,
lo_shippriority int(11) NOT NULL COMMENT “”,
lo_quantity int(11) NOT NULL COMMENT “”,
lo_extendedprice int(11) NOT NULL COMMENT “”,
lo_ordtotalprice int(11) NOT NULL COMMENT “”,
lo_discount int(11) NOT NULL COMMENT “”,
lo_revenue int(11) NOT NULL COMMENT “”,
lo_supplycost int(11) NOT NULL COMMENT “”,
lo_tax int(11) NOT NULL COMMENT “”,
lo_commitdate int(11) NOT NULL COMMENT “”,
lo_shipmode varchar(11) NOT NULL COMMENT “”
) ENGINE=OLAP
PRIMARY KEY(lo_orderkey,lo_linenumber , lo_orderdate)
COMMENT “OLAP”
PARTITION BY RANGE(lo_orderdate)
(PARTITION p1 VALUES [("-2147483648"), (“19930101”)),
PARTITION p2 VALUES [(“19930101”), (“19940101”)),
PARTITION p3 VALUES [(“19940101”), (“19950101”)),
PARTITION p4 VALUES [(“19950101”), (“19960101”)),
PARTITION p5 VALUES [(“19960101”), (“19970101”)),
PARTITION p6 VALUES [(“19970101”), (“19980101”)),
PARTITION p7 VALUES [(“19980101”), (“19990101”)))
DISTRIBUTED BY HASH(lo_orderkey) BUCKETS 48
PROPERTIES (
“replication_num” = “3”,
“colocate_with” = “groupa1”,
“in_memory” = “false”,
“storage_format” = “DEFAULT”
);
第二步：增加字段（语句如下）
alter table test add column col_test varchar(15) ;
第三步：插入数据
set query_timeout=3600;
insert into test(lo_orderkey,lo_linenumber,lo_custkey,lo_partkey,lo_suppkey,lo_orderdate,lo_orderpriority,lo_shippriority,lo_quantity,lo_extendedprice,lo_ordtotalprice,lo_discount,lo_revenue,lo_supplycost,lo_tax,lo_commitdate,lo_shipmode,col_test) select lo_orderkey,lo_linenumber,lo_custkey,lo_partkey,lo_suppkey,lo_orderdate,lo_orderpriority,lo_shippriority,lo_quantity,lo_extendedprice,lo_ordtotalprice,lo_discount,lo_revenue,lo_supplycost,lo_tax,lo_commitdate,lo_shipmode,‘test update’ from lineorder where lo_orderkey=1 and lo_linenumber=1;
界面报错：ERROR 1064 (HY000): Execute timeout
BE WARN日志显示如下（同时BE节点均挂掉）
F1111 22:03:08.546356 1934 column_aggregate_func.cpp:599] Check failed: false bad agg method NONE for column: col_test
请问有哪位大佬知道是哪边的问题，该如何解决么？谢谢~