Skip to content

some correlated subqueries are not yet implemented #2555

@gz

Description

@gz
create table spreadsheet (
    id int64 not null primary key,
    cell text not null,
    mentions int64 array 
) with ('materialized' = 'true');

create materialized view spreadsheet_view as
select
    s.id,
    s.cell,
    array(
        select sp.cell
            from unnest(s.mentions) as mention_id
            join spreadsheet sp on sp.id = mention_id
        ) as mentioned_cells
from spreadsheet s;

fails with

 Not yet implemented:
rel#185:LogicalCorrelate.(left=LogicalTableScan#1,right=Collect#183,correlation=$cor0,joinType=inner,requiredColumns={2})

Metadata

Metadata

Assignees

Labels

SQL compilerRelated to the SQL compiler

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions