[ https://issues.apache.org/jira/browse/HIVE-3610?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kevin Wilfong updated HIVE-3610: -------------------------------- Resolution: Fixed Fix Version/s: 0.10.0 Release Note: This introduces a new command EXPLAIN DEPENDENCY <query> which outputs a JSON object containing the input tables and partitions the query will access without actually running the query. Status: Resolved (was: Patch Available) Committed, thanks Sambavi. > Add a command "Explain dependency ..." > -------------------------------------- > > Key: HIVE-3610 > URL: https://issues.apache.org/jira/browse/HIVE-3610 > Project: Hive > Issue Type: New Feature > Components: Query Processor > Affects Versions: 0.9.0 > Reporter: Sambavi Muthukrishnan > Assignee: Sambavi Muthukrishnan > Priority: Minor > Fix For: 0.10.0 > > Attachments: explain_dependency.1.patch, explain_dependency.2.patch > > > Add a new command "EXPLAIN DEPENDENCY". > Any query can be passed to EXPLAIN DEPENDENCY as with EXPLAIN > (FORMATTED/EXTENDED). The output of this command will be JSON that provides > the list of tables and partitions that the query depends on. > One possible use case is to determine the set of tables/views that are used > by a view, and the set of partitions that are used by a given query on that > view. This will allow a view to be replicated from one Hive instance to > another, since we can determine the set of objects that need to be replicated > for replication of the view to be successful. > Example output: > {"input_tables":[{"tablename": "default@test_sambavi_v2", "tabletype": > "EXTERNAL_TABLE"}, {"tablename": "default@test_sambavi_v1", "tabletype": > "TABLE"}], "input > partitions":["default@srcpart@ds=2008-04-08/hr=11","default@srcpart@ds=2008-04-08/hr=12"]} -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira