[HIVE-20497] ParseException, failed to recognize quoted identifier when re-parsing the re-written query

• Type: Bug
• Status: Patch Available
• Priority: Major
• Resolution: Unresolved
• Component/s: Parser

Environment

hive 2.1.1

• Assignee: zhuwei
• Reporter: zhuwei
• Created: 04/Sep/18 11:36
• Updated: 12/Apr/20 03:18

Description

select `user` from team;

If we have a table `team`, and one of its column has been masked out with `****` with column level authorization. The above query will fail with error "SemanticException org.apache.hadoop.hive.ql.parse.ParseException: line 1:9 Failed to recognize predicate 'user'. Failed rule: 'identifier' in expression specification"

The root cause is that after re-written the ast, the back quote has been lost.

 

Issue Links

• supercedes: HIVE-23182 Semantic Exception: rule Identifier failed predicate allowQuotedId