Jiajun Xie created CALCITE-6199:
-----------------------------------
Summary: Trim unused fields for SNAPSHOT and SAMPLE if table has
VIRTUAL column
Key: CALCITE-6199
URL: https://issues.apache.org/jira/browse/CALCITE-6199
Project: Calcite
Issue Type: Improvement
Reporter: Jiajun Xie
Assignee: Jiajun Xie
RelTri not support SNAPSHOT( So do Sample)
* Here is a SQL example
{code:java}
select D, E from VIRTUALCOLUMNS.VC_T1
for system_time as of TIMESTAMP '2011-01-02 00:00:00' {code}
* Before Trimming
{code:java}
LogicalProject(D=[$3], E=[$4])
LogicalSnapshot(period=[2011-01-02 00:00:00])
LogicalProject(A=[$0], B=[$1], C=[$2], D=[$3], $f4=[+($0, 1)])
LogicalTableScan(table=[[CATALOG, VIRTUALCOLUMNS, VC_T1]]){code}
* After Trimming
{code:java}
LogicalSnapshot(period=[2011-01-02 00:00:00])
LogicalProject(D=[$3], $f4=[+($0, 1)])
LogicalTableScan(table=[[CATALOG, VIRTUALCOLUMNS, VC_T1]]){code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
