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