ccfeng9 3

• asked Nov 28, 2024

doris如何收缩表？

现象： 我有一张表，会频繁性的insert和delete，一段时间后，发现该表查询、插入速度变慢，重新建的表查询、插入速度很快，考虑是表数据碎片化的问题，如何处置？

3.0

0 votes

3 answers

77 views

3

• asked Nov 28, 2024

apache doris 2.15 版本，当使用insert into select 语法进行数据操作时候，transactions 的running会加1，并且不会转换为finished，会一直处于running的PREPARE状态，

apache doris 2.15 版本，当使用insert into select 语法进行数据操作时候，transactions 的running会加1，并且不会转换为finished，会一直处于running的PREPARE状态，这样导致如果有大批量的insert into select执行时候,running会一直增加，会报current running txns on db 17082 is 1000, larger than limit 1000 ，看有什么好的解...

2.1

0 votes

1 answers

33 views

3

• asked Nov 28, 2024

Doris 2.1.6 资源硬隔离不生效

Doris-2.1.6 资源隔离不生效，be日志报错： I20241127 10:16:56.909916 359976 workload_group.cpp:430] [upsert wg thread pool] cgroup init failed, wg_id= 1, reason=[INTERNAL_ERROR]invalid cgroup path, not find task file I20241127 10:17:26.912139 359976 workl...

resource-admin 2.1

0 votes

1 answers

102 views

5

• asked Nov 28, 2024

Doris通过catalog读取外部paimon表报错

dim> select * from paimon_hdfs.cdc.zs_fet_machine [2024-11-28 10:31:02] [HY000][1105] errCode = 2, detailMessage = (192.168.1.32)[CANCELLED]cur path: hdfs://qzcluster/paimon/cdc.db/zs_fet_machine/bucket-0/data-c213e0b6-bf45-4b9e-a6a6-588...

2.1 catalog

0 votes

2 answers

129 views

Berry 1

• asked Nov 27, 2024

2.1.6版本HDFS RESOURCE 写入路径配置

集群版本2.1.6 HDFS账号没有根目录权限，确认有/user/mpp 路径下完全权限 账号鉴权使用Kerberos认证，连hive也是通的 resource创建语句如下 create RESOURCE "remote_hdfs" PROPERTIES ( "type"="hdfs", "fs.defaultFS"="hdfs://172.1.1.1:8020", "root_path&...

decoupled 2.1 storage

0 votes

1 answers

50 views

Zhouxw 44

• asked Nov 27, 2024

2.1.5，创建索引时报错，errCode = 2, detailMessage = schema change tasks failed on same tablet reach threshold 1

Doris版本2.1.5 目标表有13亿数据 表结构如下 {code...} 两类索创建均有问题， 有时报：errCode = 2, detailMessage = schema change tasks failed on same tablet reach threshold 1 有时报：errCode = 2, detailMessage = schema change tasks failed on same tablet reach threshold 2 有没有一...

2.1

0 votes

1 answers

75 views

1

• asked Nov 27, 2024

3.0.2，grafana doris监控中，BE IO Util指标没显示

操作系统：Ubuntu 22.04.5 LTS 内核版本：4.19.90-0.240102.openeuler.x86_64

3.0

0 votes

3 answers

66 views

gopkg 1

• asked Nov 27, 2024

3.0.2，物化视图创建失败： current join type is LEFT_OUTER_JOIN

doris版本：3.0.2 当创建物化视图的时候，提示如下， {code...} 分区字段为date,是由A表产出。

3.0

0 votes

1 answers

30 views

baijun 11

• asked Nov 27, 2024

2.0.13升级到2.1.7以后，运行两天，开始大面积出现卡顿，各种操作超时

系统大面积卡顿以前，开始出现大量的如下日志： 2024-11-26 19:38:20,459 WARN (thrift-server-pool-75|1020) [MasterImpl.finishTask():97] finish task reports bad. request: TFinishTaskRequest(backend:TBackend(host:10.142.165.4, be_port:9060, http_port:8040, brpc_port:8...

2.1 cluster upgrade

0 votes

2 answers

131 views

xiaofan2012 3

• asked Nov 27, 2024

外表查询oracle是否可以支持xmltype?

doris版本：2.0.9 外表查询oracle功能为啥不支持xmltype呢？是否可以支持？

2.0

0 votes

1 answers

28 views