[FLINK-29045] Optimize error message in Flink SQL Client and Gateway when try to use Hive Dialect

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.16.0, 1.17.0
• Component/s: Connectors / Hive
• Labels: pull-request-available
• Assignee: luoyuxia
• Reporter: luoyuxia
• Created: 19/Aug/22 11:52
• Updated: 21/Sep/22 01:48
• Resolved: 21/Sep/22 01:48

Description

Since Flink 1.15 , if users want to use HiveDialect, they have to swap flink-table-planner-loader located in /lib with flink-table-planner_2.12 located in /opt

Noticing it bothers some users as reported in FLINK-27020, FLINK-28618 .

Althogh the document has noted it, but some users may still miss it.  It would be better to show the detail error message  and tell user how to deal with  such case in Flink SQL client.

Issue Links

• links to: GitHub Pull Request #20695