生而为人

程序员的自我修养

0%

Posted on Edited on In

1. 复制表

1.1 复制表结构

1.2 复制表数据

Posted on Edited on In

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. 已经划分好的区间分区，不能在被切分，即分区（1，3），不能被拆分为(1,2)和(2,3)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
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
表示没有创建需要的分区

参考资料

  1. Doris建表 FAQ
  2. Hive To Doris 数据同步事故
  3. Doris使用FAQ(持续更新中)