____ 3

• asked Aug 22, 2024

There is no scanNode Backend available

FE布置在192.168.11.38上，BE部署在11.37上面。使用DBeaver数据库客户端连接数据库（192.168.11.38:9030）,可以连接到数据库，能看到自己测试时新建的表。打开数据库下用户表时报错SQL 错误 [1105] [HY000]: errCode = 2, detailMessage = There is no scanNode Backend available.[112524: in black list(send fragments fai...

2.0

0 votes

2 answers

454 views

anan0120 15

• asked Aug 22, 2024

自动分区 range 设置不正确，第一次建表成功，同样的语句再创建，检查自动分区的合理性

doris版本：2.1.5 期待结果：设置不正确，是不是就应该就不能创建表成功 mysql> CREATE TABLE awh_test_range_auto ( -> DATE_ID BIGINT NOT NULL COMMENT 'DATE_ID', -> LAST_UPLOAD_TIME DATETIME COMMENT 'LAST_UPLOAD_TIME' -> ) UNIQUE KEY(DATE_ID) -&g...

2.1

0 votes

2 answers

110 views

boview 5

• asked Aug 22, 2024

【已解决】doris-manager 能配置日志清理策略吗

doris-manager 24.0.1版本 webserver/log/下的日志可以配置清理策略吗

manager faq

0 votes

1 answers

182 views

pawnZzz 7

• asked Aug 22, 2024

V2.1.4创建异步物化视图失败

基表 {code...} 错误 Execution failed: Error Failed to execute sql: org.apache.doris.common.AnalysisException: errCode = 2, detailMessage = Syntax error in line 2: ...ATERIALIZED VIEW mv1 BUILD IMMEDIATE REFRESH COMP... ^ Encountered: BUILD Expe...

2.1

0 votes

2 answers

111 views

123117974 82

• asked Aug 21, 2024

doris2.1.5 ，执行sql，be挂掉的问题

执行的sql：select count(1) from dwd_score_test_file where cast(product_field['scoreylbase'] as decimal(12,6)) >12; be报错日志： W20240821 19:52:11.526293 8234 timezone_utils.cpp:94] Meet illegal tzdata file: iso3166.tab. skipped W20240821...

2.1

0 votes

2 answers

262 views

KKWong 3

• asked Aug 21, 2024

SYNC-JOB 是否支持canal集群模式？

canal.server.ip canal.server.port 只支持写canal-server的ip端口吗？ 是否支持写canal集群的zkServer地址？ {code...}

2.0

0 votes

1 answers

68 views

xiutao 3

• asked Aug 21, 2024

Doris Manager将doris1.2版本升级2.0失败或者有问题之后，如何手动回滚

用doris manager升级过程中，没有勾选数据备份，直接滚动升级；升级过程有问题，或者升级后发现问题，该如何手动回滚？

1.2

0 votes

1 answers

129 views

echo 3

• asked Aug 21, 2024

doris升级2.0.3后，catalog的元数据增量同步失败

doris之前版本为1.2.7版本，最近升级到2.0.3版本后，发现之前配置的catalog元数据增量同步一直报错，导致新增的表无法及时通过catalog读取出来，只能refresh catalog才能读到，以下为fe.log日志报错内容： 2024-08-21 15:03:41,276 INFO (org.apache.doris.datasource.hive.event.MetastoreEventsProcessor|27) [MetastoreEventsProce...

2.0

0 votes

1 answers

127 views

gfadweeq 20

• asked Aug 21, 2024

ROUTINE LOAD部分列更新覆盖其他列

表结构： CREATE TABLE biz_pub_data_current_instant ( DATA_ID VARCHAR(32) NOT NULL, RECEIVE_TIME DATETIME NULL DEFAULT CURRENT_TIMESTAMP, I_L1 DECIMAL(20, 5) NULL, I_L2 DECIMAL(20, 5) NULL, I_L3 DECIMAL(20, 5) NULL ) ENGINE=OLAP UNIQUE KEY(DATA_...

2.1

0 votes

2 answers

141 views

etnao 4

• asked Aug 21, 2024

Python3.9 用Arrow Flight SQL读取doris失败

1、安装py包 python3.9 pip install adbc_driver_manager pip install adbc_driver_flightsql pip install pyarrow 2、测试代码 import adbc_driver_manager import adbc_driver_flightsql.dbapi as flight_sql conn = flight_sql.connect(uri="grpc+tcp://192.168...

2.1

0 votes

2 answers

190 views