[ https://issues.apache.org/jira/browse/CALCITE-3127?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16863698#comment-16863698 ]
Julian Hyde commented on CALCITE-3127: -------------------------------------- I think this is a pointless command, as are ALTER VIEW in MySQL and SQL Server, because it requires 'AS query'. Why does Hive support ALTER VIEW? Only for compatibility with MySQL (see HIVE-3834). Good grief. Oracle's ALTER VIEW statement makes sense to me, because you can ADD, MODIFY, DROP or COMPILE and you don't have to - in fact you cannot - re-specify 'AS query'. > Support ALTER VIEW Statement > ---------------------------- > > Key: CALCITE-3127 > URL: https://issues.apache.org/jira/browse/CALCITE-3127 > Project: Calcite > Issue Type: Improvement > Components: server > Affects Versions: 1.19.0 > Reporter: pingle wang > Priority: Major > Labels: pull-request-available > Fix For: next > > Time Spent: 10m > Remaining Estimate: 0h > > support alter view statement : > {code:java} > ALTER VIEW name > [ '(' columnName [, columnName ]* ')' ] > AS query > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)