[SPARK-21318] The exception message thrown by `lookupFunction` is ambiguous.

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 2.0.0, 2.0.1, 2.0.2, 2.1.0, 2.1.1
• Fix Version/s: 2.4.0
• Component/s: SQL
• Assignee: StanZhai
• Reporter: StanZhai
• Created: 05/Jul/17 14:05
• Updated: 07/Dec/18 06:54
• Resolved: 24/Sep/18 13:35

Description

The function actually exists in current selected database, but the exception message is:

This function is neither a registered temporary function nor a permanent function registered in the database 'default'.

My UDF has already been registered in the current database. But it's failed to init during lookupFunction.

The exception message should be:

No handler for Hive UDF 'site.stanzhai.UDAFXXX': org.apache.hadoop.hive.ql.exec.UDFArgumentLengthException: Two arguments is expected

This is not conducive to positioning problems.

Issue Links

• links to: [Github] Pull Request #18544 (stanzhai)