[SPARK-25768] Constant argument expecting Hive UDAFs doesn't work

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.2.0
• Fix Version/s: 2.3.3, 2.4.0
• Component/s: SQL
• Assignee: Peter Toth
• Reporter: Peter Toth
• Created: 18/Oct/18 13:49
• Updated: 19/Oct/18 13:20
• Resolved: 19/Oct/18 13:20

Description

 The following doesn't work since SPARK-18186 so it is a regression.

test("constant argument expecting Hive UDAF") {
  withTempView("inputTable") {
    spark.range(10).createOrReplaceTempView("inputTable")
    withUserDefinedFunction("testGenericUDAFPercentileApprox" -> false) {
      val numFunc = spark.catalog.listFunctions().count()
      sql(s"CREATE FUNCTION testGenericUDAFPercentileApprox AS '" +
        s"${classOf[GenericUDAFPercentileApprox].getName}'")
      checkAnswer(
        sql("SELECT testGenericUDAFPercentileApprox(id, 0.5) FROM inputTable"),
        Seq(Row(4.0)))
    }
  }
}

 

Issue Links

• links to: [Github] Pull Request #22766 (peter-toth)
• links to: [Github] Pull Request #22766 (peter-toth)