Test Result : DataSourceV2SQLSuite

0 failures (±0)
194 tests (±0)
Took 14 sec.

All Tests

Test nameDurationStatus
ALTER TABLE ADD PARTITION15 msPassed
ALTER TABLE DROP PARTITIONS17 msPassed
ALTER TABLE RECOVER PARTITIONS15 msPassed
ALTER TABLE RENAME PARTITION19 msPassed
ALTER TABLE SerDe properties20 msPassed
ALTER VIEW AS QUERY3 msPassed
ANALYZE TABLE15 msPassed
AlterNamespaceSetLocation using v2 catalog49 msPassed
AlterNamespaceSetProperties using v2 catalog44 msPassed
AlterTable: add column with comment46 msPassed
AlterTable: add column with position77 msPassed
AlterTable: add complex column26 msPassed
AlterTable: add multiple columns27 msPassed
AlterTable: add nested column25 msPassed
AlterTable: add nested column parent must exist17 msPassed
AlterTable: add nested column to array element24 msPassed
AlterTable: add nested column to map key26 msPassed
AlterTable: add nested column to map value25 msPassed
AlterTable: add nested column with comment24 msPassed
AlterTable: add top-level column39 msPassed
AlterTable: change rejected by implementation39 msPassed
AlterTable: comment update column must exist18 msPassed
AlterTable: drop column25 msPassed
AlterTable: drop column must exist19 msPassed
AlterTable: drop nested column24 msPassed
AlterTable: drop nested column in array element25 msPassed
AlterTable: drop nested column in map key25 msPassed
AlterTable: drop nested column in map value25 msPassed
AlterTable: nested comment update column must exist18 msPassed
AlterTable: nested drop column must exist18 msPassed
AlterTable: nested rename column must exist18 msPassed
AlterTable: nested update column must exist16 msPassed
AlterTable: remove table property29 msPassed
AlterTable: rename column27 msPassed
AlterTable: rename column must exist16 msPassed
AlterTable: rename nested column28 msPassed
AlterTable: rename nested column in array element24 msPassed
AlterTable: rename nested column in map key23 msPassed
AlterTable: rename nested column in map value24 msPassed
AlterTable: rename table basic test0.19 secPassed
AlterTable: renaming views are not supported5 msPassed
AlterTable: set location26 msPassed
AlterTable: set partition location18 msPassed
AlterTable: set table property27 msPassed
AlterTable: table does not exist25 msPassed
AlterTable: update column array element type26 msPassed
AlterTable: update column comment26 msPassed
AlterTable: update column map value type25 msPassed
AlterTable: update column must exist15 msPassed
AlterTable: update column position80 msPassed
AlterTable: update column type and comment26 msPassed
AlterTable: update column type int -> long30 msPassed
AlterTable: update column type must be compatible15 msPassed
AlterTable: update column with array type fails21 msPassed
AlterTable: update column with map type fails19 msPassed
AlterTable: update column with struct type fails19 msPassed
AlterTable: update nested column comment29 msPassed
AlterTable: update nested column comment in array26 msPassed
AlterTable: update nested column comment in map key25 msPassed
AlterTable: update nested column comment in map value25 msPassed
AlterTable: update nested type float -> double25 msPassed
AlterTable: update nested type in array23 msPassed
AlterTable: update nested type in map key26 msPassed
AlterTable: update nested type in map value25 msPassed
CACHE TABLE20 msPassed
CREATE VIEW4 msPassed
CreateNameSpace: basic tests0.15 secPassed
CreateNameSpace: test handling of 'IF NOT EXIST'51 msPassed
CreateTable: fail if table exists72 msPassed
CreateTable: if not exists70 msPassed
CreateTable: use default catalog for v2 sources when default catalog is set66 msPassed
CreateTable: use v2 plan and session catalog when provider is v286 msPassed
CreateTable: use v2 plan because catalog is set69 msPassed
CreateTableAsSelect: fail if table exists0.2 secPassed
CreateTableAsSelect: if not exists0.18 secPassed
CreateTableAsSelect: nullable schema0.38 secPassed
CreateTableAsSelect: use default catalog for v2 sources when default catalog is set0.11 secPassed
CreateTableAsSelect: use v2 plan and session catalog when provider is v20.1 secPassed
CreateTableAsSelect: use v2 plan because catalog is set0.24 secPassed
CreateTableAsSelect: v2 session catalog can load v1 source table0.26 secPassed
DESCRIBE FUNCTION: only support session catalog4 msPassed
DROP FUNCTION: only support session catalog4 msPassed
DeleteFrom: DELETE is only supported with v2 tables33 msPassed
DeleteFrom: basic - delete all0.1 secPassed
DeleteFrom: basic - delete with where clause0.13 secPassed
DeleteFrom: delete from aliased target table0.12 secPassed
DeleteFrom: fail if has subquery0.18 secPassed
DeleteFrom: normalize attribute names0.11 secPassed
DescribeNamespace using v2 catalog57 msPassed
DescribeTable extended using v2 catalog36 msPassed
DescribeTable using v2 catalog77 msPassed
DescribeTable with v2 catalog when table does not exist3 msPassed
DropNamespace: basic tests83 msPassed
DropNamespace: drop non-empty namespace with a cascade mode58 msPassed
DropNamespace: drop non-empty namespace with a non-cascading mode0.1 secPassed
DropNamespace: test handling of 'IF EXISTS'16 msPassed
DropTable: basic39 msPassed
DropTable: if exists14 msPassed
DropTable: table qualified with the session catalog name0.16 secPassed
InsertInto: append - across catalog0.18 secPassed
InsertInto: append to partitioned table - static clause0.22 secPassed
InsertInto: dynamic PARTITION clause fails with non-partition column92 msPassed
InsertInto: overwrite - dynamic clause - dynamic mode0.22 secPassed
InsertInto: overwrite - dynamic clause - static mode0.24 secPassed
InsertInto: overwrite - implicit dynamic partition - dynamic mode0.18 secPassed
InsertInto: overwrite - implicit dynamic partition - static mode0.18 secPassed
InsertInto: overwrite - missing clause - dynamic mode0.23 secPassed
InsertInto: overwrite - missing clause - static mode0.2 secPassed
InsertInto: overwrite - mixed clause - dynamic mode0.2 secPassed
InsertInto: overwrite - mixed clause - static mode0.19 secPassed
InsertInto: overwrite - mixed clause reordered - dynamic mode0.18 secPassed
InsertInto: overwrite - mixed clause reordered - static mode0.2 secPassed
InsertInto: overwrite - multiple static partitions - dynamic mode0.22 secPassed
InsertInto: overwrite - static clause0.25 secPassed
InsertInto: static PARTITION clause fails with non-partition column0.11 secPassed
InsertInto: when the table doesn't exist68 msPassed
LOAD DATA INTO TABLE19 msPassed
MERGE INTO TABLE99 msPassed
MSCK REPAIR TABLE16 msPassed
REFRESH TABLE: v2 table29 msPassed
REPLACE TABLE: v1 table3 msPassed
Relation: CTE0.16 secPassed
Relation: basic0.21 secPassed
Relation: join tables in 2 catalogs0.46 secPassed
Relation: view text18 msPassed
ReplaceTable: Erases the table contents and changes the metadata42 msPassed
ReplaceTableAsSelect: Atomic catalog does not drop the table when replace fails46 msPassed
ReplaceTableAsSelect: CREATE OR REPLACE new table has same behavior as CTAS0.12 secPassed
ReplaceTableAsSelect: Non-atomic catalog drops the table if the write fails55 msPassed
ReplaceTableAsSelect: Non-atomic catalog drops the table permanently if the subsequent table creation fails62 msPassed
ReplaceTableAsSelect: REPLACE TABLE throws exception if table does not exist94 msPassed
ReplaceTableAsSelect: REPLACE TABLE throws exception if table is dropped before commit49 msPassed
ReplaceTableAsSelect: basic v2 implementation0.35 secPassed
SHOW COLUMNS20 msPassed
SHOW CREATE TABLE18 msPassed
SHOW FUNCTIONS not valid v1 namespace4 msPassed
SHOW PARTITIONS19 msPassed
SHOW TABLE EXTENDED not valid v1 database20 msPassed
SHOW TABLE EXTENDED valid v122 msPassed
SHOW TBLPROPERTIES(key): v2 table32 msPassed
SHOW TBLPROPERTIES(key): v2 table, key not found29 msPassed
SHOW TBLPROPERTIES: v2 table37 msPassed
SPARK-30001: session catalog name can be specified in SQL statements0.41 secPassed
SPARK-30094: current namespace is used during table resolution0.71 secPassed
SPARK-30104: global temp db is used as a table name under v2 catalog36 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.13 secPassed
SPARK-30259: session catalog can be specified in CREATE TABLE command23 msPassed
ShowCurrentNamespace: basic tests63 msPassed
ShowNamespaces: change catalog and namespace with USE statements70 msPassed
ShowNamespaces: default v2 catalog doesn't support namespace2 msPassed
ShowNamespaces: default v2 catalog is not set23 msPassed
ShowNamespaces: session catalog is used and namespace doesn't exist9 msPassed
ShowNamespaces: show namespaces with v2 catalog0.11 secPassed
ShowNamespaces: show root namespaces with default v2 catalog64 msPassed
ShowNamespaces: v2 catalog doesn't support namespace1 msPassed
ShowTables: change current catalog and namespace with USE statements70 msPassed
ShowTables: namespace is not specified and default v2 catalog is set24 msPassed
ShowTables: namespace not specified and default v2 catalog not set - fallback to v123 msPassed
ShowTables: using v1 catalog21 msPassed
ShowTables: using v1 catalog, db doesn't exist9 msPassed
ShowTables: using v2 catalog70 msPassed
ShowTables: using v2 catalog with a pattern80 msPassed
ShowTables: using v2 catalog with empty namespace26 msPassed
ShowTables: using v2 catalog, namespace doesn't exist12 msPassed
TRUNCATE TABLE20 msPassed
UNCACHE TABLE19 msPassed
UPDATE TABLE44 msPassed
Use: basic tests with USE statements81 msPassed
Use: set v2 catalog as a current catalog12 msPassed
Use: v2 catalog is used and namespace does not exist12 msPassed
Use: v2 session catalog is used and namespace does not exist9 msPassed
b') is not allowed2 msPassed
global temp view should not be masked by v2 catalog0.15 secPassed
insertInto: append0.18 secPassed
insertInto: append by position0.12 secPassed
insertInto: append partitioned table0.17 secPassed
insertInto: fails when an extra column is present0.1 secPassed
insertInto: fails when missing a column94 msPassed
insertInto: overwrite non-partitioned table0.16 secPassed
insertInto: overwrite partitioned table in dynamic mode0.23 secPassed
insertInto: overwrite partitioned table in dynamic mode by position0.18 secPassed
insertInto: overwrite partitioned table in static mode0.18 secPassed
insertInto: overwrite partitioned table in static mode by position0.21 secPassed
table name same as catalog can be used37 msPassed
table()0.11 secPassed
tableCreation: bucket column name containing dot20 msPassed
tableCreation: bucket column names not in table definition16 msPassed
tableCreation: column repeated in bucket columns13 msPassed
tableCreation: column repeated in partition columns17 msPassed
tableCreation: duplicate column names in the table definition10 msPassed
tableCreation: duplicate nested column names in the table definition14 msPassed
tableCreation: partition column case insensitive resolution43 msPassed
tableCreation: partition column case sensitive resolution7 msPassed