[SPARK-16228] "Percentile" needs explicit cast to double

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0.0
• Fix Version/s: 2.0.0
• Component/s: SQL
• Assignee: Dongjoon Hyun
• Reporter: Egor Pahomov
• Created: 27/Jun/16 18:08
• Updated: 17/Nov/16 14:30
• Resolved: 29/Jun/16 23:09

Description

select percentile(cast(id as bigint), cast(0.5 as double)) from temp.bla

Works.

select percentile(cast(id as bigint), 0.5 ) from temp.bla

Throws

Error in query: No handler for Hive UDF 'org.apache.hadoop.hive.ql.udf.UDAFPercentile': org.apache.hadoop.hive.ql.exec.NoMatchingMethodException: No matching method for class org.apache.hadoop.hive.ql.udf.UDAFPercentile with (bigint, decimal(38,18)). Possible choices: FUNC(bigint, array<double>) FUNC(bigint, double) ; line 1 pos 7

Issue Links

• links to: [Github] Pull Request #13930 (dongjoon-hyun)