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 2022/07/27 03:19:13 UTC

[GitHub] [doris] siriume opened a new issue, #11238: [Bug] Rows transformed by collect_list in subquery cannot be used

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

   ### 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-8a6c9d8
   
   ### What's Wrong?
   
   SQL:
   ```
   select plat_id,company_id, email 
   from (
       select plat_id,
       company_id,
       collect_list(user_email) email
       from tb_company
       group by plat_id, company_id)
   company
   ```
   error:
   ```
   Execution failed: Error Failed to execute sql: java.sql.SQLException: (conn=95) errCode = 2, detailMessage = Unsupported type 'ARRAY<NOT_NULL(CHAR(-1))>' in '`email`'.
   ```
   
   
   ### What You Expected?
   
   execute succeed
   
   ### How to Reproduce?
   
   _No response_
   
   ### 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-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] cambyzju commented on issue #11238: [Bug] Rows transformed by collect_list in subquery cannot be used

Posted by GitBox <gi...@apache.org>.
cambyzju commented on issue #11238:
URL: https://github.com/apache/doris/issues/11238#issuecomment-1196245586

   Maybe you do not open array flag? 
   How to Open Array Flag:
   `set enable_array_type=true;`


-- 
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] yiguolei commented on issue #11238: [Bug] Rows transformed by collect_list in subquery cannot be used

Posted by GitBox <gi...@apache.org>.
yiguolei commented on issue #11238:
URL: https://github.com/apache/doris/issues/11238#issuecomment-1196220386

   @cambyzju  Could you please have a look at it？


-- 
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] siriume closed issue #11238: [Bug] Rows transformed by collect_list in subquery cannot be used

Posted by GitBox <gi...@apache.org>.
siriume closed issue #11238: [Bug] Rows transformed by collect_list in subquery cannot be used
URL: https://github.com/apache/doris/issues/11238


-- 
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] cambyzju commented on issue #11238: [Bug] Rows transformed by collect_list in subquery cannot be used

Posted by GitBox <gi...@apache.org>.
cambyzju commented on issue #11238:
URL: https://github.com/apache/doris/issues/11238#issuecomment-1196242428

   @siriume please give me your create table SQL, and some test data.
   
   After fix it, I will recheck your case.


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