Questions
Tags
Users
Badges
All Questions
Newest
Active
Unanswered
Frequent
More
Score
View
Card
Compact
lilili
3
•
asked Sep 18, 2024
创建 Catalog mysql 异步物化视图
创建doris表 join Catalog mysql表的物化视图时报这个问题需要修改doris的参数,还是mysql的,修改那些参数
mtmv
2.1
0
votes
1
answers
124
views
weiyf
7
•
asked Sep 18, 2024
求助大佬,doris2.1.4 detail模型在带有日分区的like条件下count很慢,要好几秒,怎么解决?
建表语句如下,数据按日分区。 {code...} 其中url字段是string类型,有建了ngram索引,这个p20240909分区里大概有12GB的数据,实际执行起来好几秒,至少5S以上,但是不加count(*)很快,直接 *的话是毫秒级。我按这样去查过一个800MB左右的分区p20240902也要1S多。 分区数据分布情况,未来数据还会逐步增加,整个表总数据7000多万,按理也不是非常大,我这个是一个网站访问的日志记录。 p20240827 79.179 MB p2024...
2.1
0
votes
4
answers
166
views
soaker
3
•
asked Sep 17, 2024
doris-3.0 aggstate 建表报错
Doris version doris-3.0.1 照文档操作,建表报错。 set enable_agg_state=true; create table aggstate( k1 int null, k2 agg_state<sum(int)> generic, k3 agg_state<group_concat(string)> generic ) aggregate key (k1) distributed BY hash(k1) buckets...
3.0
0
votes
1
answers
59
views
polarbearmx
6
•
asked Sep 17, 2024
doris2.1.5 查询视图,加limit出错。把limit删除后能正常执行。
be日志有如下错误:
2.1
0
votes
1
answers
55
views
CookingBoy
5
•
asked Sep 15, 2024
hive catalog中metastore连接数
集群从一个Master一个Observer升级到3FE的高可用架构后,连接hive metastore的连接数过多导致hive metastore服务的线程池被打满 通过netstat查看hive metastore相关的连接,3个FE基本都有100+的连接,目前的集群配置了3个hive catalog,配置了元数据事件订阅 想请问下hive metastore的连接是否有配置连接池,以及如何降低其连接数
2.1
catalog
0
votes
2
answers
104
views
SmallZengRespository
3
•
asked Sep 15, 2024
doris建表问题
CREATE TABLE IF NOT EXISTS test_db.example_tbl_range_more_123 ( user_id LARGEINT NOT NULL COMMENT "用户id", date DATE NOT NULL COMMENT "数据灌入日期时间", city VARCHAR(20) COMMENT "用户所在城市", age SMALLINT COMMENT "用户年龄",...
2.1
0
votes
1
answers
73
views
syb853553110
5
•
asked Sep 15, 2024
Doris 1.2.8 版本, es中指定了 _routing 属性,使用es catalog 查询报错
Doris 版本: 1.2.8 es的mapping中指定如下属性 {code...}
catalog
0
votes
1
answers
81
views
文小誉123
15
•
asked Sep 14, 2024
kettle9.3表输入配置doris2.1.5大数据量表卡主问题
在使用kettle9.3配置表输入读取doris2.1.5中的表,表数据量2亿左右,kettle表输入预览正常,但点击确定整个kettle会卡主,无响应,但在doris2.1.4上正常,请问是否是不兼容kettle9.3
2.1
0
votes
1
answers
137
views
luo.dong
5
•
asked Sep 14, 2024
如何修改默认的Default collation配置?
通过SHOW CHARACTER SET;命令查看显示 Charset Description Default collation Maxlen utf8mb4 UTF-8 Unicode utf8mb4_0900_bin 4 通过SHOW COLLATION;命令查看显示 Collation Charset Id Default Compiled Sortlen utf8mb4_0900_bin utf8mb4 309 Yes Yes 1 utf8mb3_general_c...
2.1
0
votes
3
answers
133
views
____
11
•
asked Sep 14, 2024
missed_versions is empty, spec_version 728, max_version 729, tablet_id 2126496
doris-2.1.5 单副本 异常的tabletid=2126496 正常的tabletid=2126498 查询报错 1105 - errCode = 2, detailMessage = (log-be-0.log-be-internal.doris.svc.cluster.local)[CANCELLED]missed_versions is empty, spec_version 728, max_version 729, tablet_id 2126496 检查副...
2.1
0
votes
1
answers
192
views
Prev
Prev
279
280
281
(current)
282
283
Next
Next
Hot Questions
Doris 4.0.4 物化视图异常问题反馈
升级至4.0.4后物化视图查询失败,报错Insert a plan into targetGroup but differ in logicalproperties
存算分离下groupcommit是否支持wal写入
doris3.0.8运行insert into 任务报错send fragments failed. io.grpc.StatusRuntimeException: DEADLINE_EXCEEDED
Doris 4.x 预热
doris-manager CVE-2025-4123漏洞
1 answers