HappenLee opened a new issue #5960:
URL: https://github.com/apache/incubator-doris/issues/5960
1. create new table and load data
```
CREATE TABLE `test_bucket` (
`k1` tinyint(4) NULL COMMENT "",
`k2` bigint(20) NULL COMMENT "",
`k3` int(11) NULL COMMENT "",
`k4` bigint(20) NULL COMMENT "",
`k5` decimal(9, 3) NULL COMMENT "",
`k6` char(5) NULL COMMENT "",
`k10` date NULL COMMENT "",
`k11` datetime NULL COMMENT "",
`k7` varchar(20) NULL COMMENT "",
`k8` double NULL COMMENT "",
`k9` float NULL COMMENT ""
) ENGINE=OLAP
DUPLICATE KEY(`k1`, `k2`, `k3`, `k4`, `k5`, `k6`, `k10`, `k11`, `k7`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`k1`) BUCKETS 2
PROPERTIES (
"replication_num" = "1",
"in_memory" = "false",
"storage_format" = "V2"
);
insert into test_bucket select * from test;
```
2. execute a sql
```
SELECT
snvd.k2,
snvd.k3
FROM
(
SELECT
snv.k2,
snv.k3,
snv.k1
FROM
test snv
JOIN test_bucket detail ON detail.k1 = snv.k1 where snv.k1 = 0
) snvd
JOIN [broadcast] (
SELECT
snvc.k2,
snvc.k3,
ds.k1
FROM
test_bucket snvc
JOIN (
SELECT
agsdd.k1,
agsdd.k2,
agsdd.k3
FROM
test_bucket agsdd
) ds ON ds.k1 = snvc.k1
AND ds.k2 = snvc.k2
) detail ON detail.k2 = snvd.k2
AND detail.k3 = snvd.k3;
```
3. The FE cause Exception of null pointer. Because different Fragment have
different bucket sequence scan range.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
