Uploaded image for project: 'Kylin'
  1. Kylin
  2. KYLIN-3813

don't do push down when both of the children of CompareTupleFilter are CompareTupleFilter with column included

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: v3.0.0-alpha2
    • Component/s: Query Engine
    • Labels:
      None

      Description

      When dynamic column is enabled, kylin will try to push down group by case when to hbase. However, in the following case, the push down should not be enabled, since currently it's not well supported for CompareTupleFilter to have a child of CompareTupleFilter.

      Sample SQL:

      select colA
             case
                 when (colB = (1 = 1)) = (colC = (1 = 1)) then 'B&C'
                 when (colC = (1 = 1)) = (colD = (1 = 1)) then 'C&D'
                 else 'n/a'
             end as phase,
             count(*)
      from T
      where session_date between '2018-08-01' and '2018-08-31'
      group by colA
             case
                 when (colB = (1 = 1)) = (colC = (1 = 1)) then 'B&C'
                 when (colC = (1 = 1)) = (colD = (1 = 1)) then 'C&D'
                 else 'n/a'
             end;
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                yaho Zhong Yanghong
                Reporter:
                yaho Zhong Yanghong
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: