[ https://issues.apache.org/jira/browse/HIVE-21665?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
slim bouguerra updated HIVE-21665: ---------------------------------- Affects Version/s: 4.0.0 > Unable to reconstruct valid SQL query from AST when back ticks are used > ----------------------------------------------------------------------- > > Key: HIVE-21665 > URL: https://issues.apache.org/jira/browse/HIVE-21665 > Project: Hive > Issue Type: Bug > Affects Versions: 4.0.0 > Reporter: slim bouguerra > Priority: Major > > Hive-6013 have introduced a parser rule that removes all the > {code:java} > `{code} > from identifiers or query alias, this can result in some issue when we need > to reconstruct the actual SQL query from the AST. > To reproduce the bug you can use explain analyze statement as the following > query > {code:java} > explain analyze select 'literal' as `alias with space`; > {code} > This bugs will affect how Ranger plugin and probably result cache, where in > both places we need to reconstruct the query from AST. > The current work around is to avoid white spaces within Aliases. -- This message was sent by Atlassian JIRA (v7.6.3#76005)