Questions
Tags
Users
Badges
All Questions
Newest
Active
Unanswered
Frequent
More
Score
View
Card
Compact
1
•
asked Nov 7, 2024
Doris2.1.6中使用Arrow Flight SQL协议
Hi各位,我已经安装了Doris2.1.6,想使用Arrow Flight SQL协议,按照官网的示例我编写了一段python代码,python代码中主要写了一个select语句从数据库获取290万数据,执行程序消耗了90秒左右,与使用pymysql库消耗的时间差的不多。然而我看网络上一些人获取100万数据只用了3秒,是我的使用方式有问题吗,或者有什么配置需要开启吗,希望有人能够解答,谢谢。 建表语句: CREATE TABLE load_data ( region_code...
2.1
query
0
votes
2
answers
139
views
zjg2024
1
•
asked Nov 7, 2024
doris 创建oracle catalog 暂无数据
3.0
catalog
0
votes
1
answers
26
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
24
views
huanyuan
1
•
asked Nov 7, 2024
新手小白,序列化问题及数据过滤
我是从Oracle读取的数据,在进行数据输入到Doris中出现问题,sink配置如下, 还有另一个问题,报太多数据被过滤,如下: 如何解决?
2.0
0
votes
3
answers
31
views
郭明昊
21
•
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
274
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
110
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
65
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
48
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
95
views
王艳忠
42
•
asked Nov 7, 2024
show frontends 的master节点 host 为主机名 怎么能让他固定成ip呢
2.1
0
votes
2
answers
28
views
Prev
Prev
155
156
157
(current)
158
159
Next
Next
Hot Questions
【用户案例】Apache Doris 在菜鸟的大规模业务场景落地实践
1 answers
upsert流UNIQUE KEY里主键修改,doris查询有两条数据,请问针对主键修改有什么方案?
type:LOAD_RUN_FAIL; msg:errCode = 2, detailMessage = type:LOAD_RUN_FAIL; msg:errCode = 2,
profile显示不完整
Doris manager web是否可以管理doris opertor部署的doris集群?
1 answers
tablet异常是怎么导致的?
2 answers