[HIVE-27957] Better error message for STORED BY

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.0, 4.0.0-beta-1
• Fix Version/s: 4.1.0
• Labels: pull-request-available
• Assignee: Shohei Okumiya
• Reporter: Shohei Okumiya
• Created: 16/Dec/23 03:58
• Updated: 10/Apr/24 07:21
• Resolved: 10/Apr/24 07:21

Description

We'd like to see a little kinder message when an invalid identifier or literal is given. It is confusing especially when I mistakenly type STORED BY instead of STORED AS.

0: jdbc:hive2://hive-hiveserver2:10000/defaul> CREATE TABLE test (a STRING) STORED BY ORC TBLPROPERTIES ("orc.compress"="ZSTD");
Error: Error while compiling statement: FAILED: SemanticException Cannot find class '' (state=42000,code=40000)

Issue Links

• links to: GitHub Pull Request #4954