jason 3

• asked Feb 7

length函数返回不是字节数

中国的utf8编码，字节数不应该是6吗？文档中说是返回字节数，例子中返回了字符数

2.1 functions

0 votes

3 answers

78 views

CYOSEI 35

• asked Feb 7

如何查看Doris表中某一个字段占用的磁盘空间大小?

Doris 版本: 2.1.7 Doris 中有没有什么命令来查询Unique Key表中某个字段所占用的磁盘空间大小呢?

2.1

0 votes

1 answers

46 views

Neal_Zzzz 17

• asked Feb 6

【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

45 views

lcc_lcc 1

• asked Feb 6

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

32 views

Jane 3

• asked Feb 6

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

82 views

____ 23

• asked Feb 6

【已解决】这个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

43 views

Doris真的快 7

• asked Feb 5

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

61 views

cpt_doris 19

• asked Feb 5

聚合模型实现AVG，均值

{code...} 聚合模型中，SUM 这个地方怎么实现AVG 直接定义AVG会报错！

3.0

0 votes

2 answers

52 views

cpt_doris 19

• asked Feb 5

kafka拉取数据，如何获取整个json串

CREATE TABLE iot_kafka ( node_id bigint NOT NULL COMMENT '点位 ID', device_time DATETIME NOT NULL COMMENT '时间', device_timestamp bigint NULL COMMENT '时间', uuid varchar(30) NULL COMMENT 'uuid', iot_json STRING N...

3.0

0 votes

1 answers

46 views

cpt_doris 19

• asked Feb 5

物化视图上创建物化视图，报错

----- 创建表 ------- drop table IF EXISTS iot_kafka; CREATE TABLE iot_kafka ( node_id bigint NOT NULL COMMENT '点位 ID', device_time DATETIME NOT NULL COMMENT '时间', device_timestamp bigint NULL COMMENT '时间', uuid varchar(...

3.0 物化视图

0 votes

3 answers

52 views