Test Result : DataSourceV2SQLSuite

0 failures (±0) , 2 skipped (±0)
225 tests (±0)
Took 10 sec.

All Tests

Test nameDurationStatus
ALTER TABLE ADD PARTITION11 msPassed
ALTER TABLE DROP PARTITIONS10 msPassed
ALTER TABLE RECOVER PARTITIONS7 msPassed
ALTER TABLE RENAME PARTITION9 msPassed
ALTER TABLE SerDe properties10 msPassed
ALTER VIEW AS QUERY2 msPassed
ANALYZE TABLE8 msPassed
AlterNamespaceSetLocation using v2 catalog23 msPassed
AlterNamespaceSetProperties using v2 catalog34 msPassed
AlterNamespaceSetProperties: reserved properties76 msPassed
AlterTable: SET/DROP NOT NULL14 msPassed
AlterTable: add column - new column should not exist18 msPassed
AlterTable: add column with NOT NULL9 msPassed
AlterTable: add column with comment14 msPassed
AlterTable: add column with interval type11 msPassed
AlterTable: add column with position23 msPassed
AlterTable: add complex column10 msPassed
AlterTable: add multiple columns9 msPassed
AlterTable: add nested column11 msPassed
AlterTable: add nested column parent must exist7 msPassed
AlterTable: add nested column to array element11 msPassed
AlterTable: add nested column to map key12 msPassed
AlterTable: add nested column to map value13 msPassed
AlterTable: add nested column with comment8 msPassed
AlterTable: add top-level column15 msPassed
AlterTable: change rejected by implementation15 msPassed
AlterTable: comment update column must exist10 msPassed
AlterTable: drop column7 msPassed
AlterTable: drop column must exist9 msPassed
AlterTable: drop nested column8 msPassed
AlterTable: drop nested column in array element8 msPassed
AlterTable: drop nested column in map key10 msPassed
AlterTable: drop nested column in map value8 msPassed
AlterTable: nested comment update column must exist6 msPassed
AlterTable: nested drop column must exist7 msPassed
AlterTable: nested rename column must exist7 msPassed
AlterTable: nested update column must exist7 msPassed
AlterTable: remove table property12 msPassed
AlterTable: rename column9 msPassed
AlterTable: rename column - new name should not exist15 msPassed
AlterTable: rename column must exist9 msPassed
AlterTable: rename nested column8 msPassed
AlterTable: rename nested column in array element8 msPassed
AlterTable: rename nested column in map key9 msPassed
AlterTable: rename nested column in map value7 msPassed
AlterTable: rename table basic test94 msPassed
AlterTable: renaming views are not supported2 msPassed
AlterTable: set location9 msPassed
AlterTable: set partition location9 msPassed
AlterTable: set table property11 msPassed
AlterTable: table does not exist15 msPassed
AlterTable: update column array element type10 msPassed
AlterTable: update column comment9 msPassed
AlterTable: update column map value type11 msPassed
AlterTable: update column must exist7 msPassed
AlterTable: update column position29 msPassed
AlterTable: update column type int -> long12 msPassed
AlterTable: update column type must be compatible8 msPassed
AlterTable: update column type to interval8 msPassed
AlterTable: update column with array type fails8 msPassed
AlterTable: update column with map type fails7 msPassed
AlterTable: update column with struct type fails8 msPassed
AlterTable: update nested column comment9 msPassed
AlterTable: update nested column comment in array8 msPassed
AlterTable: update nested column comment in map key8 msPassed
AlterTable: update nested column comment in map value8 msPassed
AlterTable: update nested type float -> double9 msPassed
AlterTable: update nested type in array8 msPassed
AlterTable: update nested type in map key9 msPassed
AlterTable: update nested type in map value8 msPassed
CACHE TABLE7 msPassed
COMMENT ON NAMESPACE0.13 secPassed
COMMENT ON TABLE0.16 secPassed
CREATE FUNCTION: only support session catalog5 msPassed
CREATE VIEW2 msPassed
CTAS/RTAS: invalid schema if has interval type33 msPassed
CreateNameSpace: basic tests77 msPassed
CreateNameSpace: reserved properties64 msPassed
CreateNameSpace: test handling of 'IF NOT EXIST'14 msPassed
CreateTable/RepalceTable: invalid schema if has interval type23 msPassed
CreateTable: fail if table exists37 msPassed
CreateTable: if not exists37 msPassed
CreateTable: use default catalog for v2 sources when default catalog is set46 msPassed
CreateTable: use v2 plan and session catalog when provider is v243 msPassed
CreateTable: use v2 plan because catalog is set44 msPassed
CreateTable: without USING clause0 msSkipped
CreateTableAsSelect: do not double execute on collect(), take() and other queries0.14 secPassed
CreateTableAsSelect: fail if table exists95 msPassed
CreateTableAsSelect: if not exists91 msPassed
CreateTableAsSelect: nullable schema0.2 secPassed
CreateTableAsSelect: use default catalog for v2 sources when default catalog is set57 msPassed
CreateTableAsSelect: use v2 plan and session catalog when provider is v262 msPassed
CreateTableAsSelect: use v2 plan because catalog is set0.18 secPassed
CreateTableAsSelect: v2 session catalog can load v1 source table0.16 secPassed
CreateTableAsSelect: without USING clause0 msSkipped
DESCRIBE FUNCTION: only support session catalog3 msPassed
DROP FUNCTION: only support session catalog2 msPassed
DeleteFrom: DELETE is only supported with v2 tables15 msPassed
DeleteFrom: basic - delete all56 msPassed
DeleteFrom: basic - delete with where clause89 msPassed
DeleteFrom: delete from aliased target table69 msPassed
DeleteFrom: fail if has subquery95 msPassed
DeleteFrom: normalize attribute names84 msPassed
DescribeNamespace using v2 catalog36 msPassed
DescribeTable extended using v2 catalog19 msPassed
DescribeTable using v2 catalog41 msPassed
DescribeTable with v2 catalog when table does not exist.2 msPassed
DropNamespace: basic tests50 msPassed
DropNamespace: drop non-empty namespace with a cascade mode29 msPassed
DropNamespace: drop non-empty namespace with a non-cascading mode44 msPassed
DropNamespace: test handling of 'IF EXISTS'6 msPassed
DropTable: basic19 msPassed
DropTable: if exists5 msPassed
DropTable: table qualified with the session catalog name83 msPassed
InsertInto: append - across catalog81 msPassed
InsertInto: append to partitioned table - static clause0.11 secPassed
InsertInto: dynamic PARTITION clause fails with non-partition column38 msPassed
InsertInto: overwrite - dynamic clause - dynamic mode0.12 secPassed
InsertInto: overwrite - dynamic clause - static mode0.15 secPassed
InsertInto: overwrite - implicit dynamic partition - dynamic mode0.1 secPassed
InsertInto: overwrite - implicit dynamic partition - static mode0.12 secPassed
InsertInto: overwrite - missing clause - dynamic mode91 msPassed
InsertInto: overwrite - missing clause - static mode90 msPassed
InsertInto: overwrite - mixed clause - dynamic mode0.1 secPassed
InsertInto: overwrite - mixed clause - static mode96 msPassed
InsertInto: overwrite - mixed clause reordered - dynamic mode97 msPassed
InsertInto: overwrite - mixed clause reordered - static mode0.1 secPassed
InsertInto: overwrite - multiple static partitions - dynamic mode0.1 secPassed
InsertInto: overwrite - static clause0.15 secPassed
InsertInto: static PARTITION clause fails with non-partition column38 msPassed
InsertInto: when the table doesn't exist14 msPassed
LOAD DATA INTO TABLE12 msPassed
MERGE INTO TABLE59 msPassed
MSCK REPAIR TABLE7 msPassed
REFRESH TABLE: v2 table12 msPassed
REPLACE TABLE: v1 table3 msPassed
Relation: CTE59 msPassed
Relation: SparkSession.table()54 msPassed
Relation: basic0.1 secPassed
Relation: join tables in 2 catalogs0.24 secPassed
Relation: view text5 msPassed
ReplaceTable: Erases the table contents and changes the metadata.23 msPassed
ReplaceTableAsSelect: Atomic catalog does not drop the table when replace fails.24 msPassed
ReplaceTableAsSelect: CREATE OR REPLACE new table has same behavior as CTAS.70 msPassed
ReplaceTableAsSelect: Non-atomic catalog drops the table if the write fails.27 msPassed
ReplaceTableAsSelect: Non-atomic catalog drops the table permanently if the subsequent table creation fails.24 msPassed
ReplaceTableAsSelect: REPLACE TABLE throws exception if table does not exist.58 msPassed
ReplaceTableAsSelect: REPLACE TABLE throws exception if table is dropped before commit.25 msPassed
ReplaceTableAsSelect: basic v2 implementation.0.15 secPassed
ReplaceTableAsSelect: do not double execute CREATE OR REPLACE on collect()0.16 secPassed
ReplaceTableAsSelect: do not double execute REPLACE on collect()0.18 secPassed
SHOW COLUMNS7 msPassed
SHOW CREATE TABLE5 msPassed
SHOW FUNCTIONS not valid v1 namespace2 msPassed
SHOW PARTITIONS7 msPassed
SHOW TABLE EXTENDED not valid v1 database10 msPassed
SHOW TABLE EXTENDED valid v113 msPassed
SHOW TBLPROPERTIES(key): v2 table12 msPassed
SHOW TBLPROPERTIES(key): v2 table, key not found12 msPassed
SHOW TBLPROPERTIES: v2 table90 msPassed
SPARK-30001: session catalog name can be specified in SQL statements0.2 secPassed
SPARK-30094: current namespace is used during table resolution0.22 secPassed
SPARK-30104: global temp db is used as a table name under v2 catalog16 msPassed
SPARK-30104: v2 catalog named global_temp will be masked1 msPassed
SPARK-30259: session catalog can be specified in CREATE TABLE AS SELECT command74 msPassed
SPARK-30259: session catalog can be specified in CREATE TABLE command10 msPassed
SPARK-30284: CREATE VIEW should track the current catalog and namespace0.14 secPassed
SPARK-30799: temp view name can't contain catalog name5 msPassed
SPARK-30814: add column with position referencing new columns being added18 msPassed
SPARK-30885: v1 table name should be fully qualified0.22 secPassed
SPARK-31015: star expression should work for qualified column names for v2 tables0.34 secPassed
SPARK-32168: INSERT OVERWRITE - hidden days partition - dynamic mode0.14 secPassed
SPARK-33435: REFRESH TABLE should invalidate all caches referencing the table64 msPassed
ShowCurrentNamespace: basic tests24 msPassed
ShowNamespaces: change catalog and namespace with USE statements31 msPassed
ShowNamespaces: default v2 catalog doesn't support namespace4 msPassed
ShowNamespaces: default v2 catalog is not set9 msPassed
ShowNamespaces: session catalog is used and namespace doesn't exist6 msPassed
ShowNamespaces: show namespaces with v2 catalog58 msPassed
ShowNamespaces: show root namespaces with default v2 catalog34 msPassed
ShowNamespaces: v2 catalog doesn't support namespace4 msPassed
ShowTables: change current catalog and namespace with USE statements27 msPassed
ShowTables: namespace is not specified and default v2 catalog is set13 msPassed
ShowTables: namespace not specified and default v2 catalog not set - fallback to v113 msPassed
ShowTables: using v1 catalog11 msPassed
ShowTables: using v1 catalog, db doesn't exist3 msPassed
ShowTables: using v1 catalog, db name with multipartIdentifier ('a.b') is not allowed.2 msPassed
ShowTables: using v2 catalog44 msPassed
ShowTables: using v2 catalog with a pattern43 msPassed
ShowTables: using v2 catalog with empty namespace14 msPassed
ShowTables: using v2 catalog, namespace doesn't exist6 msPassed
ShowViews: using v1 catalog, db name with multipartIdentifier ('a.b') is not allowed.2 msPassed
ShowViews: using v2 catalog, command not supported.4 msPassed
TRUNCATE TABLE9 msPassed
UNCACHE TABLE6 msPassed
UPDATE TABLE32 msPassed
Use: basic tests with USE statements25 msPassed
Use: set v2 catalog as a current catalog2 msPassed
Use: v2 catalog is used and namespace does not exist2 msPassed
Use: v2 session catalog is used and namespace does not exist3 msPassed
create/replace - path property27 msPassed
create/replace/alter table - reserved properties0.1 secPassed
do not double insert on INSERT INTO collect()0.1 secPassed
global temp view should not be masked by v2 catalog49 msPassed
insertInto: append0.1 secPassed
insertInto: append by position71 msPassed
insertInto: append partitioned table74 msPassed
insertInto: fails when an extra column is present58 msPassed
insertInto: fails when missing a column49 msPassed
insertInto: overwrite non-partitioned table88 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 mode95 msPassed
insertInto: overwrite partitioned table in static mode by position0.12 secPassed
qualified column names for v1 tables0.76 secPassed
qualified column names for v2 tables0.35 secPassed
table name same as catalog can be used14 msPassed
tableCreation: bucket column name containing dot11 msPassed
tableCreation: bucket column names not in table definition12 msPassed
tableCreation: column repeated in bucket columns10 msPassed
tableCreation: column repeated in partition columns17 msPassed
tableCreation: duplicate column names in the table definition14 msPassed
tableCreation: duplicate nested column names in the table definition15 msPassed
tableCreation: partition column case insensitive resolution24 msPassed
tableCreation: partition column case sensitive resolution7 msPassed