[
https://issues.apache.org/jira/browse/SPARK-18389?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15651816#comment-15651816
]
Nattavut Sutyanyong commented on SPARK-18389:
---------------------------------------------
The ALTER VIEW should run successfully keeping the new definition of the
testView in a textual format. It is when we expand the definition of testView
in the Analyzer that we need to keep the DAG of all the derived definition of
the testView and flag an error when the DAG becomes a cyclic graph.
> Disallow cyclic view reference
> ------------------------------
>
> Key: SPARK-18389
> URL: https://issues.apache.org/jira/browse/SPARK-18389
> Project: Spark
> Issue Type: Sub-task
> Components: SQL
> Reporter: Reynold Xin
>
> The following should not be allowed:
> {code}
> CREATE VIEW testView AS SELECT id FROM jt
> CREATE VIEW testView2 AS SELECT id FROM testView
> ALTER VIEW testView AS SELECT * FROM testView2
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
