Apache Doris 中文技术论坛
Questions Tags Users Badges

PipelineX 引擎,多BE节点环境下,由于fragment内部 local exchange的拆分,local shuffle 数据分发出现错乱,导致SQL结果错误。

Asked May 9 Modified Jan 1, 0001
Viewed 35
2.1
CREATE TABLE test1
   ( id VARCHAR(20), 
    c1 int
   )
ENGINE=OLAP
DUPLICATE KEY( id )
COMMENT "OLAP" 
DISTRIBUTED BY HASH( id ) BUCKETS  auto
PROPERTIES (
    "replication_num" = "1" 
);

insert into test1 values ('a',1);

SELECT c1 FROM test1 GROUP BY c1 HAVING  EXISTS(SELECT 1)   
INTERSECT  
SELECT c1 FROM test1;
edited Jan 1, 0001
Jaron1
asked May 9
1 Answers

错误的结果显示是啥呀?

edited Jan 1, 1970
Arch196
answered May 9
Related Questions
FE 不稳定影响正常查询
2 answers
已经创建的自动分区表无法读取fe配置中修改过的autobucket_max_buckets,导致自动分区表的新分区无法按照fe的新配置自动调整buckets
2 answers
doris的be奔溃,版本2.1.7
1 answers
报错: Failed to get scan range, no queryable replica found in tablet
1 answers
求助!x2doris同步经常中断
1 answers
Doris开启了2阶段提交,且事务已经被清理了,如何判断最近一次的ckp对应的事务是否正常提交了

Terms of service Privacy policy

Powered by Answer - the open-source software that powers Q&A communities.
Made with love © 2025 Apache Doris 中文技术论坛.