Questions
Tags
Users
Badges
All Questions
Newest
Active
Unanswered
Frequent
More
Score
View
Card
Compact
lcc_lcc
1
•
asked Feb 7, 2025
创建CREATE CATALOG 失败
CREATE CATALOG cbm_mysql PROPERTIES ( "type"="jdbc", "user"="123", "password"="123", "jdbc_url" = "jdbc:mysql://localhost:3306/test", "driver_url" = "https://repo1....
2.1
0
votes
1
answers
43
views
cpt_doris
19
•
asked Feb 7, 2025
存算分离,数据缓存策略,答疑
[https://doris.apache.org/zh-CN/docs/3.0/compute-storage-decoupled/file-cache] 问题一:数据缓存,这里案例只给了ttl的。如果表不设置file_cache属性,lru策略是自动开启缓存吗? 问题二:file_cache_path 配置了多个路径,是按什么方式使用这么目录的,是用满一个目录之后用另一个目录? 比方说,ssd的目录先在前,hdd的目录在后,那是先用ssd盘? 问题三:如果我A表(小数据量...
decoupled
3.0
0
votes
1
answers
137
views
jason
3
•
asked Feb 7, 2025
length函数返回不是字节数
中国的utf8编码,字节数不应该是6吗?文档中说是返回字节数,例子中返回了字符数
2.1
functions
0
votes
3
answers
90
views
CYOSEI
35
•
asked Feb 7, 2025
如何查看Doris表中某一个字段占用的磁盘空间大小?
Doris 版本: 2.1.7 Doris 中有没有什么命令来查询Unique Key表中某个字段所占用的磁盘空间大小呢?
2.1
0
votes
1
answers
100
views
Neal_Zzzz
17
•
asked Feb 6, 2025
【UDF存在bug】在if语句里,不管哪个分支,udf都会执行到
select if(length(new_owner)=0, null, convert(new_owner)) from dwd_transfers where length(new_owner)=0; 对于UDF函数convert,如果参数长度为0会报错。现在通过if语句,理论上应该返回null,但是仍会走到concert函数报错!!!
2.1
0
votes
2
answers
48
views
lcc_lcc
1
•
asked Feb 6, 2025
CREATE CATALOG 报错[Err] 5087 - errCode = 2, detailMessage = Access denied for user 'cbm' to catalog 'test'
CREATE CATALOG test PROPERTIES ( "type"="jdbc", "user"="*", "password"="", "jdbc_url" = "jdbc:mysql://localhost:3306/test", "driver_url" = "mysql-connector-java-8.0...
2.1
catalog
0
votes
1
answers
43
views
Jane
3
•
asked Feb 6, 2025
doris时区如何修改
system_time_zone="Asia/Shanghai" time_zone="Asia/Shanghai" default_tzfiles_path="/usr/share/zoneinfo/Asia/Shanghai" 我在doris的be和fe配置文件中添加了这三个配置后,用 mysql> show variables like '%time_zone%'; +----------------...
3.0
0
votes
1
answers
190
views
____
23
•
asked Feb 6, 2025
【已解决】这个hll相似度聚合 数据是int类型,采取streamload出现这个问题
loadData是导入数据,导入的colums为dt,name,province,os,id,pv=hll_hash(id) 分隔符是' 建表语句是 create table test_hll( dt date, id int, name char(10), province char(10), os char(10), pv hll hll_union ) Aggregate KEY (dt,id,name,province,os) distributed by h...
2.1
ingestion
0
votes
1
answers
48
views
Doris9
7
•
asked Feb 5, 2025
doris-2.1.5 be启动报错,rocksdb sst文件丢失
doris版本:2.1.5 报错信息: I20250124 10:34:01.112049 36152 olap_meta.cpp:73] [Rocksdb] [db/db_impl_open.cc:1219] DB pointer 0x7ff44d2d1000 W20250124 10:34:01.746953 36153 status.h:412] meet error status: [E-3001]rocks db open failed, reason: Corru...
2.1
0
votes
3
answers
92
views
cpt_doris
19
•
asked Feb 5, 2025
聚合模型实现AVG,均值
{code...} 聚合模型中,SUM 这个地方怎么实现AVG 直接定义AVG会报错!
3.0
0
votes
2
answers
65
views
Prev
Prev
158
159
160
(current)
161
162
Next
Next
Hot Questions
【资料获取】AI- Native 系列直播,聚焦 AI 函数、混合检索、实践落地等
在 Doris 中自定义 UDF 时,若函数名与内置函数重名,调用时必须加上数据库名才能正确执行。如果不希望每次调用都携带数据库名,该如何解决?
1 answers
使用doris查询paimon 执行show databases 直接报错
1 answers
default_replication_num不生效
2 answers
doris2.1.5升级到doris3.0.8,升级后开启ranger,root执行SHOW PROC '/backends' 报没有admin权限
Doris 4.0.3 DorisManager部署问题
1 answers