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]