[ 
https://issues.apache.org/jira/browse/HIVE-2478?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16330781#comment-16330781
 ] 

Pau Tallada CrespĂ­ commented on HIVE-2478:
------------------------------------------

Is there any progress on this?

We are running a web interface to hive and we want to validate SQL queries that 
users submit. Not only the syntax, but also to retrieve the resulting schema 
(column names and types).

We are kind-of hacking it running the query inside a subselect:

SELECT * FROM ( <original_query> ) AS t LIMIT 0

But if the user does a join and there is a field with the same name in two 
differents tables, it fails...

> Support dry run option in hive
> ------------------------------
>
>                 Key: HIVE-2478
>                 URL: https://issues.apache.org/jira/browse/HIVE-2478
>             Project: Hive
>          Issue Type: Improvement
>          Components: Configuration
>    Affects Versions: 0.9.0
>            Reporter: kalyan ram
>            Assignee: Sushanth Sowmyan
>            Priority: Minor
>         Attachments: ASF.LICENSE.NOT.GRANTED--HIVE-2478.D927.1.patch, 
> HIVE-2478-1.patch, HIVE-2478-2.patch, HIVE-2478-3.patch
>
>
> Hive currently doesn't support a dry run option. For some complex queries we 
> just want to verify the query syntax initally before running it. A dry run 
> option where just the parsing is done without actual execution is a good 
> option.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to