You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "gojumprope (via GitHub)" <gi...@apache.org> on 2023/04/17 04:35:58 UTC

[GitHub] [doris] gojumprope opened a new issue, #18727: [Bug] explode_split unable to split NULL value, return empty result

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

   ### 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.2.3
   
   ### What's Wrong?
   
   explode_split unable to split NULL value, return empty result
   
   ### What You Expected?
   
   should return rows with null result 
   
   
   
   
   
   ### How to Reproduce?
   
   select k1, e1 from 
   (
   	SELECT 2 k1, NULL k2
   ) a
   lateral view explode_split(k2, ',') tmp1 as e1 
   
   result: 
   ![image](https://user-images.githubusercontent.com/38604290/232378859-b16aae24-763b-4e26-8f86-87a695c96dba.png)
   
   
   expected: 
   ![image](https://user-images.githubusercontent.com/38604290/232378913-cdbfe95d-fe6e-47db-ae1a-5ce45987def4.png)
   
   
   
   ### Anything Else?
   
   documentation shows working but not working in reality
   ![image](https://user-images.githubusercontent.com/38604290/232378978-c0952e2f-95e2-4575-af1e-9f81898bca03.png)
   
   ### 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-unsubscribe@doris.apache.org.apache.org

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] [doris] absoluteharam commented on issue #18727: [Bug] explode_split unable to split NULL value, return empty result

Posted by "absoluteharam (via GitHub)" <gi...@apache.org>.
absoluteharam commented on issue #18727:
URL: https://github.com/apache/doris/issues/18727#issuecomment-1521263294

   Please update the documentation as well on the explode_split_outer. Thanks!


-- 
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-unsubscribe@doris.apache.org

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] [doris] HappenLee closed issue #18727: [Bug] explode_split unable to split NULL value, return empty result

Posted by "HappenLee (via GitHub)" <gi...@apache.org>.
HappenLee closed issue #18727: [Bug] explode_split unable to split NULL value, return empty result
URL: https://github.com/apache/doris/issues/18727


-- 
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-unsubscribe@doris.apache.org

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] [doris] HappenLee commented on issue #18727: [Bug] explode_split unable to split NULL value, return empty result

Posted by "HappenLee (via GitHub)" <gi...@apache.org>.
HappenLee commented on issue #18727:
URL: https://github.com/apache/doris/issues/18727#issuecomment-1517490515

   use `explode_split_outer `


-- 
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-unsubscribe@doris.apache.org

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