This is an automated email from the ASF dual-hosted git repository.

uros-b pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/spark.git


The following commit(s) were added to refs/heads/master by this push:
     new f68f5fdd58da [SPARK-60881][SQL][TEST] Add CREATE TABLE and REPLACE 
TABLE SQL golden coverage
f68f5fdd58da is described below

commit f68f5fdd58da9ea0202a074102d7f69f3f12b266
Author: Vladan Vasić <[email protected]>
AuthorDate: Thu Nov 5 13:04:42 2026 +0000

    [SPARK-60881][SQL][TEST] Add CREATE TABLE and REPLACE TABLE SQL golden 
coverage
    
    ### What changes were proposed in this pull request?
    
    Add `create-table.sql` with execution and analyzer goldens for 55 SQL 
statements.
    Cover V1 and V2 CREATE, IF NOT EXISTS preserving the original schema, 
duplicate-name
    errors, nested and interval schemas, dynamic table identifiers, schema 
collation
    inheritance, and REPLACE / CREATE OR REPLACE behavior. V2 cases use the 
existing
    `InMemoryTableCatalog` test fixture. No production code changes.
    
    ### Why are the changes needed?
    
    These goldens record successful CREATE and replacement plans alongside 
their intended
    failure paths. DESCRIBE and SHOW CREATE TABLE also verify the resulting 
metadata, so
    a no-op or replacement that produces the wrong schema changes the expected 
output.
    
    ### Does this PR introduce _any_ user-facing change?
    
    No. Test coverage only.
    
    ### How was this patch tested?
    
    Generated and compared both golden result families with Java 21. Each run 
passed
    exactly two tests: `create-table.sql` and `create-table.sql_analyzer_test`, 
with
    55 SQL statements per result family. Both generated files were reviewed in 
full.
    
    ```bash
    SPARK_GENERATE_GOLDEN_FILES=1 build/sbt \
      'sql/testOnly org.apache.spark.sql.SQLQueryTestSuite -- -t 
create-table.sql -t create-table.sql_analyzer_test'
    env -u SPARK_GENERATE_GOLDEN_FILES build/sbt \
      'sql/testOnly org.apache.spark.sql.SQLQueryTestSuite -- -t 
create-table.sql -t create-table.sql_analyzer_test'
    ```
    
    A local Maven mirror was used for dependency resolution; its temporary 
repository
    settings were removed after validation. No dependency versions were changed.
    
    ### Was this patch authored or co-authored using generative AI tooling?
    
    Generated-by: OpenAI Codex (GPT-6).
    
    Closes #60100 from vladanvasi-db/vladanvasi-db/create-table-golden-tests.
    
    Authored-by: Vladan Vasić <[email protected]>
    Signed-off-by: Uros Bojanic <[email protected]>
---
 .../analyzer-results/create-table.sql.out          | 465 +++++++++++++++++
 .../resources/sql-tests/inputs/create-table.sql    |  94 ++++
 .../sql-tests/results/create-table.sql.out         | 556 +++++++++++++++++++++
 3 files changed, 1115 insertions(+)

