zjg2024 1

• asked Nov 7, 2024

doris 创建oracle catalog 暂无数据

3.0 catalog

0 votes

1 answers

25 views

z404289981 21

• asked Nov 7, 2024

2.0版本明细表使用bitmap类型建表报错

建表语句 CREATE TABLE metric_table ( datekey INT NULL, hour INT NULL, tt INT NULL, device_id BITMAP NOT NULL ) ENGINE=OLAP DUPLICATE KEY(datekey, hour, tt) DISTRIBUTED BY RANDOM BUCKETS AUTO PROPERTIES ( "replication_allocation" = "...

2.1 2.0

0 votes

1 answers

23 views

huanyuan 1

• asked Nov 7, 2024

新手小白，序列化问题及数据过滤

我是从Oracle读取的数据，在进行数据输入到Doris中出现问题，sink配置如下， 还有另一个问题，报太多数据被过滤，如下： 如何解决？

2.0

0 votes

3 answers

29 views

郭明昊 11

• asked Nov 7, 2024

Doris3.0.2，执行一个sql,三个be都挂了

3.0.2 存算分离 {code...} sql SELECT gridHash as hash, t.update_time, t3.full_name as regionName, t2.area_name, t2.name as code, t2.address, t4.longitude, t4.latitude, element_at(alarm_reason_list,ARRAY_POSITION(alarm_list,gridHash)) as reason f...

3.0

0 votes

3 answers

260 views

dingjn 7

• asked Nov 7, 2024

【已解决】2.1.6可以直接升级3.0.2的存算一体吗？是否建议这么做

2.1.6可以直接升级3.0.2的存算一体吗，我看jdk从8改到17，其余的按照升级教程升级就行了吗？？

3.0 upgrade

0 votes

1 answers

109 views

leox 3

• asked Nov 7, 2024

doris写入报错，报too many transactions

新手小白遇到doris问题，求大佬解答： W1107 15:22:45.671013 2843966 tablets_channel.cpp:493] tablet writer write failed, tablet_id=27279850, txn_id=163670139, err=[E-233] W1107 15:22:45.671020 2843966 txn_manager.cpp:154] too many transactions: 102, limit: ...

ingestion 1.2

0 votes

2 answers

63 views

frey 13

• asked Nov 7, 2024

Agg 表 单表查询，数据范围小的时候反而性能很慢，数据范围大的时候很快

Doris版本：2.0.3 在一张聚合表上查询的时候，如果查询一个季度数据，数据量几十万条，几十毫秒就返回了。查询本月数据，大概50条，反而30秒才返回。 建表语句： CREATE TABLE dw_job_fee_consumption_details ( START_TIME datetime(6) NULL COMMENT '', QUEUE_TIME datetime(6) NULL COMMENT '', CLUSTER_ID DEC...

query performance 2.0

0 votes

2 answers

45 views

Jambo 3

• asked Nov 7, 2024

(fe)[CANCELLED]failed to send brpc when exchange

查询超时的报错，fe,be节点全都在线 Caused by: java.sql.SQLException: (conn=17372) errCode = 2, detailMessage = (fe) [CANCELLED]failed to send brpc when exchange, error=Host is down, error_text=[E110]Fail to read from Socket{id=1017 fd=552 addr=be2:8060:59...

query 2.0

0 votes

3 answers

75 views

王艳忠 42

• asked Nov 7, 2024

show frontends 的master节点 host 为主机名 怎么能让他固定成ip呢

2.1

0 votes

2 answers

26 views

zengyongchuan 31

• asked Nov 7, 2024

用catalog + JSON_EXTRACT 查询 mysql的时，不能用where 条件过虑

doris 版本：2.1.5 mysql:5.7.30 在使用 catalog 查询 mysql中的的表时，使用 json_extract 抽取 text 字段类型的 数组数据，如：['xxx','xxxx']，如果把 json_extract 放在 where 条件中，则不能返回任何数据，如下： select id, JSON_UNQUOTE(JSON_EXTRACT(key_names, '$.[0]')), JSON_EX...

2.1

0 votes

2 answers

25 views