[GitHub] [doris] morrySnow opened a new issue, #11220: [Bug] throw exception: Unexpected exception: Failed analysis after expr substitution.

[GitBox]

morrySnow opened a new issue, #11220:
URL: https://github.com/apache/doris/issues/11220

   ### Search before asking
   
   - [X] I had searched in the 
[issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and 
found no similar issues.
   
   
   ### Version
   
   master
   
   ### What's Wrong?
   
   throw exception: Unexpected exception: Failed analysis after expr 
substitution.
   when use lateral view in subquery in where clause
   
   ### What You Expected?
   
   execute query normally
   
   ### How to Reproduce?
   
   ```sql
   
   CREATE TABLE `user_tag_bitmap` (
     `tag_id` bigint(20) NULL COMMENT "标签id",
     `hid` smallint(6) NULL COMMENT "分桶id",
     `user_hash_bitmap` bitmap BITMAP_UNION NULL COMMENT ""
   ) ENGINE=OLAP
   AGGREGATE KEY(`tag_id`, `hid`)
   COMMENT "OLAP"
   DISTRIBUTED BY HASH(`hid`) BUCKETS 3
   PROPERTIES (
   "replication_allocation" = "tag.location.default: 1",
   "in_memory" = "false",
   "storage_format" = "V2");
   
   
   CREATE TABLE `tag_group_width` (
     `device_id` varchar(128) NOT NULL COMMENT "设备id",
     `user_hash` bigint(20) NOT NULL COMMENT "用户hash，通过对hash算法计算device_id生成",
     `uuid` varchar(128) MAX NULL COMMENT "用户uuid",
     `group_1` varchar(32) MAX NULL COMMENT "标签值"
   ) ENGINE=OLAP
   AGGREGATE KEY(`device_id`, `user_hash`)
   COMMENT "OLAP"
   DISTRIBUTED BY HASH(`device_id`) BUCKETS 3
   PROPERTIES (
   "replication_allocation" = "tag.location.default: 1",
   "in_memory" = "false",
   "storage_format" = "V2"
   );  
   
   select * 
   from tag_group_width 
   where user_hash in 
   (
        select user_hash 
        from 
        (
                select bitmap_intersect(user_hash_bitmap) as user_bm 
                from user_tag_bitmap 
                where tag_id in (20001, 30001) and hid=3) t 
                lateral view explode_bitmap(user_bm) tmp as user_hash
        );
        
   ```
   
   ### Anything Else?
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [X] 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