[ 
https://issues.apache.org/jira/browse/CALCITE-6411?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17849313#comment-17849313
 ] 

Caican Cai edited comment on CALCITE-6411 at 5/24/24 2:30 PM:
--------------------------------------------------------------

[~julianhyde] Hello. I'm very sorry to bother you. I read the comments that 
collect is used to convert operators such as ARRAY and MAP, but I tried it and 
didn't seem to get the results I wanted.
{code:java}
select array(select \"department_id\" from \"department\"){code}
result:
{code:java}
EnumerableProject(EXPR$0=[ARRAY({
LogicalProject(department_id=[$0])
  JdbcTableScan(table=[[foodmart, department]])
})])
  EnumerableValues(tuples=[[{ 0 }]])
 {code}
 Is the Collect Operator not completed? I can't seem to find a suitable sql to 
validate my results


was (Author: JIRAUSER302115):
[~julianhyde] Hello, Is the Collect Operator not completed?  I can't seem to 
find a suitable sql to test

> Support Collect in ToLogicalConverter
> -------------------------------------
>
>                 Key: CALCITE-6411
>                 URL: https://issues.apache.org/jira/browse/CALCITE-6411
>             Project: Calcite
>          Issue Type: Improvement
>          Components: core
>    Affects Versions: 1.37.0
>            Reporter: Caican Cai
>            Priority: Minor
>             Fix For: 1.38.0
>
>
> Support Collect operator expression convert to Logical in ToLogicalConverter.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to