viirya edited a comment on issue #25570: [SPARK-23519][SQL] create view should work from query with duplicate output columns URL: https://github.com/apache/spark/pull/25570#issuecomment-524756546 > ALTER VIEW AS gets its schema from the new SELECT query provided. So it is not effected But `sql("ALTER VIEW v23519 AS SELECT c1, c1 FROM t23519")` also fails with an exception? ```scala org.apache.spark.sql.AnalysisException: Found duplicate column(s) in the view definition: `c1`; [info] at org.apache.spark.sql.util.SchemaUtils$.checkColumnNameDuplication(SchemaUtils.scala:90) [info] at org.apache.spark.sql.util.SchemaUtils$.checkColumnNameDuplication(SchemaUtils.scala:70) [info] at org.apache.spark.sql.execution.command.ViewHelper$.generateViewProperties(views.scala:369) [info] at org.apache.spark.sql.execution.command.AlterViewAsCommand.alterPermanentView(views.scala:301) ```
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
