[ 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