Test Result : DataSourceV2SQLSuite

0 failures (±0) , 1 skipped (±0)
238 tests (±0)
Took 13 sec.

All Tests

Test nameDurationStatus
ALTER NAMESPACE .. SET LOCATION using v2 catalog12 msPassed
ALTER NAMESPACE .. SET PROPERTIES reserved properties80 msPassed
ALTER NAMESPACE .. SET PROPERTIES using v2 catalog14 msPassed
ALTER TABLE SerDe properties8 msPassed
ANALYZE TABLE7 msPassed
AlterTable: SET/DROP NOT NULL9 msPassed
AlterTable: add column - new column should not exist13 msPassed
AlterTable: add column with NOT NULL6 msPassed
AlterTable: add column with comment6 msPassed
AlterTable: add column with interval type6 msPassed
AlterTable: add column with position21 msPassed
AlterTable: add complex column7 msPassed
AlterTable: add multiple columns6 msPassed
AlterTable: add nested column7 msPassed
AlterTable: add nested column parent must exist5 msPassed
AlterTable: add nested column to array element9 msPassed
AlterTable: add nested column to map key7 msPassed
AlterTable: add nested column to map value7 msPassed
AlterTable: add nested column with comment7 msPassed
AlterTable: add top-level column6 msPassed
AlterTable: change rejected by implementation6 msPassed
AlterTable: comment update column must exist4 msPassed
AlterTable: drop column6 msPassed
AlterTable: drop column must exist5 msPassed
AlterTable: drop nested column6 msPassed
AlterTable: drop nested column in array element6 msPassed
AlterTable: drop nested column in map key6 msPassed
AlterTable: drop nested column in map value6 msPassed
AlterTable: nested comment update column must exist4 msPassed
AlterTable: nested drop column must exist5 msPassed
AlterTable: nested rename column must exist5 msPassed
AlterTable: nested update column must exist5 msPassed
AlterTable: remove table property7 msPassed
AlterTable: rename column6 msPassed
AlterTable: rename column - new name should not exist12 msPassed
AlterTable: rename column must exist5 msPassed
AlterTable: rename nested column6 msPassed
AlterTable: rename nested column in array element6 msPassed
AlterTable: rename nested column in map key6 msPassed
AlterTable: rename nested column in map value6 msPassed
AlterTable: renaming views are not supported1 msPassed
AlterTable: replace columns9 msPassed
AlterTable: set location7 msPassed
AlterTable: set partition location6 msPassed
AlterTable: set table property7 msPassed
AlterTable: table does not exist5 msPassed
AlterTable: update column array element type6 msPassed
AlterTable: update column comment6 msPassed
AlterTable: update column map value type6 msPassed
AlterTable: update column must exist4 msPassed
AlterTable: update column position17 msPassed
AlterTable: update column type int -> long6 msPassed
AlterTable: update column type must be compatible5 msPassed
AlterTable: update column type to interval26 msPassed
AlterTable: update column with array type fails5 msPassed
AlterTable: update column with map type fails5 msPassed
AlterTable: update column with struct type fails6 msPassed
AlterTable: update nested column comment7 msPassed
AlterTable: update nested column comment in array6 msPassed
AlterTable: update nested column comment in map key6 msPassed
AlterTable: update nested column comment in map value6 msPassed
AlterTable: update nested type float -> double6 msPassed
AlterTable: update nested type in array6 msPassed
AlterTable: update nested type in map key5 msPassed
AlterTable: update nested type in map value6 msPassed
CACHE/UNCACHE TABLE49 msPassed
COMMENT ON NAMESPACE0.21 secPassed
COMMENT ON TABLE0.23 secPassed
CREATE FUNCTION: only support session catalog1 msPassed
CREATE VIEW1 msPassed
CTAS/RTAS: invalid schema if has interval type12 msPassed
CreateNameSpace: basic tests62 msPassed
CreateNameSpace: reserved properties91 msPassed
CreateNameSpace: test handling of 'IF NOT EXIST'6 msPassed
CreateTable/ReplaceTable: invalid schema if has interval type10 msPassed
CreateTable: fail if table exists29 msPassed
CreateTable: if not exists29 msPassed
CreateTable: use default catalog for v2 sources when default catalog is set27 msPassed
CreateTable: use v2 plan and session catalog when provider is v238 msPassed
CreateTable: use v2 plan because catalog is set38 msPassed
CreateTable: without USING clause11 msPassed
CreateTableAsSelect: do not double execute on collect(), take() and other queries0.1 secPassed
CreateTableAsSelect: fail if table exists97 msPassed
CreateTableAsSelect: if not exists98 msPassed
CreateTableAsSelect: nullable schema0.19 secPassed
CreateTableAsSelect: use default catalog for v2 sources when default catalog is set47 msPassed
CreateTableAsSelect: use v2 plan and session catalog when provider is v258 msPassed
CreateTableAsSelect: use v2 plan because catalog is set79 msPassed
CreateTableAsSelect: v2 session catalog can load v1 source table0.2 secPassed
CreateTableAsSelect: without USING clause0 msSkipped
DESCRIBE FUNCTION: only support session catalog1 msPassed
DROP FUNCTION: only support session catalog2 msPassed
DeleteFrom: DELETE is only supported with v2 tables15 msPassed
DeleteFrom: basic - delete all43 msPassed
DeleteFrom: basic - delete with where clause64 msPassed
DeleteFrom: delete from aliased target table58 msPassed
DeleteFrom: delete with unsupported predicates52 msPassed
DeleteFrom: fail if has subquery81 msPassed
DeleteFrom: normalize attribute names63 msPassed
Describe column for v2 catalog32 msPassed
Describe column for v2 catalog should work with qualified columns27 msPassed
DescribeNamespace using v2 catalog14 msPassed
DescribeTable extended using v2 catalog12 msPassed
DescribeTable using v2 catalog31 msPassed
DescribeTable with v2 catalog when table does not exist.1 msPassed
Describing nested column for v2 catalog is not supported7 msPassed
DropNamespace: basic tests26 msPassed
DropNamespace: drop non-empty namespace with a cascade mode17 msPassed
DropNamespace: drop non-empty namespace with a non-cascading mode26 msPassed
DropNamespace: test handling of 'IF EXISTS'4 msPassed
InsertInto: IF PARTITION NOT EXISTS not supported26 msPassed
InsertInto: append - across catalog82 msPassed
InsertInto: append to partitioned table - static clause97 msPassed
InsertInto: dynamic PARTITION clause fails with non-partition column26 msPassed
InsertInto: overwrite - dynamic clause - dynamic mode83 msPassed
InsertInto: overwrite - dynamic clause - static mode90 msPassed
InsertInto: overwrite - implicit dynamic partition - dynamic mode0.1 secPassed
InsertInto: overwrite - implicit dynamic partition - static mode99 msPassed
InsertInto: overwrite - missing clause - dynamic mode93 msPassed
InsertInto: overwrite - missing clause - static mode97 msPassed
InsertInto: overwrite - mixed clause - dynamic mode96 msPassed
InsertInto: overwrite - mixed clause - static mode0.1 secPassed
InsertInto: overwrite - mixed clause reordered - dynamic mode0.1 secPassed
InsertInto: overwrite - mixed clause reordered - static mode97 msPassed
InsertInto: overwrite - multiple static partitions - dynamic mode78 msPassed
InsertInto: overwrite - static clause0.11 secPassed
InsertInto: static PARTITION clause fails with non-partition column27 msPassed
InsertInto: when the table doesn't exist9 msPassed
LOAD DATA INTO TABLE12 msPassed
MERGE INTO TABLE28 msPassed
MSCK REPAIR TABLE6 msPassed
REFRESH FUNCTION: only support session catalog2 msPassed
REFRESH TABLE: v2 table8 msPassed
REPLACE TABLE: v1 table3 msPassed
Relation: CTE64 msPassed
Relation: SparkSession.table()64 msPassed
Relation: basic0.11 secPassed
Relation: join tables in 2 catalogs0.22 secPassed
Relation: view text68 msPassed
ReplaceTable: Erases the table contents and changes the metadata.18 msPassed
ReplaceTableAsSelect: Atomic catalog does not drop the table when replace fails.17 msPassed
ReplaceTableAsSelect: CREATE OR REPLACE new table has same behavior as CTAS.54 msPassed
ReplaceTableAsSelect: Non-atomic catalog drops the table if the write fails.17 msPassed
ReplaceTableAsSelect: Non-atomic catalog drops the table permanently if the subsequent table creation fails.17 msPassed
ReplaceTableAsSelect: REPLACE TABLE throws exception if table does not exist.37 msPassed
ReplaceTableAsSelect: REPLACE TABLE throws exception if table is dropped before commit.18 msPassed
ReplaceTableAsSelect: basic v2 implementation.0.11 secPassed
ReplaceTableAsSelect: do not double execute CREATE OR REPLACE on collect()0.15 secPassed
ReplaceTableAsSelect: do not double execute REPLACE on collect()0.14 secPassed
SHOW COLUMNS11 msPassed
SHOW FUNCTIONS not valid v1 namespace0 msPassed
SHOW TBLPROPERTIES(key): v2 table15 msPassed
SHOW TBLPROPERTIES(key): v2 table, key not found10 msPassed
SHOW TBLPROPERTIES: v2 table13 msPassed
SPARK-30001: session catalog name can be specified in SQL statements0.24 secPassed
SPARK-30094: current namespace is used during table resolution0.28 secPassed
SPARK-30104: global temp db is used as a table name under v2 catalog21 msPassed
SPARK-30104: v2 catalog named global_temp will be masked3 msPassed
SPARK-30259: session catalog can be specified in CREATE TABLE AS SELECT command0.12 secPassed
SPARK-30259: session catalog can be specified in CREATE TABLE command13 msPassed
SPARK-30284: CREATE VIEW should track the current catalog and namespace0.19 secPassed
SPARK-30799: temp view name can't contain catalog name6 msPassed
SPARK-30814: add column with position referencing new columns being added10 msPassed
SPARK-30885: v1 table name should be fully qualified0.21 secPassed
SPARK-31015: star expression should work for qualified column names for v2 tables0.31 secPassed
SPARK-31100: Use: v2 catalog that does not implement SupportsNameSpaces is used and namespace does not exist2 msPassed
SPARK-31100: Use: v2 catalog that implements SupportsNamespaces is used and namespace not exists2 msPassed
SPARK-31255: * expansion does not include metadata columns0.11 secPassed
SPARK-31255: Project a metadata column0.12 secPassed
SPARK-31255: Projects data column when metadata column has the same name0.13 secPassed
SPARK-31255: metadata column should only be produced when necessary10 msPassed
SPARK-32168: INSERT OVERWRITE - hidden days partition - dynamic mode0.1 secPassed
SPARK-32990: REFRESH TABLE should resolve to a temporary view first14 msPassed
SPARK-33004: Describe column should resolve to a temporary view first33 msPassed
SPARK-33435, SPARK-34099: REFRESH TABLE should refresh all caches referencing the table0.25 secPassed
SPARK-33492: AppendData should refresh cache0.28 secPassed
SPARK-33492: OverwriteByExpression should refresh cache0.25 secPassed
SPARK-33492: OverwritePartitionsDynamic should refresh cache0.21 secPassed
SPARK-33492: ReplaceTableAsSelect (atomic or non-atomic) should invalidate cache0.32 secPassed
SPARK-33505: insert into partitioned table43 msPassed
SPARK-33652: DeleteFrom should refresh caches referencing the table0.18 secPassed
SPARK-33653: REFRESH TABLE should recache the target table itself48 msPassed
SPARK-33898: SHOW CREATE TABLE16 msPassed
SPARK-33898: SHOW CREATE TABLE AS SERDE6 msPassed
SPARK-33898: SHOW CREATE TABLE PARTITIONED BY Transforms18 msPassed
SPARK-33898: SHOW CREATE TABLE WITH AS SELECT24 msPassed
SPARK-33924: INSERT INTO .. PARTITION preserves the partition location21 msPassed
SPARK-34039: ReplaceTable (atomic or non-atomic) should invalidate cache0.31 secPassed
SPARK-34468: rename table in place when the destination name has single part95 msPassed
SPARK-34547: metadata columns are resolved last0.29 secPassed
SPARK-34555: Resolve DataFrame metadata column72 msPassed
SPARK-34561: drop/add columns to a dataset of `DESCRIBE TABLE`9 msPassed
SPARK-34576: drop/add columns to a dataset of `DESCRIBE COLUMN`9 msPassed
SPARK-34577: drop/add columns to a dataset of `DESCRIBE NAMESPACE`10 msPassed
SPARK-34599: InsertInto: overwrite - dot in the partition column name - static mode91 msPassed
SPARK-34923: do not propagate metadata columns through Project22 msPassed
SPARK-34923: do not propagate metadata columns through View81 msPassed
SPARK-34923: propagate metadata columns through Filter0.11 secPassed
SPARK-34923: propagate metadata columns through RepartitionBy0.33 secPassed
SPARK-34923: propagate metadata columns through Sort0.24 secPassed
SPARK-34923: propagate metadata columns through SubqueryAlias97 msPassed
SPARK-34947: micro batch streaming write should invalidate cache0.33 secPassed
SPARK-36372: Adding duplicate columns should not be allowed6 msPassed
SPARK-36372: Adding duplicate nested columns should not be allowed6 msPassed
ShowCurrentNamespace: basic tests19 msPassed
ShowViews: using v1 catalog, db name with multipartIdentifier ('a.b') is not allowed.6 msPassed
ShowViews: using v2 catalog, command not supported.1 msPassed
UPDATE TABLE18 msPassed
Use: basic tests with USE statements13 msPassed
Use: set v2 catalog as a current catalog2 msPassed
Use: v2 session catalog is used and namespace does not exist3 msPassed
View commands are not supported in v2 catalogs5 msPassed
create/replace - path property15 msPassed
create/replace/alter table - reserved properties82 msPassed
do not double insert on INSERT INTO collect()64 msPassed
global temp view should not be masked by v2 catalog44 msPassed
insertInto: append74 msPassed
insertInto: append by position71 msPassed
insertInto: append partitioned table74 msPassed
insertInto: fails when an extra column is present43 msPassed
insertInto: fails when missing a column34 msPassed
insertInto: overwrite non-partitioned table85 msPassed
insertInto: overwrite partitioned table in dynamic mode0.13 secPassed
insertInto: overwrite partitioned table in dynamic mode by position0.1 secPassed
insertInto: overwrite partitioned table in static mode99 msPassed
insertInto: overwrite partitioned table in static mode by position0.1 secPassed
qualified column names for v1 tables0.82 secPassed
qualified column names for v2 tables0.32 secPassed
rename table by ALTER VIEW62 msPassed
table name same as catalog can be used9 msPassed
tableCreation: bucket column name containing dot7 msPassed
tableCreation: bucket column names not in table definition8 msPassed
tableCreation: column repeated in bucket columns9 msPassed
tableCreation: column repeated in partition columns11 msPassed
tableCreation: duplicate column names in the table definition9 msPassed
tableCreation: duplicate nested column names in the table definition9 msPassed
tableCreation: partition column case insensitive resolution22 msPassed
tableCreation: partition column case sensitive resolution6 msPassed