Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-30374 Feature Parity between PostgreSQL and Spark (ANSI/SQL)
  3. SPARK-32777

Aggregation support aggregate function with multiple foldable expressions.

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 3.1.0
    • 3.1.0
    • SQL
    • None

    Description

      Spark SQL exists a bug show below:

      spark.sql(
        " SELECT COUNT(DISTINCT 2), COUNT(DISTINCT 2, 3)")
        .show()
      +-----------------+--------------------+
      |count(DISTINCT 2)|count(DISTINCT 2, 3)|
      +-----------------+--------------------+
      |                1|                   1|
      +-----------------+--------------------+
      
      spark.sql(
        " SELECT COUNT(DISTINCT 2), COUNT(DISTINCT 3, 2)")
        .show()
      +-----------------+--------------------+
      |count(DISTINCT 2)|count(DISTINCT 3, 2)|
      +-----------------+--------------------+
      |                1|                   0|
      +-----------------+--------------------+
      

      Attachments

        Activity

          People

            beliefer jiaan.geng
            beliefer jiaan.geng
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: