[jira] [Commented] (SPARK-29660) Dropping columns and changing column names/types are prohibited in VIEW definition

2019-12-01 Thread Xiao Li (Jira) 


[ 
https://issues.apache.org/jira/browse/SPARK-29660?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16985706#comment-16985706
 ] 

Xiao Li commented on SPARK-29660:
-

It is cool that Spark supports them, but pgSQL has not supported them yet. 

> Dropping columns and changing column names/types are prohibited in VIEW 
> definition
> --
>
> Key: SPARK-29660
> URL: https://issues.apache.org/jira/browse/SPARK-29660
> Project: Spark
>  Issue Type: Sub-task
>  Components: SQL
>Affects Versions: 3.0.0
>Reporter: Takeshi Yamamuro
>Priority: Major
>
> In PostgreSQL, the three DDL syntaxes for VIEW cannot be accepted;
> {code:java}
> -- should fail
> CREATE OR REPLACE VIEW viewtest AS
>   SELECT a FROM viewtest_tbl WHERE a <> 20;
> ERROR:  cannot drop columns from view
> -- should fail
> CREATE OR REPLACE VIEW viewtest AS
>   SELECT 1, * FROM viewtest_tbl;
> ERROR:  cannot change name of view column "a" to "?column?"
> -- should fail
> CREATE OR REPLACE VIEW viewtest AS
>   SELECT a, b::numeric FROM viewtest_tbl;
> ERROR:  cannot change data type of view column "b" from integer to numeric
> {code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

-
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

[jira] [Commented] (SPARK-29660) Dropping columns and changing column names/types are prohibited in VIEW definition

2019-10-30 Thread Takeshi Yamamuro (Jira) 


[ 
https://issues.apache.org/jira/browse/SPARK-29660?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16963533#comment-16963533
 ] 

Takeshi Yamamuro commented on SPARK-29660:
--

I'm not sure that we need to do something about this. See: 
https://github.com/apache/spark/pull/26290#discussion_r340487877

> Dropping columns and changing column names/types are prohibited in VIEW 
> definition
> --
>
> Key: SPARK-29660
> URL: https://issues.apache.org/jira/browse/SPARK-29660
> Project: Spark
>  Issue Type: Sub-task
>  Components: SQL
>Affects Versions: 3.0.0
>Reporter: Takeshi Yamamuro
>Priority: Major
>
> In PostgreSQL, the three DDL syntaxes for VIEW cannot be accepted;
> {code:java}
> -- should fail
> CREATE OR REPLACE VIEW viewtest AS
>   SELECT a FROM viewtest_tbl WHERE a <> 20;
> ERROR:  cannot drop columns from view
> -- should fail
> CREATE OR REPLACE VIEW viewtest AS
>   SELECT 1, * FROM viewtest_tbl;
> ERROR:  cannot change name of view column "a" to "?column?"
> -- should fail
> CREATE OR REPLACE VIEW viewtest AS
>   SELECT a, b::numeric FROM viewtest_tbl;
> ERROR:  cannot change data type of view column "b" from integer to numeric
> {code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

-
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

[jira] [Commented] (SPARK-29660) Dropping columns and changing column names/types are prohibited in VIEW definition

2019-10-30 Thread Aman Omer (Jira) 


[ 
https://issues.apache.org/jira/browse/SPARK-29660?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16963186#comment-16963186
 ] 

Aman Omer commented on SPARK-29660:
---

Checking this one 

> Dropping columns and changing column names/types are prohibited in VIEW 
> definition
> --
>
> Key: SPARK-29660
> URL: https://issues.apache.org/jira/browse/SPARK-29660
> Project: Spark
>  Issue Type: Sub-task
>  Components: SQL
>Affects Versions: 3.0.0
>Reporter: Takeshi Yamamuro
>Priority: Major
>
> In PostgreSQL, the three DDL syntaxes for VIEW cannot be accepted;
> {code:java}
> -- should fail
> CREATE OR REPLACE VIEW viewtest AS
>   SELECT a FROM viewtest_tbl WHERE a <> 20;
> ERROR:  cannot drop columns from view
> -- should fail
> CREATE OR REPLACE VIEW viewtest AS
>   SELECT 1, * FROM viewtest_tbl;
> ERROR:  cannot change name of view column "a" to "?column?"
> -- should fail
> CREATE OR REPLACE VIEW viewtest AS
>   SELECT a, b::numeric FROM viewtest_tbl;
> ERROR:  cannot change data type of view column "b" from integer to numeric
> {code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

-
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org