[jira] [Commented] (HIVE-3834) Support ALTER VIEW AS SELECT in Hive
[ https://issues.apache.org/jira/browse/HIVE-3834?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13547855#comment-13547855 ] Hudson commented on HIVE-3834: -- Integrated in Hive-trunk-hadoop2 #54 (See [https://builds.apache.org/job/Hive-trunk-hadoop2/54/]) HIVE-3834 Support ALTER VIEW AS SELECT in Hive (Zhenxiao Luo via namit) (Revision 1425755) Result = ABORTED namit : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1425755 Files : * /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/ErrorMsg.java * /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java * /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g * /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java * /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/CreateViewDesc.java * /hive/trunk/ql/src/test/queries/clientnegative/alter_view_as_select_not_exist.q * /hive/trunk/ql/src/test/queries/clientnegative/alter_view_as_select_with_partition.q * /hive/trunk/ql/src/test/queries/clientpositive/alter_view_as_select.q * /hive/trunk/ql/src/test/results/clientnegative/alter_view_as_select_not_exist.q.out * /hive/trunk/ql/src/test/results/clientnegative/alter_view_as_select_with_partition.q.out * /hive/trunk/ql/src/test/results/clientnegative/create_or_replace_view1.q.out * /hive/trunk/ql/src/test/results/clientnegative/create_or_replace_view2.q.out * /hive/trunk/ql/src/test/results/clientnegative/create_or_replace_view3.q.out * /hive/trunk/ql/src/test/results/clientpositive/alter_view_as_select.q.out * /hive/trunk/ql/src/test/results/clientpositive/create_view.q.out > Support ALTER VIEW AS SELECT in Hive > > > Key: HIVE-3834 > URL: https://issues.apache.org/jira/browse/HIVE-3834 > Project: Hive > Issue Type: New Feature >Reporter: Zhenxiao Luo >Assignee: Zhenxiao Luo > Fix For: 0.11.0 > > Attachments: HIVE-3834.1.patch.txt, HIVE-3834.2.patch.txt, > HIVE-3834.3.patch.txt, HIVE-3834.4.patch.txt > > > Hive supports "alter view" on setting property, add/drop partition etc but > not "as". > If you want to change "as" part, you have to drop view, recreate it and > backfill partition etc. pretty painful. > It will be nice to support this. The reference is mysql syntax > http://dev.mysql.com/doc/refman/5.0/en/alter-view.html -- 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
[jira] [Commented] (HIVE-3834) Support ALTER VIEW AS SELECT in Hive
[ https://issues.apache.org/jira/browse/HIVE-3834?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13539480#comment-13539480 ] Hudson commented on HIVE-3834: -- Integrated in Hive-trunk-h0.21 #1879 (See [https://builds.apache.org/job/Hive-trunk-h0.21/1879/]) HIVE-3834 Support ALTER VIEW AS SELECT in Hive (Zhenxiao Luo via namit) (Revision 1425755) Result = SUCCESS namit : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1425755 Files : * /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/ErrorMsg.java * /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java * /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g * /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java * /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/CreateViewDesc.java * /hive/trunk/ql/src/test/queries/clientnegative/alter_view_as_select_not_exist.q * /hive/trunk/ql/src/test/queries/clientnegative/alter_view_as_select_with_partition.q * /hive/trunk/ql/src/test/queries/clientpositive/alter_view_as_select.q * /hive/trunk/ql/src/test/results/clientnegative/alter_view_as_select_not_exist.q.out * /hive/trunk/ql/src/test/results/clientnegative/alter_view_as_select_with_partition.q.out * /hive/trunk/ql/src/test/results/clientnegative/create_or_replace_view1.q.out * /hive/trunk/ql/src/test/results/clientnegative/create_or_replace_view2.q.out * /hive/trunk/ql/src/test/results/clientnegative/create_or_replace_view3.q.out * /hive/trunk/ql/src/test/results/clientpositive/alter_view_as_select.q.out * /hive/trunk/ql/src/test/results/clientpositive/create_view.q.out > Support ALTER VIEW AS SELECT in Hive > > > Key: HIVE-3834 > URL: https://issues.apache.org/jira/browse/HIVE-3834 > Project: Hive > Issue Type: New Feature >Reporter: Zhenxiao Luo >Assignee: Zhenxiao Luo > Fix For: 0.11 > > Attachments: HIVE-3834.1.patch.txt, HIVE-3834.2.patch.txt, > HIVE-3834.3.patch.txt, HIVE-3834.4.patch.txt > > > Hive supports "alter view" on setting property, add/drop partition etc but > not "as". > If you want to change "as" part, you have to drop view, recreate it and > backfill partition etc. pretty painful. > It will be nice to support this. The reference is mysql syntax > http://dev.mysql.com/doc/refman/5.0/en/alter-view.html -- 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
[jira] [Commented] (HIVE-3834) Support ALTER VIEW AS SELECT in Hive
[ https://issues.apache.org/jira/browse/HIVE-3834?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13539440#comment-13539440 ] Zhenxiao Luo commented on HIVE-3834: Thanks Namit. I added documentation at: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-AlterViewAsSelect > Support ALTER VIEW AS SELECT in Hive > > > Key: HIVE-3834 > URL: https://issues.apache.org/jira/browse/HIVE-3834 > Project: Hive > Issue Type: New Feature >Reporter: Zhenxiao Luo >Assignee: Zhenxiao Luo > Fix For: 0.11 > > Attachments: HIVE-3834.1.patch.txt, HIVE-3834.2.patch.txt, > HIVE-3834.3.patch.txt, HIVE-3834.4.patch.txt > > > Hive supports "alter view" on setting property, add/drop partition etc but > not "as". > If you want to change "as" part, you have to drop view, recreate it and > backfill partition etc. pretty painful. > It will be nice to support this. The reference is mysql syntax > http://dev.mysql.com/doc/refman/5.0/en/alter-view.html -- 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
[jira] [Commented] (HIVE-3834) Support ALTER VIEW AS SELECT in Hive
[ https://issues.apache.org/jira/browse/HIVE-3834?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13539371#comment-13539371 ] Zhenxiao Luo commented on HIVE-3834: Hi Namit, Sorry for the failure. I fixed the failure at: https://reviews.facebook.net/D7605 Sure. I will add documentation about ALTER VIEW AS SELECT when this task is committed. Thanks, Zhenxiao > Support ALTER VIEW AS SELECT in Hive > > > Key: HIVE-3834 > URL: https://issues.apache.org/jira/browse/HIVE-3834 > Project: Hive > Issue Type: New Feature >Reporter: Zhenxiao Luo >Assignee: Zhenxiao Luo > Attachments: HIVE-3834.1.patch.txt, HIVE-3834.2.patch.txt, > HIVE-3834.3.patch.txt, HIVE-3834.4.patch.txt > > > Hive supports "alter view" on setting property, add/drop partition etc but > not "as". > If you want to change "as" part, you have to drop view, recreate it and > backfill partition etc. pretty painful. > It will be nice to support this. The reference is mysql syntax > http://dev.mysql.com/doc/refman/5.0/en/alter-view.html -- 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
[jira] [Commented] (HIVE-3834) Support ALTER VIEW AS SELECT in Hive
[ https://issues.apache.org/jira/browse/HIVE-3834?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13539357#comment-13539357 ] Namit Jain commented on HIVE-3834: -- Can you add documentation once it is committed ? > Support ALTER VIEW AS SELECT in Hive > > > Key: HIVE-3834 > URL: https://issues.apache.org/jira/browse/HIVE-3834 > Project: Hive > Issue Type: New Feature >Reporter: Zhenxiao Luo >Assignee: Zhenxiao Luo > Attachments: HIVE-3834.1.patch.txt, HIVE-3834.2.patch.txt, > HIVE-3834.3.patch.txt > > > Hive supports "alter view" on setting property, add/drop partition etc but > not "as". > If you want to change "as" part, you have to drop view, recreate it and > backfill partition etc. pretty painful. > It will be nice to support this. The reference is mysql syntax > http://dev.mysql.com/doc/refman/5.0/en/alter-view.html -- 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
[jira] [Commented] (HIVE-3834) Support ALTER VIEW AS SELECT in Hive
[ https://issues.apache.org/jira/browse/HIVE-3834?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13539282#comment-13539282 ] Namit Jain commented on HIVE-3834: -- +1 Running tests > Support ALTER VIEW AS SELECT in Hive > > > Key: HIVE-3834 > URL: https://issues.apache.org/jira/browse/HIVE-3834 > Project: Hive > Issue Type: New Feature >Reporter: Zhenxiao Luo >Assignee: Zhenxiao Luo > Attachments: HIVE-3834.1.patch.txt, HIVE-3834.2.patch.txt, > HIVE-3834.3.patch.txt > > > Hive supports "alter view" on setting property, add/drop partition etc but > not "as". > If you want to change "as" part, you have to drop view, recreate it and > backfill partition etc. pretty painful. > It will be nice to support this. The reference is mysql syntax > http://dev.mysql.com/doc/refman/5.0/en/alter-view.html -- 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
