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