You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Kevin Wilfong (Created) (JIRA)" <ji...@apache.org> on 2012/01/27 01:31:40 UTC
[jira] [Created] (HIVE-2756) Views should be added to the inputs of
queries.
Views should be added to the inputs of queries.
-----------------------------------------------
Key: HIVE-2756
URL: https://issues.apache.org/jira/browse/HIVE-2756
Project: Hive
Issue Type: Improvement
Reporter: Kevin Wilfong
Assignee: Kevin Wilfong
Views, in addition to the underlying tables, should be included in the inputs of a command which queries a view.
--
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
[jira] [Commented] (HIVE-2756) Views should be added to the inputs
of queries.
Posted by "Phabricator (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2756?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13199251#comment-13199251 ]
Phabricator commented on HIVE-2756:
-----------------------------------
njain has accepted the revision "HIVE-2756 [jira] Views should be added to the inputs of queries.".
REVISION DETAIL
https://reviews.facebook.net/D1575
> Views should be added to the inputs of queries.
> -----------------------------------------------
>
> Key: HIVE-2756
> URL: https://issues.apache.org/jira/browse/HIVE-2756
> Project: Hive
> Issue Type: Improvement
> Reporter: Kevin Wilfong
> Assignee: Kevin Wilfong
> Attachments: HIVE-2756.D1575.1.patch
>
>
> Views, in addition to the underlying tables, should be included in the inputs of a command which queries a view.
> This is useful when we want to know exactly what inputs need to be present in order to run the query run by a user.
--
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
[jira] [Updated] (HIVE-2756) Views should be added to the inputs of
queries.
Posted by "Phabricator (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2756?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Phabricator updated HIVE-2756:
------------------------------
Attachment: HIVE-2756.D1575.1.patch
kevinwilfong requested code review of "HIVE-2756 [jira] Views should be added to the inputs of queries.".
Reviewers: JIRA
https://issues.apache.org/jira/browse/HIVE-2756
Add the view to the inputs right before it is replaced by its underlying query in the SemanticAnalyzer.
Views, in addition to the underlying tables, should be included in the inputs of a command which queries a view.
This is useful when we want to know exactly what inputs need to be present in order to run the query run by a user.
TEST PLAN
EMPTY
REVISION DETAIL
https://reviews.facebook.net/D1575
AFFECTED FILES
ql/src/test/results/clientnegative/create_or_replace_view7.q.out
ql/src/test/results/clientnegative/recursive_view.q.out
ql/src/test/results/clientnegative/invalidate_view1.q.out
ql/src/test/results/clientpositive/create_or_replace_view.q.out
ql/src/test/results/clientpositive/create_view.q.out
ql/src/test/results/clientpositive/create_big_view.q.out
ql/src/test/results/clientpositive/alter_view_rename.q.out
ql/src/test/results/clientpositive/create_view_partitioned.q.out
ql/src/test/results/clientpositive/ppd_union_view.q.out
ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java
MANAGE HERALD DIFFERENTIAL RULES
https://reviews.facebook.net/herald/view/differential/
WHY DID I GET THIS EMAIL?
https://reviews.facebook.net/herald/transcript/3303/
Tip: use the X-Herald-Rules header to filter Herald messages in your client.
> Views should be added to the inputs of queries.
> -----------------------------------------------
>
> Key: HIVE-2756
> URL: https://issues.apache.org/jira/browse/HIVE-2756
> Project: Hive
> Issue Type: Improvement
> Reporter: Kevin Wilfong
> Assignee: Kevin Wilfong
> Attachments: HIVE-2756.D1575.1.patch
>
>
> Views, in addition to the underlying tables, should be included in the inputs of a command which queries a view.
> This is useful when we want to know exactly what inputs need to be present in order to run the query run by a user.
--
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
[jira] [Updated] (HIVE-2756) Views should be added to the inputs of
queries.
Posted by "Kevin Wilfong (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2756?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kevin Wilfong updated HIVE-2756:
--------------------------------
Description:
Views, in addition to the underlying tables, should be included in the inputs of a command which queries a view.
This is useful when we want to know exactly what inputs need to be present in order to run the query run by a user.
was:Views, in addition to the underlying tables, should be included in the inputs of a command which queries a view.
> Views should be added to the inputs of queries.
> -----------------------------------------------
>
> Key: HIVE-2756
> URL: https://issues.apache.org/jira/browse/HIVE-2756
> Project: Hive
> Issue Type: Improvement
> Reporter: Kevin Wilfong
> Assignee: Kevin Wilfong
>
> Views, in addition to the underlying tables, should be included in the inputs of a command which queries a view.
> This is useful when we want to know exactly what inputs need to be present in order to run the query run by a user.
--
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
[jira] [Updated] (HIVE-2756) Views should be added to the inputs of
queries.
Posted by "Namit Jain (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2756?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-2756:
-----------------------------
Resolution: Fixed
Hadoop Flags: Reviewed
Status: Resolved (was: Patch Available)
Committed. Thanks Kevin
> Views should be added to the inputs of queries.
> -----------------------------------------------
>
> Key: HIVE-2756
> URL: https://issues.apache.org/jira/browse/HIVE-2756
> Project: Hive
> Issue Type: Improvement
> Reporter: Kevin Wilfong
> Assignee: Kevin Wilfong
> Attachments: HIVE-2756.D1575.1.patch
>
>
> Views, in addition to the underlying tables, should be included in the inputs of a command which queries a view.
> This is useful when we want to know exactly what inputs need to be present in order to run the query run by a user.
--
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
[jira] [Updated] (HIVE-2756) Views should be added to the inputs of
queries.
Posted by "Ashutosh Chauhan (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2756?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ashutosh Chauhan updated HIVE-2756:
-----------------------------------
Component/s: Views
Fix Version/s: 0.9.0
> Views should be added to the inputs of queries.
> -----------------------------------------------
>
> Key: HIVE-2756
> URL: https://issues.apache.org/jira/browse/HIVE-2756
> Project: Hive
> Issue Type: Improvement
> Components: Views
> Reporter: Kevin Wilfong
> Assignee: Kevin Wilfong
> Fix For: 0.9.0
>
> Attachments: HIVE-2756.D1575.1.patch
>
>
> Views, in addition to the underlying tables, should be included in the inputs of a command which queries a view.
> This is useful when we want to know exactly what inputs need to be present in order to run the query run by a user.
--
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
[jira] [Updated] (HIVE-2756) Views should be added to the inputs of
queries.
Posted by "Namit Jain (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2756?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-2756:
-----------------------------
Status: Patch Available (was: Open)
> Views should be added to the inputs of queries.
> -----------------------------------------------
>
> Key: HIVE-2756
> URL: https://issues.apache.org/jira/browse/HIVE-2756
> Project: Hive
> Issue Type: Improvement
> Reporter: Kevin Wilfong
> Assignee: Kevin Wilfong
> Attachments: HIVE-2756.D1575.1.patch
>
>
> Views, in addition to the underlying tables, should be included in the inputs of a command which queries a view.
> This is useful when we want to know exactly what inputs need to be present in order to run the query run by a user.
--
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
[jira] [Commented] (HIVE-2756) Views should be added to the inputs
of queries.
Posted by "Hudson (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2756?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13199657#comment-13199657 ]
Hudson commented on HIVE-2756:
------------------------------
Integrated in Hive-trunk-h0.21 #1241 (See [https://builds.apache.org/job/Hive-trunk-h0.21/1241/])
HIVE-2756 Views should be added to the inputs of queries.
(Yongqiang He via namit)
namit : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1240005
Files :
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java
* /hive/trunk/ql/src/test/results/clientnegative/create_or_replace_view7.q.out
* /hive/trunk/ql/src/test/results/clientnegative/invalidate_view1.q.out
* /hive/trunk/ql/src/test/results/clientnegative/recursive_view.q.out
* /hive/trunk/ql/src/test/results/clientpositive/alter_view_rename.q.out
* /hive/trunk/ql/src/test/results/clientpositive/create_big_view.q.out
* /hive/trunk/ql/src/test/results/clientpositive/create_or_replace_view.q.out
* /hive/trunk/ql/src/test/results/clientpositive/create_view.q.out
* /hive/trunk/ql/src/test/results/clientpositive/create_view_partitioned.q.out
* /hive/trunk/ql/src/test/results/clientpositive/ppd_union_view.q.out
> Views should be added to the inputs of queries.
> -----------------------------------------------
>
> Key: HIVE-2756
> URL: https://issues.apache.org/jira/browse/HIVE-2756
> Project: Hive
> Issue Type: Improvement
> Reporter: Kevin Wilfong
> Assignee: Kevin Wilfong
> Attachments: HIVE-2756.D1575.1.patch
>
>
> Views, in addition to the underlying tables, should be included in the inputs of a command which queries a view.
> This is useful when we want to know exactly what inputs need to be present in order to run the query run by a user.
--
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