Riju Trivedi created HIVE-22208: ----------------------------------- Summary: Column name with reserved keyword is unescaped when query includes join on table with mask column is re-written Key: HIVE-22208 URL: https://issues.apache.org/jira/browse/HIVE-22208 Project: Hive Issue Type: Bug Components: Hive Affects Versions: 3.1.0, 4.0.0 Reporter: Riju Trivedi
Join query involving table with mask column and other having reserved keyword as column name fails with SemanticException during parsing re-written query : Original Query : {code:java} select a.`date`, b.nm from sample_keyword a join sample_mask b on b.id = a.id; {code} Re-written Query : {code:java} select a.date, b.nm from sample_keyword a join (SELECT `id`, CAST(mask_hash(nm) AS string) AS `nm`, BLOCK__OFFSET__INSIDE__FILE, INPUT__FILE__NAME, ROW__ID FROM `default`.`sample_mask` )`b` on b.id = a.id; {code} Re-written query does not have escape quotes for date column which cause SemanticException while parsing : {code:java} org.apache.hadoop.hive.ql.parse.ParseException: line 1:9 cannot recognize input near 'a' '.' 'date' in selection target at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.rewriteASTWithMaskAndFilter( SemanticAnalyzer.java:12084) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal( SemanticAnalyzer.java:12298) at org.apache.hadoop.hive.ql.parse.CalcitePlanner.analyzeInternal( CalcitePlanner.java:360) at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze( BaseSemanticAnalyzer.java:289) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:664) at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1869) {code} -- This message was sent by Atlassian Jira (v8.3.2#803003)