0%

报错汇总

Posted on 2021-01-06 Edited on 2021-02-20 In doris

1.1 Can not alter table when there are temp partitions in table

原因是之前进行过改表操作，还没有完成

可以通过SHOW ALTER TABLE COLUMN; 查看改表的进度

1.2 timeout

1	set query_timeout=60;

1.3 Memory exceed limit. Hash join doris

1	SET exec_mem_limit = 8589934592;

1.4 Unexpected exception: No value present

1.5 there is no scanNode Backend doris

1.6 bitmap_union_int cause ‘be’ node hang

1.7 Failed to get scan range, no queryable replica found in tablet

2.1 分区报错

注意：

已经划分好的区间分区，不能在被切分，即分区（1，3），不能被拆分为(1,2)和(2,3)

alter table topic_smart_user_group_detail_2 add partition IF NOT EXISTS p2 values less than (3);
insert into topic_smart_user_group_detail_2 VALUES (2, 1, '1004230612'),(2, 1, '1047296444'),(2, 1, '1053250666');

org.jkiss.dbeaver.model.sql.DBSQLException: SQL 错误 [1064] [42000]: errCode = 2, detailMessage = Syntax error in line 1:
...ISTS p2 values less than (3)
                             ^
Encountered: INTEGER LITERAL
Expected: COMMA

less than () 括号中必须是字符串

alter table topic_smart_user_group_detail_2 add partition IF NOT EXISTS p2 values less than ("3");
insert into topic_smart_user_group_detail_2 VALUES (5, 1, '1004230612'),(5, 1, '1047296444'),(5, 1, '1053250666');

all partitions have no load data
表示没有创建需要的分区

参考资料