Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-19851

Add support for EVERY and ANY (SOME) aggregates

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.1.0
    • Fix Version/s: 3.0.0
    • Component/s: PySpark, SQL
    • Labels:
      None

      Description

      Add support for EVERY and ANY (SOME) aggregates.

      • EVERY returns true if all input values are true.
      • ANY returns true if at least one input value is true.
      • SOME is equivalent to ANY.

      Both aggregates are part of the SQL standard.

        Attachments

          Issue Links

          relates to

          Improvement - An improvement or enhancement to an existing feature or task. SPARK-17322 'ANY n' clause for SQL queries to increase the ease of use of WHERE clause predicates

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved
          links to

          Pull request #17194 [Github] Pull Request #17194 (ptkool)

          Pull request #17648 [Github] Pull Request #17648 (ptkool)

          Pull request #22047 [Github] Pull Request #22047 (dilipbiswal)

          Pull request #22797 [Github] Pull Request #22797 (dilipbiswal)

          Pull request #22809 [Github] Pull Request #22809 (dilipbiswal)

            Activity

              People

              • Assignee:
                dkbiswal Dilip Biswal
                Reporter:
                ptkool Michael Styles
              • Votes:
                1 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: