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