You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "slim bouguerra (JIRA)" <ji...@apache.org> on 2019/04/29 23:29:00 UTC

[jira] [Created] (HIVE-21665) Unable to reconstruct valid SQL query from AST when back ticks are used

slim bouguerra created HIVE-21665:
-------------------------------------

             Summary: 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
            Reporter: slim bouguerra


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)