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

153 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

85 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

133 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

85 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

48 views

baijun 15

• 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

157 views

xiaofan2012 3

• asked Nov 27, 2024

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

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

2.0

0 votes

1 answers

44 views

3

• asked Nov 27, 2024

单独执行SELECT 可以查询出结果，但是创建视图后再查询Unknown column...

fact_broker_score_detail_monthly表结构 CREATE TABLE IF NOT EXISTS dws.fact_broker_score_detail_monthly ( month DATE NOT NULL COMMENT '月份', employee_id CHAR(36) NOT NULL COMMENT '内网人员标识', broker_id CHAR(36) NULL COMMENT '平台经...

2.1

0 votes

1 answers

82 views

Kevin.Shin 19

• asked Nov 27, 2024

已经具有GRANT_PRIV的用户无法创建及授权新用户

Doris 2.0 升级至 2.1.7 升级前是正常的。 给某库管理员授权： {code...} 库管理员创建新用户及赋权时，报错： 通过 show grants for x_admin; 可以看到管理员有GRANT_PRIV：

2.1

0 votes

2 answers

152 views

Jc.Wong 1

• asked Nov 27, 2024

2.1.7 Nullable(Int32)能否修改未Nullable(Int64)

相同的一个sql，在2.0.2上能正确返回，升级2.1.7报错，报错信息如下： 1105 - errCode = 2, detailMessage = (xxx.xxx.xxx.xxx)[INTERNAL_ERROR]output type not match expr type , col name , expected type Nullable(Int64) , real type Nullable(Int32)

2.1

0 votes

1 answers

49 views