You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2021/06/02 14:42:12 UTC
[GitHub] [incubator-doris] HappenLee opened a new issue #5960: [Bug] Null Pointer of Colocate join
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] morningman closed issue #5960: [Bug] Null Pointer of Colocate join
Posted by GitBox <gi...@apache.org>.
morningman closed issue #5960:
URL: https://github.com/apache/incubator-doris/issues/5960
--
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] morningman closed issue #5960: [Bug] Null Pointer of Colocate join
Posted by GitBox <gi...@apache.org>.
morningman closed issue #5960:
URL: https://github.com/apache/incubator-doris/issues/5960
--
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org