Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Duplicate
    • 3.0.0
    • None
    • SQL
    • None

    Description

      Definition: "The filter clause extends aggregate functions (sumavgcount, …) by an additional where clause. The result of the aggregate is built from only the rows that satisfy the additional where clause too." [source|https://modern-sql.com/feature/filter]

      Also, PgSQL currently support `filter` while Spark doesn't.

      Attachments

        Issue Links

          Activity

            yumwang Yuming Wang added a comment -

            Duplicate with SPARK-27986?

            yumwang Yuming Wang added a comment - Duplicate with  SPARK-27986 ?
            DylanGuedes Dylan Guedes added a comment -

            Hmm you are correct, there's some overlapping there. However, at some point the JIRA will be fragmented into smaller ones, like one for filter, other for distinct, right?

            DylanGuedes Dylan Guedes added a comment - Hmm you are correct, there's some overlapping there. However, at some point the JIRA will be fragmented into smaller ones, like one for filter, other for distinct, right?
            yumwang Yuming Wang added a comment -

            ok. thank you.

            yumwang Yuming Wang added a comment - ok. thank you.

            People

              Unassigned Unassigned
              DylanGuedes Dylan Guedes
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: