cloud-fan commented on code in PR #46267: URL: https://github.com/apache/spark/pull/46267#discussion_r1596873275
########## sql/core/src/test/resources/sql-tests/results/view-schema-binding-config.sql.out: ########## @@ -0,0 +1,794 @@ +-- Automatically generated by SQLQueryTestSuite +-- !query +SET spark.sql.viewSchemaBindingMode +-- !query schema +struct<key:string,value:string> +-- !query output +spark.sql.viewSchemaBindingMode COMPENSATION + + +-- !query +SET spark.sql.viewSchemaBindingMode = EVOLUTION +-- !query schema +struct<> +-- !query output +java.lang.IllegalArgumentException +The value of spark.sql.viewSchemaBindingMode should be one of COMPENSATION, DISABLED, but was EVOLUTION + + +-- !query +SET spark.sql.viewSchemaBindingMode = DISABLED +-- !query schema +struct<key:string,value:string> +-- !query output +spark.sql.viewSchemaBindingMode DISABLED + + +-- !query +CREATE OR REPLACE VIEW v WITH SCHEMA BINDING AS SELECT 1 +-- !query schema +struct<> +-- !query output +org.apache.spark.sql.catalyst.parser.ParseException +{ + "errorClass" : "FEATURE_NOT_ENABLED", + "sqlState" : "56038", + "messageParameters" : { + "configKey" : "spark.sql.viewSchemaBindingMode", + "configValue" : "COMPENSATION", + "featureName" : "VIEW ... WITH SCHEMA ..." + }, + "queryContext" : [ { + "objectType" : "", + "objectName" : "", + "startIndex" : 26, + "stopIndex" : 44, + "fragment" : "WITH SCHEMA BINDING" + } ] +} + + +-- !query +CREATE OR REPLACE VIEW v WITH SCHEMA COMPENSATION AS SELECT 1 +-- !query schema +struct<> +-- !query output +org.apache.spark.sql.catalyst.parser.ParseException +{ + "errorClass" : "FEATURE_NOT_ENABLED", + "sqlState" : "56038", + "messageParameters" : { + "configKey" : "spark.sql.viewSchemaBindingMode", + "configValue" : "COMPENSATION", + "featureName" : "VIEW ... WITH SCHEMA ..." + }, + "queryContext" : [ { + "objectType" : "", + "objectName" : "", + "startIndex" : 26, + "stopIndex" : 49, + "fragment" : "WITH SCHEMA COMPENSATION" + } ] +} + + +-- !query +CREATE OR REPLACE VIEW v WITH SCHEMA TYPE EVOLUTION AS SELECT 1 +-- !query schema +struct<> +-- !query output +org.apache.spark.sql.catalyst.parser.ParseException +{ + "errorClass" : "FEATURE_NOT_ENABLED", + "sqlState" : "56038", + "messageParameters" : { + "configKey" : "spark.sql.viewSchemaBindingMode", + "configValue" : "COMPENSATION", + "featureName" : "VIEW ... WITH SCHEMA ..." + }, + "queryContext" : [ { + "objectType" : "", + "objectName" : "", + "startIndex" : 26, + "stopIndex" : 51, + "fragment" : "WITH SCHEMA TYPE EVOLUTION" + } ] +} + + +-- !query +CREATE OR REPLACE VIEW v WITH SCHEMA EVOLUTION AS SELECT 1 +-- !query schema +struct<> +-- !query output +org.apache.spark.sql.catalyst.parser.ParseException +{ + "errorClass" : "FEATURE_NOT_ENABLED", + "sqlState" : "56038", + "messageParameters" : { + "configKey" : "spark.sql.viewSchemaBindingMode", + "configValue" : "COMPENSATION", + "featureName" : "VIEW ... WITH SCHEMA ..." + }, + "queryContext" : [ { + "objectType" : "", + "objectName" : "", + "startIndex" : 26, + "stopIndex" : 46, + "fragment" : "WITH SCHEMA EVOLUTION" + } ] +} + + +-- !query +CREATE OR REPLACE VIEW v AS SELECT 1 +-- !query schema +struct<> +-- !query output + + + +-- !query +DESCRIBE EXTENDED v +-- !query schema +struct<col_name:string,data_type:string,comment:string> +-- !query output +1 int + +# Detailed Table Information +Catalog spark_catalog +Database default +Table v +Created Time [not included in comparison] +Last Access [not included in comparison] +Created By [not included in comparison] +Type VIEW +View Text SELECT 1 +View Original Text SELECT 1 +View Catalog and Namespace spark_catalog.default +View Query Output Columns [1] + + +-- !query +SHOW TABLE EXTENDED LIKE 'v' Review Comment: what extra information we want to get from `SHOW TABLE EXTENDED`? -- 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. To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org