[I] [Bug] Multiple subqueries executing Lateral VIEW explore_ Split causes data to return null [doris]

Wed, 17 Jan 2024 01:58:30 -0800 


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

   ### 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
   
   2.0.3
   
   ### What's Wrong?
   
   Multiple subqueries executing Lateral VIEW explore_ Split causes data to 
return null
   `SELECT
     `t4`.`57CE5E02901753F7_06a28`,
     `t4`.`57CE5E02520653F7_06a28`,
     `t4`.`65F695F4519253F7_06a28`,
     `t4`.`65E5671F659C6760_06a28`,
     `t4`.`57CE5E027A7A683C_06a28`,
     `t4`.`57CE5E02767E520653F7_06a28a4`,
     `t4`.`65705B575C0F657070B9_06a28a4`,
     `t4`.`qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq_`,
     `t4`.`5F88591A7B2653F7_06a28`,
     `t4`.`57CE5E02901753F7_62C65206884C7ED3679C_06a28a5a17a39`,
     `ltv4`.`57CE5E02901753F7_62C65206884C7ED3679C1_06a28a5a17a39`
   FROM
     (
       SELECT
         `fise21`.`57CE5E02901753F7_06a28` AS `57CE5E02901753F7_06a28`,
         `fise21`.`57CE5E02520653F7_06a28` AS `57CE5E02520653F7_06a28`,
         `fise21`.`65F695F4519253F7_06a28` AS `65F695F4519253F7_06a28`,
         `fise21`.`65E5671F659C6760_06a28` AS `65E5671F659C6760_06a28`,
         `fise21`.`57CE5E027A7A683C_06a28` AS `57CE5E027A7A683C_06a28`,
         `fise21`.`57CE5E02767E520653F7_06a28a4` AS 
`57CE5E02767E520653F7_06a28a4`,
         `fise21`.`65705B575C0F657070B9_06a28a4` AS 
`65705B575C0F657070B9_06a28a4`,
         `fise21`.`qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq_` AS 
`qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq_`,
         `fise21`.`5F88591A7B2653F7_06a28` AS `5F88591A7B2653F7_06a28`,
         `fise21`.`57CE5E02901753F7_62C65206884C7ED3679C_06a28a5a17a39` AS 
`57CE5E02901753F7_62C65206884C7ED3679C_06a28a5a17a39`
       FROM
         (
           SELECT
             `t2`.`57CE5E02901753F7_06a28`,
             `t2`.`57CE5E02520653F7_06a28`,
             `t2`.`65F695F4519253F7_06a28`,
             `t2`.`65E5671F659C6760_06a28`,
             `t2`.`57CE5E027A7A683C_06a28`,
             `t2`.`57CE5E02767E520653F7_06a28a4`,
             `t2`.`65705B575C0F657070B9_06a28a4`,
             `t2`.`qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq_`,
             `t2`.`5F88591A7B2653F7_06a28`,
             `ltv2`.`57CE5E02901753F7_62C65206884C7ED3679C_06a28a5a17a39`
           FROM
             (
               SELECT
                 `fise01`.`57CE5E02901753F7_06a28` AS `57CE5E02901753F7_06a28`,
                 `fise01`.`57CE5E02520653F7_06a28` AS `57CE5E02520653F7_06a28`,
                 `fise01`.`65F695F4519253F7_06a28` AS `65F695F4519253F7_06a28`,
                 `fise01`.`65E5671F659C6760_06a28` AS `65E5671F659C6760_06a28`,
                 `fise01`.`57CE5E027A7A683C_06a28` AS `57CE5E027A7A683C_06a28`,
                 `fise01`.`57CE5E02767E520653F7_06a28a4` AS 
`57CE5E02767E520653F7_06a28a4`,
                 `fise01`.`65705B575C0F657070B9_06a28a4` AS 
`65705B575C0F657070B9_06a28a4`,
                 `fise01`.`qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq_` AS 
`qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq_`,
                 `fise01`.`5F88591A7B2653F7_06a28` AS `5F88591A7B2653F7_06a28`
               FROM
                 (
                   SELECT
                     `t0`.`57CE5E02901753F7_06a28`,
                     `t0`.`57CE5E02520653F7_06a28`,
                     `t0`.`65F695F4519253F7_06a28`,
                     `t0`.`65E5671F659C6760_06a28`,
                     `t0`.`57CE5E027A7A683C_06a28`,
                     `t0`.`57CE5E02767E520653F7_06a28a4`,
                     `t0`.`65705B575C0F657070B9_06a28a4`,
                     `t0`.`qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq_`,
                     `t0`.`5F88591A7B2653F7_06a28`
                   FROM
                     `ods_42378777c342d2da36d05db875393811` `t0`
                 ) `fise01`
             ) `t2` LATERAL VIEW explode_split(`t2`.`57CE5E02901753F7_06a28`, 
',') `ltv2` AS `57CE5E02901753F7_62C65206884C7ED3679C_06a28a5a17a39`
         ) `fise21`
     ) `t4` LATERAL VIEW explode_split(`t4`.`57CE5E02901753F7_06a28`, ',') 
`ltv4` AS `57CE5E02901753F7_62C65206884C7ED3679C1_06a28a5a17a39``
     
   
![image](https://github.com/apache/doris/assets/45192870/209c3701-f5dc-4ed1-a2d9-60aae3016bd5)
   
   
   ### What You Expected?
   
   Return to normal data
   
   ### How to Reproduce?
   
   
[ods_42378777c342d2da36d05db875393811_202401171756.csv](https://github.com/apache/doris/files/13961463/ods_42378777c342d2da36d05db875393811_202401171756.csv)
   1、Import the above files
   2、execute query
   `SELECT
     `t4`.`57CE5E02901753F7_06a28`,
     `t4`.`57CE5E02520653F7_06a28`,
     `t4`.`65F695F4519253F7_06a28`,
     `t4`.`65E5671F659C6760_06a28`,
     `t4`.`57CE5E027A7A683C_06a28`,
     `t4`.`57CE5E02767E520653F7_06a28a4`,
     `t4`.`65705B575C0F657070B9_06a28a4`,
     `t4`.`qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq_`,
     `t4`.`5F88591A7B2653F7_06a28`,
     `t4`.`57CE5E02901753F7_62C65206884C7ED3679C_06a28a5a17a39`,
     `ltv4`.`57CE5E02901753F7_62C65206884C7ED3679C1_06a28a5a17a39`
   FROM
     (
       SELECT
         `fise21`.`57CE5E02901753F7_06a28` AS `57CE5E02901753F7_06a28`,
         `fise21`.`57CE5E02520653F7_06a28` AS `57CE5E02520653F7_06a28`,
         `fise21`.`65F695F4519253F7_06a28` AS `65F695F4519253F7_06a28`,
         `fise21`.`65E5671F659C6760_06a28` AS `65E5671F659C6760_06a28`,
         `fise21`.`57CE5E027A7A683C_06a28` AS `57CE5E027A7A683C_06a28`,
         `fise21`.`57CE5E02767E520653F7_06a28a4` AS 
`57CE5E02767E520653F7_06a28a4`,
         `fise21`.`65705B575C0F657070B9_06a28a4` AS 
`65705B575C0F657070B9_06a28a4`,
         `fise21`.`qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq_` AS 
`qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq_`,
         `fise21`.`5F88591A7B2653F7_06a28` AS `5F88591A7B2653F7_06a28`,
         `fise21`.`57CE5E02901753F7_62C65206884C7ED3679C_06a28a5a17a39` AS 
`57CE5E02901753F7_62C65206884C7ED3679C_06a28a5a17a39`
       FROM
         (
           SELECT
             `t2`.`57CE5E02901753F7_06a28`,
             `t2`.`57CE5E02520653F7_06a28`,
             `t2`.`65F695F4519253F7_06a28`,
             `t2`.`65E5671F659C6760_06a28`,
             `t2`.`57CE5E027A7A683C_06a28`,
             `t2`.`57CE5E02767E520653F7_06a28a4`,
             `t2`.`65705B575C0F657070B9_06a28a4`,
             `t2`.`qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq_`,
             `t2`.`5F88591A7B2653F7_06a28`,
             `ltv2`.`57CE5E02901753F7_62C65206884C7ED3679C_06a28a5a17a39`
           FROM
             (
               SELECT
                 `fise01`.`57CE5E02901753F7_06a28` AS `57CE5E02901753F7_06a28`,
                 `fise01`.`57CE5E02520653F7_06a28` AS `57CE5E02520653F7_06a28`,
                 `fise01`.`65F695F4519253F7_06a28` AS `65F695F4519253F7_06a28`,
                 `fise01`.`65E5671F659C6760_06a28` AS `65E5671F659C6760_06a28`,
                 `fise01`.`57CE5E027A7A683C_06a28` AS `57CE5E027A7A683C_06a28`,
                 `fise01`.`57CE5E02767E520653F7_06a28a4` AS 
`57CE5E02767E520653F7_06a28a4`,
                 `fise01`.`65705B575C0F657070B9_06a28a4` AS 
`65705B575C0F657070B9_06a28a4`,
                 `fise01`.`qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq_` AS 
`qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq_`,
                 `fise01`.`5F88591A7B2653F7_06a28` AS `5F88591A7B2653F7_06a28`
               FROM
                 (
                   SELECT
                     `t0`.`57CE5E02901753F7_06a28`,
                     `t0`.`57CE5E02520653F7_06a28`,
                     `t0`.`65F695F4519253F7_06a28`,
                     `t0`.`65E5671F659C6760_06a28`,
                     `t0`.`57CE5E027A7A683C_06a28`,
                     `t0`.`57CE5E02767E520653F7_06a28a4`,
                     `t0`.`65705B575C0F657070B9_06a28a4`,
                     `t0`.`qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq_`,
                     `t0`.`5F88591A7B2653F7_06a28`
                   FROM
                     `ods_42378777c342d2da36d05db875393811` `t0`
                 ) `fise01`
             ) `t2` LATERAL VIEW explode_split(`t2`.`57CE5E02901753F7_06a28`, 
',') `ltv2` AS `57CE5E02901753F7_62C65206884C7ED3679C_06a28a5a17a39`
         ) `fise21`
     ) `t4` LATERAL VIEW explode_split(`t4`.`57CE5E02901753F7_06a28`, ',') 
`ltv4` AS `57CE5E02901753F7_62C65206884C7ED3679C1_06a28a5a17a39``
   
   ### 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

Reply via email to