Details

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • v2.4.0
    • Query Engine
    • None

    Description

      The expression can be as follows:

      1. a 1*col 1 + a 2*col 2 + ... + a n*col n + b, if sum(col 1),sum(col 2),...sum(col n) are defined
      2. case when filter 1 then expr 1
        when filter 2 then expr 2
        ...
        else expr N
        end, if filter 1,filter 2, ... filter N-1, and expr 1,expr 2,...expr N are supported

      There's a constraint for the filter. That is it's able to push down the related filters in case when.

      Attachments

        1. KYLIN-3359-Hive-query.png
          45 kB
          Shao Feng Shi
        2. KYLIN-3359-Kylin-query.png
          70 kB
          Shao Feng Shi

        Issue Links

          Activity

            People

              yaho Zhong Yanghong
              yaho Zhong Yanghong
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: