[GitHub] [doris] yuxuan-luo opened a new issue, #16481: [Bug] 开启向量化后每次执行查询时 be 都会挂

[via GitHub]

yuxuan-luo opened a new issue, #16481:
URL: https://github.com/apache/doris/issues/16481

   ### Search before asking
   
   - [X] I had searched in the 
[issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no 
similar issues.
   
   
   ### Version
   
   1.1.5，1.2.1
   
   ### What's Wrong?
   
   1.1.5:
   在开启向量化后，查询表后会出错，并且必定会有1个 be 会挂掉
   关闭向量化后，查询能正常
   
   1.2.1
   是否开启向量化，都显示错误结果，查询结果为 0 
   
   ### What You Expected?
   
   可以实现正常查询
   
   ### How to Reproduce?
   
   CREATE TABLE `A` (
       `user_id` int NULL
   ) ENGINE=OLAP
   DUPLICATE KEY(`user_id`)
   DISTRIBUTED BY HASH(`user_id`) BUCKETS 3
   PROPERTIES (
   "replication_allocation" = "tag.location.default: 3",
   "in_memory" = "false",
   "storage_format" = "V2"
   );
   CREATE TABLE `B` (
       `user_id` int NULL
   ) ENGINE=OLAP
   DUPLICATE KEY(`user_id`)
   DISTRIBUTED BY HASH(`user_id`) BUCKETS 3
   PROPERTIES (
   "replication_allocation" = "tag.location.default: 3",
   "in_memory" = "false",
   "storage_format" = "V2"
   );
   CREATE TABLE `C` (
       `user_id` int NULL
   ) ENGINE=OLAP
   DUPLICATE KEY(`user_id`)
   DISTRIBUTED BY HASH(`user_id`) BUCKETS 3
   PROPERTIES (
   "replication_allocation" = "tag.location.default: 3",
   "in_memory" = "false",
   "storage_format" = "V2"
   );
   CREATE TABLE `D` (
       `user_id` int NULL
   ) ENGINE=OLAP
   DUPLICATE KEY(`user_id`)
   DISTRIBUTED BY HASH(`user_id`) BUCKETS 3
   PROPERTIES (
   "replication_allocation" = "tag.location.default: 3",
   "in_memory" = "false",
   "storage_format" = "V2"
   );
   
   WITH `W1` AS (
       SELECT t.user_id
       FROM A t
                JOIN B u
                     ON u.user_id = t.user_id
   ),
        `W2` AS (
            SELECT t.user_id
            FROM `C` t
                     JOIN B u
                          ON u.user_id = t.user_id
            GROUP BY t.user_id
        ),
        `W3` AS (
            SELECT t.user_id
            FROM D t
                     JOIN B u
                          ON u.user_id = t.user_id
            GROUP BY t.user_id
        )
   SELECT COUNT(`dataset_30`.`reg_user_cnt`) AS `u_18efaea722a8747c_2`
   FROM (
            SELECT t1.reg_user_cnt, t2.commit_case_user_cnt, 
t3.watch_live_course_and_commit_case_user_cnt
            FROM (
                     SELECT COUNT(user_id) AS reg_user_cnt, '1' AS flag
                     FROM W1
                 ) t1
                     JOIN (
                SELECT COUNT(user_id) AS commit_case_user_cnt, '1' AS flag
                FROM W2
            ) t2
                          ON t2.flag = t1.flag
                     JOIN (
                SELECT COUNT(t1.user_id) AS 
watch_live_course_and_commit_case_user_cnt, '1' AS flag
                FROM W2 t1
                         JOIN W3 t2
                              ON t2.user_id = t1.user_id
            ) t3
                          ON t3.flag = t1.flag
        ) `dataset_30`
       LIMIT 1000;
   
   ### Anything Else?
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [ ] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of 
Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
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.

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org