[ https://issues.apache.org/jira/browse/HIVE-2478?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13120890#comment-13120890 ]
kalyan ram commented on HIVE-2478: ---------------------------------- Yes we can use EXPLAIN as well. In MySql older versions for some queries having sub queries <explain> was executing the sub queries so I was thinking on those terms. So in Hive is it that we never execute the query if EXPLAIN is present ? This feature might still be useful in remote cases where you can't go and change your queries. For example if you want to check if your queries will work against a new version of hive we can set this property and check without modifying the query. > 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 > Priority: Minor > Attachments: HIVE-2478-1.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 is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira