-
Notifications
You must be signed in to change notification settings - Fork 109
some correlated subqueries are not yet implemented #2555
Copy link
Copy link
Open
Labels
SQL compilerRelated to the SQL compilerRelated to the SQL compiler
Description
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})
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
SQL compilerRelated to the SQL compilerRelated to the SQL compiler