Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-6199

Trim unused fields for SNAPSHOT and SAMPLE if table has VIRTUAL column

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.37.0
    • None

    Description

      RelFieldTrimmer not support SNAPSHOT( So do Sample)

      • Here is a SQL example
        select D, E from VIRTUALCOLUMNS.VC_T1 
        for system_time as of TIMESTAMP '2011-01-02 00:00:00' 
      • Before Trimming
        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]])
      • After Trimming
        LogicalSnapshot(period=[2011-01-02 00:00:00])
          LogicalProject(D=[$3], $f4=[+($0, 1)])
            LogicalTableScan(table=[[CATALOG, VIRTUALCOLUMNS, VC_T1]])

      Attachments

        Issue Links

          Activity

            People

              jiajunbernoulli Jiajun Xie
              jiajunbernoulli Jiajun Xie
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: