[SPARK-43077] Improve the error message of UNRECOGNIZED_SQL_TYPE

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.5.0
• Fix Version/s: 3.5.0
• Component/s: SQL
• Assignee: Kent Yao
• Reporter: Kent Yao
• Created: 10/Apr/23 02:49
• Updated: 11/Apr/23 02:47
• Resolved: 11/Apr/23 02:47

Description

UNRECOGNIZED_SQL_TYPE prints the jdbc type id in the error message currently. This is difficult for spark users to understand the meaning of this kind of error, especially when the type id is from a vendor extension.

For example, 

 org.apache.spark.SparkSQLException: Unrecognized SQL type -102

Issue Links

• links to: [Github] Pull Request #40718 (yaooqinn)