diff --git 
a/sql/core/src/test/resources/sql-tests/analyzer-results/create-table.sql.out 
b/sql/core/src/test/resources/sql-tests/analyzer-results/create-table.sql.out
new file mode 100644
index 000000000000..efc045a2891b
--- /dev/null
+++ 
b/sql/core/src/test/resources/sql-tests/analyzer-results/create-table.sql.out
@@ -0,0 +1,465 @@
+-- Automatically generated by SQLQueryTestSuite
+-- !query
+CREATE NAMESPACE testcat.ns
+-- !query analysis
+CreateNamespace false
++- ResolvedNamespace 
org.apache.spark.sql.connector.catalog.InMemoryTableCatalog@xxxxxxxx, [ns]
+
+
+-- !query
+CREATE TABLE ct_v1 (c INT, s STRING COMMENT 'x') USING parquet
+-- !query analysis
+CreateDataSourceTableCommand `spark_catalog`.`default`.`ct_v1`, false
+
+
+-- !query
+CREATE TABLE testcat.ns.ct_v2 (c INT, s STRING COMMENT 'x') USING parquet
+-- !query analysis
+CreateTable [columndefinition(c, IntegerType, true, None, None, None, None, 
{}), columndefinition(s, StringType, true, Some(x), None, None, None, {})], 
TableSpec(Map(),Some(parquet),Map(),None,None,None,None,false,List()), false
++- ResolvedIdentifier 
org.apache.spark.sql.connector.catalog.InMemoryTableCatalog@xxxxxxxx, ns.ct_v2, 
[c#x, s#x]
+
+
+-- !query
+CREATE TABLE ct_default_provider (c INT)
+-- !query analysis
+CreateDataSourceTableCommand `spark_catalog`.`default`.`ct_default_provider`, 
false
+
+
+-- !query
+SHOW CREATE TABLE ct_default_provider
+-- !query analysis
+ShowCreateTable false, [createtab_stmt#x]
++- ResolvedTable V2SessionCatalog(spark_catalog), default.ct_default_provider, 
V1Table(default.ct_default_provider), [c#x]
+
+
+-- !query
+CREATE TABLE IF NOT EXISTS ct_v1 (c INT) USING parquet
+-- !query analysis
+CreateDataSourceTableCommand `spark_catalog`.`default`.`ct_v1`, true
+
+
+-- !query
+CREATE TABLE IF NOT EXISTS testcat.ns.ct_v2 (c INT) USING parquet
+-- !query analysis
+CreateTable [columndefinition(c, IntegerType, true, None, None, None, None, 
{})], TableSpec(Map(),Some(parquet),Map(),None,None,None,None,false,List()), 
true
++- ResolvedIdentifier 
org.apache.spark.sql.connector.catalog.InMemoryTableCatalog@xxxxxxxx, ns.ct_v2, 
[c#x]
+
+
+-- !query
+DESCRIBE ct_v1
+-- !query analysis
+DescribeTableCommand `spark_catalog`.`default`.`ct_v1`, false, [col_name#x, 
data_type#x, comment#x]
++- ResolvedTable V2SessionCatalog(spark_catalog), default.ct_v1, 
V1Table(default.ct_v1), [c#x, s#x]
+
+
+-- !query
+DESCRIBE testcat.ns.ct_v2
+-- !query analysis
+DescribeRelation false, [col_name#x, data_type#x, comment#x]
++- ResolvedTable 
org.apache.spark.sql.connector.catalog.InMemoryTableCatalog@xxxxxxxx, ns.ct_v2, 
org.apache.spark.sql.connector.catalog.InMemoryTable@xxxxxxxx, [c#x, s#x]
+
+
+-- !query
+CREATE TABLE ct_v1 (c INT) USING parquet
+-- !query analysis
+org.apache.spark.sql.catalyst.analysis.TableAlreadyExistsException
+{
+  "errorClass" : "TABLE_OR_VIEW_ALREADY_EXISTS",
+  "sqlState" : "42P07",
+  "messageParameters" : {
+    "relationName" : "`spark_catalog`.`default`.`ct_v1`"
+  }
+}
+
+
+-- !query
+CREATE TABLE testcat.ns.ct_v2 (c INT) USING parquet
+-- !query analysis
+org.apache.spark.sql.catalyst.analysis.TableAlreadyExistsException
+{
+  "errorClass" : "TABLE_OR_VIEW_ALREADY_EXISTS",
+  "sqlState" : "42P07",
+  "messageParameters" : {
+    "relationName" : "`ns`.`ct_v2`"
+  }
+}
+
+
+-- !query
+CREATE TABLE ct_dup (a INT, a STRING) USING parquet
+-- !query analysis
+org.apache.spark.sql.AnalysisException
+{
+  "errorClass" : "COLUMN_ALREADY_EXISTS",
+  "sqlState" : "42711",
+  "messageParameters" : {
+    "columnName" : "`a`"
+  }
+}
+
+
+-- !query
+CREATE TABLE ct_dup (a INT, A STRING) USING parquet
+-- !query analysis
+org.apache.spark.sql.AnalysisException
+{
+  "errorClass" : "COLUMN_ALREADY_EXISTS",
+  "sqlState" : "42711",
+  "messageParameters" : {
+    "columnName" : "`a`"
+  }
+}
+
+
+-- !query
+CREATE TABLE ct_nested (
+  st STRUCT<b: INT, c: STRING>,
+  m MAP<STRING, INT>,
+  arr ARRAY<INT>,
+  arr_st ARRAY<STRUCT<x: INT, y: STRING>>
+) USING parquet
+-- !query analysis
+CreateDataSourceTableCommand `spark_catalog`.`default`.`ct_nested`, false
+
+
+-- !query
+DESCRIBE ct_nested
+-- !query analysis
+DescribeTableCommand `spark_catalog`.`default`.`ct_nested`, false, 
[col_name#x, data_type#x, comment#x]
++- ResolvedTable V2SessionCatalog(spark_catalog), default.ct_nested, 
V1Table(default.ct_nested), [st#x, m#x, arr#x, arr_st#x]
+
+
+-- !query
+CREATE TABLE ct_not_null (c INT NOT NULL, s STRING) USING parquet
+-- !query analysis
+CreateDataSourceTableCommand `spark_catalog`.`default`.`ct_not_null`, false
+
+
+-- !query
+SHOW CREATE TABLE ct_not_null
+-- !query analysis
+ShowCreateTable false, [createtab_stmt#x]
++- ResolvedTable V2SessionCatalog(spark_catalog), default.ct_not_null, 
V1Table(default.ct_not_null), [c#x, s#x]
+
+
+-- !query
+CREATE TABLE ct_interval (i INTERVAL DAY) USING parquet
+-- !query analysis
+CreateDataSourceTableCommand `spark_catalog`.`default`.`ct_interval`, false
+
+
+-- !query
+CREATE TABLE testcat.ns.ct_interval (i INTERVAL DAY) USING parquet
+-- !query analysis
+CreateTable [columndefinition(i, DayTimeIntervalType(0,0), true, None, None, 
None, None, {})], 
TableSpec(Map(),Some(parquet),Map(),None,None,None,None,false,List()), false
++- ResolvedIdentifier 
org.apache.spark.sql.connector.catalog.InMemoryTableCatalog@xxxxxxxx, 
ns.ct_interval, [i#x]
+
+
+-- !query
+DESCRIBE ct_interval
+-- !query analysis
+DescribeTableCommand `spark_catalog`.`default`.`ct_interval`, false, 
[col_name#x, data_type#x, comment#x]
++- ResolvedTable V2SessionCatalog(spark_catalog), default.ct_interval, 
V1Table(default.ct_interval), [i#x]
+
+
+-- !query
+DESCRIBE testcat.ns.ct_interval
+-- !query analysis
+DescribeRelation false, [col_name#x, data_type#x, comment#x]
++- ResolvedTable 
org.apache.spark.sql.connector.catalog.InMemoryTableCatalog@xxxxxxxx, 
ns.ct_interval, org.apache.spark.sql.connector.catalog.InMemoryTable@xxxxxxxx, 
[i#x]
+
+
+-- !query
+CREATE TABLE default.ct_qualified (c INT) USING parquet
+-- !query analysis
+CreateDataSourceTableCommand `spark_catalog`.`default`.`ct_qualified`, false
+
+
+-- !query
+CREATE TABLE ct_no_such_schema.ct_x (c INT) USING parquet
+-- !query analysis
+org.apache.spark.sql.catalyst.analysis.NoSuchNamespaceException
+{
+  "errorClass" : "SCHEMA_NOT_FOUND",
+  "sqlState" : "42704",
+  "messageParameters" : {
+    "schemaName" : "`spark_catalog`.`ct_no_such_schema`"
+  }
+}
+
+
+-- !query
+EXECUTE IMMEDIATE 'CREATE TABLE IDENTIFIER(:n) (c INT) USING parquet' USING 
'ct_exec' AS n
+-- !query analysis
+ExecuteImmediateCommand
+   +- CreateDataSourceTableCommand `spark_catalog`.`default`.`ct_exec`, false
+
+
+-- !query
+DESCRIBE ct_exec
+-- !query analysis
+DescribeTableCommand `spark_catalog`.`default`.`ct_exec`, false, [col_name#x, 
data_type#x, comment#x]
++- ResolvedTable V2SessionCatalog(spark_catalog), default.ct_exec, 
V1Table(default.ct_exec), [c#x]
+
+
+-- !query
+CREATE TABLE ct_bad_provider (c INT) USING no_such_provider
+-- !query analysis
+org.apache.spark.SparkClassNotFoundException
+{
+  "errorClass" : "DATA_SOURCE_NOT_FOUND",
+  "sqlState" : "42K02",
+  "messageParameters" : {
+    "provider" : "no_such_provider"
+  }
+}
+
+
+-- !query
+CREATE TABLE ct_reserved (c INT) USING parquet TBLPROPERTIES ('provider' = 
'parquet')
+-- !query analysis
+org.apache.spark.sql.catalyst.parser.ParseException
+{
+  "errorClass" : "UNSUPPORTED_FEATURE.SET_TABLE_PROPERTY",
+  "sqlState" : "0A000",
+  "messageParameters" : {
+    "msg" : "please use the USING clause to specify it",
+    "property" : "provider"
+  },
+  "queryContext" : [ {
+    "objectType" : "",
+    "objectName" : "",
+    "startIndex" : 1,
+    "stopIndex" : 85,
+    "fragment" : "CREATE TABLE ct_reserved (c INT) USING parquet TBLPROPERTIES 
('provider' = 'parquet')"
+  } ]
+}
+
+
+-- !query
+CREATE SCHEMA ct_coll_schema DEFAULT COLLATION UTF8_LCASE
+-- !query analysis
+CreateNamespace false, [collation=UTF8_LCASE]
++- ResolvedNamespace V2SessionCatalog(spark_catalog), [ct_coll_schema]
+
+
+-- !query
+CREATE TABLE ct_coll_schema.ct_coll (s STRING) USING parquet
+-- !query analysis
+CreateDataSourceTableCommand `spark_catalog`.`ct_coll_schema`.`ct_coll`, false
+
+
+-- !query
+SHOW CREATE TABLE ct_coll_schema.ct_coll
+-- !query analysis
+ShowCreateTable false, [createtab_stmt#x]
++- ResolvedTable V2SessionCatalog(spark_catalog), ct_coll_schema.ct_coll, 
V1Table(ct_coll_schema.ct_coll), [s#x]
+
+
+-- !query
+REPLACE TABLE ct_repl_missing (c INT) USING parquet
+-- !query analysis
+org.apache.spark.sql.AnalysisException
+{
+  "errorClass" : "UNSUPPORTED_FEATURE.TABLE_OPERATION",
+  "sqlState" : "0A000",
+  "messageParameters" : {
+    "operation" : "REPLACE TABLE",
+    "tableName" : "`spark_catalog`.`default`.`ct_repl_missing`"
+  }
+}
+
+
+-- !query
+REPLACE TABLE testcat.ns.ct_repl_missing (c INT) USING parquet
+-- !query analysis
+org.apache.spark.sql.catalyst.analysis.CannotReplaceMissingTableException
+{
+  "errorClass" : "TABLE_OR_VIEW_NOT_FOUND",
+  "sqlState" : "42P01",
+  "messageParameters" : {
+    "relationName" : "`ns`.`ct_repl_missing`",
+    "searchPath" : "[`testcat`.`ns`]"
+  }
+}
+
+
+-- !query
+REPLACE TABLE testcat.ns.ct_v2 (c INT, d INT) USING parquet
+-- !query analysis
+ReplaceTable [columndefinition(c, IntegerType, true, None, None, None, None, 
{}), columndefinition(d, IntegerType, true, None, None, None, None, {})], 
TableSpec(Map(),Some(parquet),Map(),None,None,None,None,false,List()), false
++- ResolvedIdentifier 
org.apache.spark.sql.connector.catalog.InMemoryTableCatalog@xxxxxxxx, ns.ct_v2, 
[c#x, d#x]
+
+
+-- !query
+DESCRIBE testcat.ns.ct_v2
+-- !query analysis
+DescribeRelation false, [col_name#x, data_type#x, comment#x]
++- ResolvedTable 
org.apache.spark.sql.connector.catalog.InMemoryTableCatalog@xxxxxxxx, ns.ct_v2, 
org.apache.spark.sql.connector.catalog.InMemoryTable@xxxxxxxx, [c#x, d#x]
+
+
+-- !query
+REPLACE TABLE ct_v1 (c INT) USING parquet
+-- !query analysis
+org.apache.spark.sql.AnalysisException
+{
+  "errorClass" : "UNSUPPORTED_FEATURE.TABLE_OPERATION",
+  "sqlState" : "0A000",
+  "messageParameters" : {
+    "operation" : "REPLACE TABLE",
+    "tableName" : "`spark_catalog`.`default`.`ct_v1`"
+  }
+}
+
+
+-- !query
+CREATE OR REPLACE TABLE ct_cor_missing (c INT) USING parquet
+-- !query analysis
+org.apache.spark.sql.AnalysisException
+{
+  "errorClass" : "UNSUPPORTED_FEATURE.TABLE_OPERATION",
+  "sqlState" : "0A000",
+  "messageParameters" : {
+    "operation" : "REPLACE TABLE",
+    "tableName" : "`spark_catalog`.`default`.`ct_cor_missing`"
+  }
+}
+
+
+-- !query
+CREATE OR REPLACE TABLE testcat.ns.ct_cor_missing (c INT) USING parquet
+-- !query analysis
+ReplaceTable [columndefinition(c, IntegerType, true, None, None, None, None, 
{})], TableSpec(Map(),Some(parquet),Map(),None,None,None,None,false,List()), 
true
++- ResolvedIdentifier 
org.apache.spark.sql.connector.catalog.InMemoryTableCatalog@xxxxxxxx, 
ns.ct_cor_missing, [c#x]
+
+
+-- !query
+DESCRIBE testcat.ns.ct_cor_missing
+-- !query analysis
+DescribeRelation false, [col_name#x, data_type#x, comment#x]
++- ResolvedTable 
org.apache.spark.sql.connector.catalog.InMemoryTableCatalog@xxxxxxxx, 
ns.ct_cor_missing, 
org.apache.spark.sql.connector.catalog.InMemoryTable@xxxxxxxx, [c#x]
+
+
+-- !query
+CREATE OR REPLACE TABLE testcat.ns.ct_v2 (c INT, s STRING) USING parquet
+-- !query analysis
+ReplaceTable [columndefinition(c, IntegerType, true, None, None, None, None, 
{}), columndefinition(s, StringType, true, None, None, None, None, {})], 
TableSpec(Map(),Some(parquet),Map(),None,None,None,None,false,List()), true
++- ResolvedIdentifier 
org.apache.spark.sql.connector.catalog.InMemoryTableCatalog@xxxxxxxx, ns.ct_v2, 
[c#x, s#x]
+
+
+-- !query
+DESCRIBE testcat.ns.ct_v2
+-- !query analysis
+DescribeRelation false, [col_name#x, data_type#x, comment#x]
++- ResolvedTable 
org.apache.spark.sql.connector.catalog.InMemoryTableCatalog@xxxxxxxx, ns.ct_v2, 
org.apache.spark.sql.connector.catalog.InMemoryTable@xxxxxxxx, [c#x, s#x]
+
+
+-- !query
+CREATE TABLE ct_cor_parquet (c INT) USING parquet
+-- !query analysis
+CreateDataSourceTableCommand `spark_catalog`.`default`.`ct_cor_parquet`, false
+
+
+-- !query
+CREATE OR REPLACE TABLE ct_cor_parquet (c INT, d INT) USING parquet
+-- !query analysis
+org.apache.spark.sql.AnalysisException
+{
+  "errorClass" : "UNSUPPORTED_FEATURE.TABLE_OPERATION",
+  "sqlState" : "0A000",
+  "messageParameters" : {
+    "operation" : "REPLACE TABLE",
+    "tableName" : "`spark_catalog`.`default`.`ct_cor_parquet`"
+  }
+}
+
+
+-- !query
+DROP TABLE ct_v1
+-- !query analysis
+DropTable false, false
++- ResolvedIdentifier V2SessionCatalog(spark_catalog), default.ct_v1
+
+
+-- !query
+DROP TABLE testcat.ns.ct_v2
+-- !query analysis
+DropTable false, false
++- ResolvedIdentifier 
org.apache.spark.sql.connector.catalog.InMemoryTableCatalog@xxxxxxxx, ns.ct_v2
+
+
+-- !query
+DROP TABLE ct_default_provider
+-- !query analysis
+DropTable false, false
++- ResolvedIdentifier V2SessionCatalog(spark_catalog), 
default.ct_default_provider
+
+
+-- !query
+DROP TABLE ct_nested
+-- !query analysis
+DropTable false, false
++- ResolvedIdentifier V2SessionCatalog(spark_catalog), default.ct_nested
+
+
+-- !query
+DROP TABLE ct_not_null
+-- !query analysis
+DropTable false, false
++- ResolvedIdentifier V2SessionCatalog(spark_catalog), default.ct_not_null
+
+
+-- !query
+DROP TABLE ct_interval
+-- !query analysis
+DropTable false, false
++- ResolvedIdentifier V2SessionCatalog(spark_catalog), default.ct_interval
+
+
+-- !query
+DROP TABLE testcat.ns.ct_interval
+-- !query analysis
+DropTable false, false
++- ResolvedIdentifier 
org.apache.spark.sql.connector.catalog.InMemoryTableCatalog@xxxxxxxx, 
ns.ct_interval
+
+
+-- !query
+DROP TABLE default.ct_qualified
+-- !query analysis
+DropTable false, false
++- ResolvedIdentifier V2SessionCatalog(spark_catalog), default.ct_qualified
+
+
+-- !query
+DROP TABLE ct_exec
+-- !query analysis
+DropTable false, false
++- ResolvedIdentifier V2SessionCatalog(spark_catalog), default.ct_exec
+
+
+-- !query
+DROP TABLE testcat.ns.ct_cor_missing
+-- !query analysis
+DropTable false, false
++- ResolvedIdentifier 
org.apache.spark.sql.connector.catalog.InMemoryTableCatalog@xxxxxxxx, 
ns.ct_cor_missing
+
+
+-- !query
+DROP TABLE ct_cor_parquet
+-- !query analysis
+DropTable false, false
++- ResolvedIdentifier V2SessionCatalog(spark_catalog), default.ct_cor_parquet
+
+
+-- !query
+DROP SCHEMA ct_coll_schema CASCADE
+-- !query analysis
+DropNamespace false, true
++- ResolvedNamespace V2SessionCatalog(spark_catalog), [ct_coll_schema]
+
+
+-- !query
+DROP NAMESPACE testcat.ns
+-- !query analysis
+DropNamespace false, false
++- ResolvedNamespace 
org.apache.spark.sql.connector.catalog.InMemoryTableCatalog@xxxxxxxx, [ns]
diff --git a/sql/core/src/test/resources/sql-tests/inputs/create-table.sql 
b/sql/core/src/test/resources/sql-tests/inputs/create-table.sql
new file mode 100644
index 000000000000..e97920782e30
--- /dev/null
+++ b/sql/core/src/test/resources/sql-tests/inputs/create-table.sql
@@ -0,0 +1,94 @@
+--SET spark.sql.sources.default=json
+--SET 
spark.sql.catalog.testcat=org.apache.spark.sql.connector.catalog.InMemoryTableCatalog
+
+-- CREATE TABLE behavior in the session catalog and a V2 catalog.
+CREATE NAMESPACE testcat.ns;
+CREATE TABLE ct_v1 (c INT, s STRING COMMENT 'x') USING parquet;
+CREATE TABLE testcat.ns.ct_v2 (c INT, s STRING COMMENT 'x') USING parquet;
+
+-- Omitting USING selects the configured default provider.
+CREATE TABLE ct_default_provider (c INT);
+SHOW CREATE TABLE ct_default_provider;
+
+-- IF NOT EXISTS preserves the existing schema, even when a different schema 
is supplied.
+CREATE TABLE IF NOT EXISTS ct_v1 (c INT) USING parquet;
+CREATE TABLE IF NOT EXISTS testcat.ns.ct_v2 (c INT) USING parquet;
+DESCRIBE ct_v1;
+DESCRIBE testcat.ns.ct_v2;
+
+-- Creating an existing table without IF NOT EXISTS fails in both catalogs.
+CREATE TABLE ct_v1 (c INT) USING parquet;
+CREATE TABLE testcat.ns.ct_v2 (c INT) USING parquet;
+
+-- Duplicate column names, including case variants.
+CREATE TABLE ct_dup (a INT, a STRING) USING parquet;
+CREATE TABLE ct_dup (a INT, A STRING) USING parquet;
+
+-- Nested types and nullability.
+CREATE TABLE ct_nested (
+  st STRUCT<b: INT, c: STRING>,
+  m MAP<STRING, INT>,
+  arr ARRAY<INT>,
+  arr_st ARRAY<STRUCT<x: INT, y: STRING>>
+) USING parquet;
+DESCRIBE ct_nested;
+-- With spark.sql.fileSource.insert.enforceNotNull=false (the default), V1 
file-source tables
+-- store a nullable schema, so SHOW CREATE TABLE renders c INT NOT NULL as c 
INT.
+CREATE TABLE ct_not_null (c INT NOT NULL, s STRING) USING parquet;
+SHOW CREATE TABLE ct_not_null;
+
+-- Day-time interval columns in V1 and V2 tables.
+CREATE TABLE ct_interval (i INTERVAL DAY) USING parquet;
+CREATE TABLE testcat.ns.ct_interval (i INTERVAL DAY) USING parquet;
+DESCRIBE ct_interval;
+DESCRIBE testcat.ns.ct_interval;
+
+-- Qualified names: a valid schema and a missing schema.
+CREATE TABLE default.ct_qualified (c INT) USING parquet;
+CREATE TABLE ct_no_such_schema.ct_x (c INT) USING parquet;
+
+-- A named parameter supplies the CREATE TABLE identifier in dynamic SQL.
+EXECUTE IMMEDIATE 'CREATE TABLE IDENTIFIER(:n) (c INT) USING parquet' USING 
'ct_exec' AS n;
+DESCRIBE ct_exec;
+
+-- Unknown data source provider and reserved table property.
+CREATE TABLE ct_bad_provider (c INT) USING no_such_provider;
+CREATE TABLE ct_reserved (c INT) USING parquet TBLPROPERTIES ('provider' = 
'parquet');
+
+-- A table without an explicit collation inherits its schema's default 
collation.
+CREATE SCHEMA ct_coll_schema DEFAULT COLLATION UTF8_LCASE;
+CREATE TABLE ct_coll_schema.ct_coll (s STRING) USING parquet;
+SHOW CREATE TABLE ct_coll_schema.ct_coll;
+
+-- Session-catalog REPLACE with a non-V2 provider such as parquet is 
unsupported, even
+-- when the table is missing. In a V2 catalog, REPLACE requires an existing 
table.
+REPLACE TABLE ct_repl_missing (c INT) USING parquet;
+REPLACE TABLE testcat.ns.ct_repl_missing (c INT) USING parquet;
+REPLACE TABLE testcat.ns.ct_v2 (c INT, d INT) USING parquet;
+DESCRIBE testcat.ns.ct_v2;
+REPLACE TABLE ct_v1 (c INT) USING parquet;
+
+-- Session-catalog parquet statements fail because parquet is not a V2 
provider.
+-- In a V2 catalog, CREATE OR REPLACE creates a missing table or replaces an 
existing one.
+CREATE OR REPLACE TABLE ct_cor_missing (c INT) USING parquet;
+CREATE OR REPLACE TABLE testcat.ns.ct_cor_missing (c INT) USING parquet;
+DESCRIBE testcat.ns.ct_cor_missing;
+CREATE OR REPLACE TABLE testcat.ns.ct_v2 (c INT, s STRING) USING parquet;
+DESCRIBE testcat.ns.ct_v2;
+CREATE TABLE ct_cor_parquet (c INT) USING parquet;
+CREATE OR REPLACE TABLE ct_cor_parquet (c INT, d INT) USING parquet;
+
+-- Cleanup.
+DROP TABLE ct_v1;
+DROP TABLE testcat.ns.ct_v2;
+DROP TABLE ct_default_provider;
+DROP TABLE ct_nested;
+DROP TABLE ct_not_null;
+DROP TABLE ct_interval;
+DROP TABLE testcat.ns.ct_interval;
+DROP TABLE default.ct_qualified;
+DROP TABLE ct_exec;
+DROP TABLE testcat.ns.ct_cor_missing;
+DROP TABLE ct_cor_parquet;
+DROP SCHEMA ct_coll_schema CASCADE;
+DROP NAMESPACE testcat.ns;
diff --git a/sql/core/src/test/resources/sql-tests/results/create-table.sql.out 
b/sql/core/src/test/resources/sql-tests/results/create-table.sql.out
new file mode 100644
index 000000000000..779ef3ed4a5d
--- /dev/null
+++ b/sql/core/src/test/resources/sql-tests/results/create-table.sql.out
@@ -0,0 +1,556 @@
+-- Automatically generated by SQLQueryTestSuite
+-- !query
+CREATE NAMESPACE testcat.ns
+-- !query schema
+struct<>
+-- !query output
+
+
+
+-- !query
+CREATE TABLE ct_v1 (c INT, s STRING COMMENT 'x') USING parquet
+-- !query schema
+struct<>
+-- !query output
+
+
+
+-- !query
+CREATE TABLE testcat.ns.ct_v2 (c INT, s STRING COMMENT 'x') USING parquet
+-- !query schema
+struct<>
+-- !query output
+
+
+
+-- !query
+CREATE TABLE ct_default_provider (c INT)
+-- !query schema
+struct<>
+-- !query output
+
+
+
+-- !query
+SHOW CREATE TABLE ct_default_provider
+-- !query schema
+struct<createtab_stmt:string>
+-- !query output
+CREATE TABLE spark_catalog.default.ct_default_provider (
+  c INT)
+USING json
+
+
+-- !query
+CREATE TABLE IF NOT EXISTS ct_v1 (c INT) USING parquet
+-- !query schema
+struct<>
+-- !query output
+
+
+
+-- !query
+CREATE TABLE IF NOT EXISTS testcat.ns.ct_v2 (c INT) USING parquet
+-- !query schema
+struct<>
+-- !query output
+
+
+
+-- !query
+DESCRIBE ct_v1
+-- !query schema
+struct<col_name:string,data_type:string,comment:string>
+-- !query output
+c                      int                                         
+s                      string                  x
+
+
+-- !query
+DESCRIBE testcat.ns.ct_v2
+-- !query schema
+struct<col_name:string,data_type:string,comment:string>
+-- !query output
+c                      int                                         
+s                      string                  x
+
+
+-- !query
+CREATE TABLE ct_v1 (c INT) USING parquet
+-- !query schema
+struct<>
+-- !query output
+org.apache.spark.sql.catalyst.analysis.TableAlreadyExistsException
+{
+  "errorClass" : "TABLE_OR_VIEW_ALREADY_EXISTS",
+  "sqlState" : "42P07",
+  "messageParameters" : {
+    "relationName" : "`spark_catalog`.`default`.`ct_v1`"
+  }
+}
+
+
+-- !query
+CREATE TABLE testcat.ns.ct_v2 (c INT) USING parquet
+-- !query schema
+struct<>
+-- !query output
+org.apache.spark.sql.catalyst.analysis.TableAlreadyExistsException
+{
+  "errorClass" : "TABLE_OR_VIEW_ALREADY_EXISTS",
+  "sqlState" : "42P07",
+  "messageParameters" : {
+    "relationName" : "`ns`.`ct_v2`"
+  }
+}
+
+
+-- !query
+CREATE TABLE ct_dup (a INT, a STRING) USING parquet
+-- !query schema
+struct<>
+-- !query output
+org.apache.spark.sql.AnalysisException
+{
+  "errorClass" : "COLUMN_ALREADY_EXISTS",
+  "sqlState" : "42711",
+  "messageParameters" : {
+    "columnName" : "`a`"
+  }
+}
+
+
+-- !query
+CREATE TABLE ct_dup (a INT, A STRING) USING parquet
+-- !query schema
+struct<>
+-- !query output
+org.apache.spark.sql.AnalysisException
+{
+  "errorClass" : "COLUMN_ALREADY_EXISTS",
+  "sqlState" : "42711",
+  "messageParameters" : {
+    "columnName" : "`a`"
+  }
+}
+
+
+-- !query
+CREATE TABLE ct_nested (
+  st STRUCT<b: INT, c: STRING>,
+  m MAP<STRING, INT>,
+  arr ARRAY<INT>,
+  arr_st ARRAY<STRUCT<x: INT, y: STRING>>
+) USING parquet
+-- !query schema
+struct<>
+-- !query output
+
+
+
+-- !query
+DESCRIBE ct_nested
+-- !query schema
+struct<col_name:string,data_type:string,comment:string>
+-- !query output
+st                     struct<b:int,c:string>                      
+m                      map<string,int>                             
+arr                    array<int>                                  
+arr_st                 array<struct<x:int,y:string>>
+
+
+-- !query
+CREATE TABLE ct_not_null (c INT NOT NULL, s STRING) USING parquet
+-- !query schema
+struct<>
+-- !query output
+
+
+
+-- !query
+SHOW CREATE TABLE ct_not_null
+-- !query schema
+struct<createtab_stmt:string>
+-- !query output
+CREATE TABLE spark_catalog.default.ct_not_null (
+  c INT,
+  s STRING COLLATE UTF8_BINARY)
+USING parquet
+
+
+-- !query
+CREATE TABLE ct_interval (i INTERVAL DAY) USING parquet
+-- !query schema
+struct<>
+-- !query output
+
+
+
+-- !query
+CREATE TABLE testcat.ns.ct_interval (i INTERVAL DAY) USING parquet
+-- !query schema
+struct<>
+-- !query output
+
+
+
+-- !query
+DESCRIBE ct_interval
+-- !query schema
+struct<col_name:string,data_type:string,comment:string>
+-- !query output
+i                      interval day
+
+
+-- !query
+DESCRIBE testcat.ns.ct_interval
+-- !query schema
+struct<col_name:string,data_type:string,comment:string>
+-- !query output
+i                      interval day
+
+
+-- !query
+CREATE TABLE default.ct_qualified (c INT) USING parquet
+-- !query schema
+struct<>
+-- !query output
+
+
+
+-- !query
+CREATE TABLE ct_no_such_schema.ct_x (c INT) USING parquet
+-- !query schema
+struct<>
+-- !query output
+org.apache.spark.sql.catalyst.analysis.NoSuchNamespaceException
+{
+  "errorClass" : "SCHEMA_NOT_FOUND",
+  "sqlState" : "42704",
+  "messageParameters" : {
+    "schemaName" : "`spark_catalog`.`ct_no_such_schema`"
+  }
+}
+
+
+-- !query
+EXECUTE IMMEDIATE 'CREATE TABLE IDENTIFIER(:n) (c INT) USING parquet' USING 
'ct_exec' AS n
+-- !query schema
+struct<>
+-- !query output
+
+
+
+-- !query
+DESCRIBE ct_exec
+-- !query schema
+struct<col_name:string,data_type:string,comment:string>
+-- !query output
+c                      int
+
+
+-- !query
+CREATE TABLE ct_bad_provider (c INT) USING no_such_provider
+-- !query schema
+struct<>
+-- !query output
+org.apache.spark.SparkClassNotFoundException
+{
+  "errorClass" : "DATA_SOURCE_NOT_FOUND",
+  "sqlState" : "42K02",
+  "messageParameters" : {
+    "provider" : "no_such_provider"
+  }
+}
+
+
+-- !query
+CREATE TABLE ct_reserved (c INT) USING parquet TBLPROPERTIES ('provider' = 
'parquet')
+-- !query schema
+struct<>
+-- !query output
+org.apache.spark.sql.catalyst.parser.ParseException
+{
+  "errorClass" : "UNSUPPORTED_FEATURE.SET_TABLE_PROPERTY",
+  "sqlState" : "0A000",
+  "messageParameters" : {
+    "msg" : "please use the USING clause to specify it",
+    "property" : "provider"
+  },
+  "queryContext" : [ {
+    "objectType" : "",
+    "objectName" : "",
+    "startIndex" : 1,
+    "stopIndex" : 85,
+    "fragment" : "CREATE TABLE ct_reserved (c INT) USING parquet TBLPROPERTIES 
('provider' = 'parquet')"
+  } ]
+}
+
+
+-- !query
+CREATE SCHEMA ct_coll_schema DEFAULT COLLATION UTF8_LCASE
+-- !query schema
+struct<>
+-- !query output
+
+
+
+-- !query
+CREATE TABLE ct_coll_schema.ct_coll (s STRING) USING parquet
+-- !query schema
+struct<>
+-- !query output
+
+
+
+-- !query
+SHOW CREATE TABLE ct_coll_schema.ct_coll
+-- !query schema
+struct<createtab_stmt:string>
+-- !query output
+CREATE TABLE spark_catalog.ct_coll_schema.ct_coll (
+  s STRING COLLATE UTF8_LCASE)
+USING parquet
+DEFAULT COLLATION UTF8_LCASE
+
+
+-- !query
+REPLACE TABLE ct_repl_missing (c INT) USING parquet
+-- !query schema
+struct<>
+-- !query output
+org.apache.spark.sql.AnalysisException
+{
+  "errorClass" : "UNSUPPORTED_FEATURE.TABLE_OPERATION",
+  "sqlState" : "0A000",
+  "messageParameters" : {
+    "operation" : "REPLACE TABLE",
+    "tableName" : "`spark_catalog`.`default`.`ct_repl_missing`"
+  }
+}
+
+
+-- !query
+REPLACE TABLE testcat.ns.ct_repl_missing (c INT) USING parquet
+-- !query schema
+struct<>
+-- !query output
+org.apache.spark.sql.catalyst.analysis.CannotReplaceMissingTableException
+{
+  "errorClass" : "TABLE_OR_VIEW_NOT_FOUND",
+  "sqlState" : "42P01",
+  "messageParameters" : {
+    "relationName" : "`ns`.`ct_repl_missing`",
+    "searchPath" : "[`testcat`.`ns`]"
+  }
+}
+
+
+-- !query
+REPLACE TABLE testcat.ns.ct_v2 (c INT, d INT) USING parquet
+-- !query schema
+struct<>
+-- !query output
+
+
+
+-- !query
+DESCRIBE testcat.ns.ct_v2
+-- !query schema
+struct<col_name:string,data_type:string,comment:string>
+-- !query output
+c                      int                                         
+d                      int
+
+
+-- !query
+REPLACE TABLE ct_v1 (c INT) USING parquet
+-- !query schema
+struct<>
+-- !query output
+org.apache.spark.sql.AnalysisException
+{
+  "errorClass" : "UNSUPPORTED_FEATURE.TABLE_OPERATION",
+  "sqlState" : "0A000",
+  "messageParameters" : {
+    "operation" : "REPLACE TABLE",
+    "tableName" : "`spark_catalog`.`default`.`ct_v1`"
+  }
+}
+
+
+-- !query
+CREATE OR REPLACE TABLE ct_cor_missing (c INT) USING parquet
+-- !query schema
+struct<>
+-- !query output
+org.apache.spark.sql.AnalysisException
+{
+  "errorClass" : "UNSUPPORTED_FEATURE.TABLE_OPERATION",
+  "sqlState" : "0A000",
+  "messageParameters" : {
+    "operation" : "REPLACE TABLE",
+    "tableName" : "`spark_catalog`.`default`.`ct_cor_missing`"
+  }
+}
+
+
+-- !query
+CREATE OR REPLACE TABLE testcat.ns.ct_cor_missing (c INT) USING parquet
+-- !query schema
+struct<>
+-- !query output
+
+
+
+-- !query
+DESCRIBE testcat.ns.ct_cor_missing
+-- !query schema
+struct<col_name:string,data_type:string,comment:string>
+-- !query output
+c                      int
+
+
+-- !query
+CREATE OR REPLACE TABLE testcat.ns.ct_v2 (c INT, s STRING) USING parquet
+-- !query schema
+struct<>
+-- !query output
+
+
+
+-- !query
+DESCRIBE testcat.ns.ct_v2
+-- !query schema
+struct<col_name:string,data_type:string,comment:string>
+-- !query output
+c                      int                                         
+s                      string
+
+
+-- !query
+CREATE TABLE ct_cor_parquet (c INT) USING parquet
+-- !query schema
+struct<>
+-- !query output
+
+
+
+-- !query
+CREATE OR REPLACE TABLE ct_cor_parquet (c INT, d INT) USING parquet
+-- !query schema
+struct<>
+-- !query output
+org.apache.spark.sql.AnalysisException
+{
+  "errorClass" : "UNSUPPORTED_FEATURE.TABLE_OPERATION",
+  "sqlState" : "0A000",
+  "messageParameters" : {
+    "operation" : "REPLACE TABLE",
+    "tableName" : "`spark_catalog`.`default`.`ct_cor_parquet`"
+  }
+}
+
+
+-- !query
+DROP TABLE ct_v1
+-- !query schema
+struct<>
+-- !query output
+
+
+
+-- !query
+DROP TABLE testcat.ns.ct_v2
+-- !query schema
+struct<>
+-- !query output
+
+
+
+-- !query
+DROP TABLE ct_default_provider
+-- !query schema
+struct<>
+-- !query output
+
+
+
+-- !query
+DROP TABLE ct_nested
+-- !query schema
+struct<>
+-- !query output
+
+
+
+-- !query
+DROP TABLE ct_not_null
+-- !query schema
+struct<>
+-- !query output
+
+
+
+-- !query
+DROP TABLE ct_interval
+-- !query schema
+struct<>
+-- !query output
+
+
+
+-- !query
+DROP TABLE testcat.ns.ct_interval
+-- !query schema
+struct<>
+-- !query output
+
+
+
+-- !query
+DROP TABLE default.ct_qualified
+-- !query schema
+struct<>
+-- !query output
+
+
+
+-- !query
+DROP TABLE ct_exec
+-- !query schema
+struct<>
+-- !query output
+
+
+
+-- !query
+DROP TABLE testcat.ns.ct_cor_missing
+-- !query schema
+struct<>
+-- !query output
+
+
+
+-- !query
+DROP TABLE ct_cor_parquet
+-- !query schema
+struct<>
+-- !query output
+
+
+
+-- !query
+DROP SCHEMA ct_coll_schema CASCADE
+-- !query schema
+struct<>
+-- !query output
+
+
+
+-- !query
+DROP NAMESPACE testcat.ns
+-- !query schema
+struct<>
+-- !query output
+


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to