Test Result : DataSourceV2SQLSuite

0 failures , 1 skipped
231 tests
Took 15 sec.

All Tests

Test nameDurationStatus
ALTER NAMESPACE .. SET LOCATION using v2 catalog21 msPassed
ALTER NAMESPACE .. SET PROPERTIES reserved properties57 msPassed
ALTER NAMESPACE .. SET PROPERTIES using v2 catalog26 msPassed
ALTER TABLE SerDe properties17 msPassed
ANALYZE TABLE15 msPassed
AlterTable: SET/DROP NOT NULL15 msPassed
AlterTable: add column - new column should not exist17 msPassed
AlterTable: add column with NOT NULL10 msPassed
AlterTable: add column with comment10 msPassed
AlterTable: add column with interval type13 msPassed
AlterTable: add column with position27 msPassed
AlterTable: add complex column10 msPassed
AlterTable: add multiple columns10 msPassed
AlterTable: add nested column10 msPassed
AlterTable: add nested column parent must exist9 msPassed
AlterTable: add nested column to array element12 msPassed
AlterTable: add nested column to map key13 msPassed
AlterTable: add nested column to map value11 msPassed
AlterTable: add nested column with comment10 msPassed
AlterTable: add top-level column10 msPassed
AlterTable: change rejected by implementation12 msPassed
AlterTable: comment update column must exist10 msPassed
AlterTable: drop column9 msPassed
AlterTable: drop column must exist10 msPassed
AlterTable: drop nested column10 msPassed
AlterTable: drop nested column in array element10 msPassed
AlterTable: drop nested column in map key10 msPassed
AlterTable: drop nested column in map value10 msPassed
AlterTable: nested comment update column must exist18 msPassed
AlterTable: nested drop column must exist9 msPassed
AlterTable: nested rename column must exist9 msPassed
AlterTable: nested update column must exist10 msPassed
AlterTable: remove table property24 msPassed
AlterTable: rename column10 msPassed
AlterTable: rename column - new name should not exist18 msPassed
AlterTable: rename column must exist8 msPassed
AlterTable: rename nested column9 msPassed
AlterTable: rename nested column in array element10 msPassed
AlterTable: rename nested column in map key10 msPassed
AlterTable: rename nested column in map value9 msPassed
AlterTable: renaming views are not supported3 msPassed
AlterTable: replace columns15 msPassed
AlterTable: set location15 msPassed
AlterTable: set partition location11 msPassed
AlterTable: set table property14 msPassed
AlterTable: table does not exist10 msPassed
AlterTable: update column array element type10 msPassed
AlterTable: update column comment9 msPassed
AlterTable: update column map value type10 msPassed
AlterTable: update column must exist9 msPassed
AlterTable: update column position30 msPassed
AlterTable: update column type int -> long11 msPassed
AlterTable: update column type must be compatible9 msPassed
AlterTable: update column type to interval10 msPassed
AlterTable: update column with array type fails10 msPassed
AlterTable: update column with map type fails9 msPassed
AlterTable: update column with struct type fails10 msPassed
AlterTable: update nested column comment10 msPassed
AlterTable: update nested column comment in array10 msPassed
AlterTable: update nested column comment in map key11 msPassed
AlterTable: update nested column comment in map value10 msPassed
AlterTable: update nested type float -> double10 msPassed
AlterTable: update nested type in array10 msPassed
AlterTable: update nested type in map key10 msPassed
AlterTable: update nested type in map value10 msPassed
CACHE/UNCACHE TABLE75 msPassed
COMMENT ON NAMESPACE0.13 secPassed
COMMENT ON TABLE0.16 secPassed
CREATE FUNCTION: only support session catalog3 msPassed
CREATE VIEW3 msPassed
CTAS/RTAS: invalid schema if has interval type21 msPassed
CreateNameSpace: basic tests80 msPassed
CreateNameSpace: reserved properties81 msPassed
CreateNameSpace: test handling of 'IF NOT EXIST'12 msPassed
CreateTable/ReplaceTable: invalid schema if has interval type18 msPassed
CreateTable: fail if table exists39 msPassed
CreateTable: if not exists38 msPassed
CreateTable: use default catalog for v2 sources when default catalog is set35 msPassed
CreateTable: use v2 plan and session catalog when provider is v248 msPassed
CreateTable: use v2 plan because catalog is set50 msPassed
CreateTable: without USING clause12 msPassed
CreateTableAsSelect: do not double execute on collect(), take() and other queries0.17 secPassed
CreateTableAsSelect: fail if table exists98 msPassed
CreateTableAsSelect: if not exists94 msPassed
CreateTableAsSelect: nullable schema0.21 secPassed
CreateTableAsSelect: use default catalog for v2 sources when default catalog is set56 msPassed
CreateTableAsSelect: use v2 plan and session catalog when provider is v271 msPassed
CreateTableAsSelect: use v2 plan because catalog is set0.11 secPassed
CreateTableAsSelect: v2 session catalog can load v1 source table0.17 secPassed
CreateTableAsSelect: without USING clause0 msSkipped
DESCRIBE FUNCTION: only support session catalog4 msPassed
DROP FUNCTION: only support session catalog3 msPassed
DeleteFrom: DELETE is only supported with v2 tables20 msPassed
DeleteFrom: basic - delete all61 msPassed
DeleteFrom: basic - delete with where clause67 msPassed
DeleteFrom: delete from aliased target table67 msPassed
DeleteFrom: delete with unsupported predicates78 msPassed
DeleteFrom: fail if has subquery84 msPassed
DeleteFrom: normalize attribute names65 msPassed
Describe column for v2 catalog73 msPassed
Describe column for v2 catalog should work with qualified columns71 msPassed
DescribeNamespace using v2 catalog28 msPassed
DescribeTable extended using v2 catalog21 msPassed
DescribeTable using v2 catalog58 msPassed
DescribeTable with v2 catalog when table does not exist.3 msPassed
Describing nested column for v2 catalog is not supported12 msPassed
DropNamespace: basic tests37 msPassed
DropNamespace: drop non-empty namespace with a cascade mode28 msPassed
DropNamespace: drop non-empty namespace with a non-cascading mode45 msPassed
DropNamespace: test handling of 'IF EXISTS'7 msPassed
InsertInto: append - across catalog78 msPassed
InsertInto: append to partitioned table - static clause0.11 secPassed
InsertInto: dynamic PARTITION clause fails with non-partition column42 msPassed
InsertInto: overwrite - dynamic clause - dynamic mode97 msPassed
InsertInto: overwrite - dynamic clause - static mode0.11 secPassed
InsertInto: overwrite - implicit dynamic partition - dynamic mode0.1 secPassed
InsertInto: overwrite - implicit dynamic partition - static mode99 msPassed
InsertInto: overwrite - missing clause - dynamic mode96 msPassed
InsertInto: overwrite - missing clause - static mode94 msPassed
InsertInto: overwrite - mixed clause - dynamic mode0.1 secPassed
InsertInto: overwrite - mixed clause - static mode0.1 secPassed
InsertInto: overwrite - mixed clause reordered - dynamic mode99 msPassed
InsertInto: overwrite - mixed clause reordered - static mode0.1 secPassed
InsertInto: overwrite - multiple static partitions - dynamic mode0.1 secPassed
InsertInto: overwrite - static clause0.18 secPassed
InsertInto: static PARTITION clause fails with non-partition column43 msPassed
InsertInto: when the table doesn't exist16 msPassed
LOAD DATA INTO TABLE25 msPassed
MERGE INTO TABLE71 msPassed
MSCK REPAIR TABLE14 msPassed
REFRESH FUNCTION: only support session catalog5 msPassed
REFRESH TABLE: v2 table14 msPassed
REPLACE TABLE: v1 table4 msPassed
Relation: CTE62 msPassed
Relation: SparkSession.table()59 msPassed
Relation: basic0.1 secPassed
Relation: join tables in 2 catalogs0.28 secPassed
Relation: view text79 msPassed
ReplaceTable: Erases the table contents and changes the metadata.20 msPassed
ReplaceTableAsSelect: Atomic catalog does not drop the table when replace fails.21 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.23 msPassed
ReplaceTableAsSelect: Non-atomic catalog drops the table permanently if the subsequent table creation fails.21 msPassed
ReplaceTableAsSelect: REPLACE TABLE throws exception if table does not exist.42 msPassed
ReplaceTableAsSelect: REPLACE TABLE throws exception if table is dropped before commit.20 msPassed
ReplaceTableAsSelect: basic v2 implementation.0.16 secPassed
ReplaceTableAsSelect: do not double execute CREATE OR REPLACE on collect()0.16 secPassed
ReplaceTableAsSelect: do not double execute REPLACE on collect()0.16 secPassed
SHOW COLUMNS25 msPassed
SHOW CREATE TABLE15 msPassed
SHOW FUNCTIONS not valid v1 namespace3 msPassed
SHOW TBLPROPERTIES(key): v2 table18 msPassed
SHOW TBLPROPERTIES(key): v2 table, key not found17 msPassed
SHOW TBLPROPERTIES: v2 table0.15 secPassed
SPARK-30001: session catalog name can be specified in SQL statements0.22 secPassed
SPARK-30094: current namespace is used during table resolution0.21 secPassed
SPARK-30104: global temp db is used as a table name under v2 catalog18 msPassed
SPARK-30104: v2 catalog named global_temp will be masked4 msPassed
SPARK-30259: session catalog can be specified in CREATE TABLE AS SELECT command78 msPassed
SPARK-30259: session catalog can be specified in CREATE TABLE command14 msPassed
SPARK-30284: CREATE VIEW should track the current catalog and namespace0.16 secPassed
SPARK-30799: temp view name can't contain catalog name10 msPassed
SPARK-30814: add column with position referencing new columns being added20 msPassed
SPARK-30885: v1 table name should be fully qualified0.2 secPassed
SPARK-31015: star expression should work for qualified column names for v2 tables0.32 secPassed
SPARK-31100: Use: v2 catalog that does not implement SupportsNameSpaces is used and namespace does not exist5 msPassed
SPARK-31100: Use: v2 catalog that implements SupportsNamespaces is used and namespace not exists4 msPassed
SPARK-31255: * expansion does not include metadata columns0.1 secPassed
SPARK-31255: Project a metadata column0.15 secPassed
SPARK-31255: Projects data column when metadata column has the same name0.14 secPassed
SPARK-31255: metadata column should only be produced when necessary18 msPassed
SPARK-32168: INSERT OVERWRITE - hidden days partition - dynamic mode0.15 secPassed
SPARK-32990: REFRESH TABLE should resolve to a temporary view first22 msPassed
SPARK-33004: Describe column should resolve to a temporary view first49 msPassed
SPARK-33435, SPARK-34099: REFRESH TABLE should refresh all caches referencing the table0.28 secPassed
SPARK-33492: AppendData should refresh cache0.35 secPassed
SPARK-33492: OverwriteByExpression should refresh cache0.27 secPassed
SPARK-33492: OverwritePartitionsDynamic should refresh cache0.3 secPassed
SPARK-33492: ReplaceTableAsSelect (atomic or non-atomic) should invalidate cache0.37 secPassed
SPARK-33505: insert into partitioned table52 msPassed
SPARK-33652: DeleteFrom should refresh caches referencing the table0.17 secPassed
SPARK-33653: REFRESH TABLE should recache the target table itself0.1 secPassed
SPARK-33924: INSERT INTO .. PARTITION preserves the partition location28 msPassed
SPARK-34039: ReplaceTable (atomic or non-atomic) should invalidate cache0.37 secPassed
SPARK-34468: rename table in place when the destination name has single part0.11 secPassed
SPARK-34547: metadata columns are resolved last0.28 secPassed
SPARK-34555: Resolve DataFrame metadata column71 msPassed
SPARK-34561: drop/add columns to a dataset of `DESCRIBE TABLE`18 msPassed
SPARK-34576: drop/add columns to a dataset of `DESCRIBE COLUMN`16 msPassed
SPARK-34577: drop/add columns to a dataset of `DESCRIBE NAMESPACE`13 msPassed
SPARK-34599: InsertInto: overwrite - dot in the partition column name - static mode0.14 secPassed
SPARK-34923: do not propagate metadata columns through Project31 msPassed
SPARK-34923: do not propagate metadata columns through View0.15 secPassed
SPARK-34923: propagate metadata columns through Filter0.15 secPassed
SPARK-34923: propagate metadata columns through RepartitionBy0.23 secPassed
SPARK-34923: propagate metadata columns through Sort0.3 secPassed
SPARK-34923: propagate metadata columns through SubqueryAlias0.11 secPassed
ShowCurrentNamespace: basic tests33 msPassed
ShowViews: using v1 catalog, db name with multipartIdentifier ('a.b') is not allowed.8 msPassed
ShowViews: using v2 catalog, command not supported.2 msPassed
UPDATE TABLE33 msPassed
Use: basic tests with USE statements24 msPassed
Use: set v2 catalog as a current catalog3 msPassed
Use: v2 session catalog is used and namespace does not exist4 msPassed
View commands are not supported in v2 catalogs8 msPassed
create/replace - path property48 msPassed
create/replace/alter table - reserved properties0.14 secPassed
do not double insert on INSERT INTO collect()0.14 secPassed
global temp view should not be masked by v2 catalog88 msPassed
insertInto: append89 msPassed
insertInto: append by position77 msPassed
insertInto: append partitioned table76 msPassed
insertInto: fails when an extra column is present81 msPassed
insertInto: fails when missing a column65 msPassed
insertInto: overwrite non-partitioned table93 msPassed
insertInto: overwrite partitioned table in dynamic mode0.13 secPassed
insertInto: overwrite partitioned table in dynamic mode by position0.11 secPassed
insertInto: overwrite partitioned table in static mode99 msPassed
insertInto: overwrite partitioned table in static mode by position0.11 secPassed
qualified column names for v1 tables0.75 secPassed
qualified column names for v2 tables0.36 secPassed
rename table by ALTER VIEW98 msPassed
table name same as catalog can be used17 msPassed
tableCreation: bucket column name containing dot12 msPassed
tableCreation: bucket column names not in table definition17 msPassed
tableCreation: column repeated in bucket columns16 msPassed
tableCreation: column repeated in partition columns18 msPassed
tableCreation: duplicate column names in the table definition16 msPassed
tableCreation: duplicate nested column names in the table definition15 msPassed
tableCreation: partition column case insensitive resolution26 msPassed
tableCreation: partition column case sensitive resolution14 msPassed