[ https://issues.apache.org/jira/browse/HIVE-3610?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13486750#comment-13486750 ]
Hudson commented on HIVE-3610: ------------------------------ Integrated in Hive-trunk-h0.21 #1764 (See [https://builds.apache.org/job/Hive-trunk-h0.21/1764/]) HIVE-3610. Add a command "Explain dependency ..." (Sambavi Muthukrishnan via kevinwilfong) (Revision 1403467) Result = FAILURE kevinwilfong : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1403467 Files : * /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/ExplainTask.java * /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/ExplainSemanticAnalyzer.java * /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g * /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/ExplainWork.java * /hive/trunk/ql/src/test/queries/clientpositive/explain_dependency.q * /hive/trunk/ql/src/test/results/clientpositive/explain_dependency.q.out > 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