[HIVE-25677] HiveParser cannot parse a sql with chinese

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Target Version/s: 2.3.7
• Assignee: Zhihua Deng
• Reporter: mysid2018
• Created: 05/Nov/21 16:36
• Updated: 22/Nov/21 07:21

Description

I hope someone can help me。

I write a program to parse the HQL. My code is as follows

try {
 String mySql = "SELECT a,b,c as `中国` from tbl"
 ASTNode ast = ParseUtils.parse(mySql);
 ...
} catch (Exception e) {
 LOG.info("parse_sql exception: {}", e.getMessage()); 
 ...
}

 It will print the log:

 

parse_sql exception: line 1:21 cannot recognize input near 'as' 'from' 'tbl' in selection target

 

 

The following code can run correctly

String mySql = "SELECT a,b,c as `china` from tbl"

Thanks very much.