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

Not optimal subqueries due to a "*" in them

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 1.25.0
    • None
    • jdbc-adapter
    • None

    Description

      Run a query  which should be distributed into sub-queries onto multiple schemas through JDBC adapter,  for example 

      select ft.id, ft.c11, tt.c41   from sch1.foo ft   join   sch2.tab tt  on ft.id = tt.id   

      Calcite will make two sub-queries like SELECT * FROM "TAB" ORDER BY "ID"  and SELECT * FROM "FOO" ORDER BY "ID"  which are not optimal due to an excessive columns data requested

       

      Attachments

        Activity

          People

            Unassigned Unassigned
            rrrrrr111 Roman Churganov
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated: