[
https://issues.apache.org/jira/browse/HIVE-3610?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sambavi Muthukrishnan updated HIVE-3610:
----------------------------------------
Attachment: explain_dependency.1.patch
> 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
> Attachments: explain_dependency.1.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
