[ https://issues.apache.org/jira/browse/HIVE-3834?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-3834: ----------------------------- Resolution: Fixed Fix Version/s: 0.11 Hadoop Flags: Reviewed Status: Resolved (was: Patch Available) 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 > 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