Test Result : DataSourceV2SQLSuite

0 failures (±0) , 2 skipped (±0)
224 tests (±0)
Took 18 sec.

All Tests

Test nameDurationStatus
ALTER TABLE ADD PARTITION17 msPassed
ALTER TABLE DROP PARTITIONS16 msPassed
ALTER TABLE RECOVER PARTITIONS16 msPassed
ALTER TABLE RENAME PARTITION17 msPassed
ALTER TABLE SerDe properties35 msPassed
ALTER VIEW AS QUERY2 msPassed
ANALYZE TABLE18 msPassed
AlterNamespaceSetLocation using v2 catalog44 msPassed
AlterNamespaceSetProperties using v2 catalog56 msPassed
AlterNamespaceSetProperties: reserved properties0.19 secPassed
AlterTable: SET/DROP NOT NULL34 msPassed
AlterTable: add column - new column should not exist32 msPassed
AlterTable: add column with NOT NULL20 msPassed
AlterTable: add column with comment21 msPassed
AlterTable: add column with interval type20 msPassed
AlterTable: add column with position45 msPassed
AlterTable: add complex column34 msPassed
AlterTable: add multiple columns21 msPassed
AlterTable: add nested column23 msPassed
AlterTable: add nested column parent must exist18 msPassed
AlterTable: add nested column to array element29 msPassed
AlterTable: add nested column to map key25 msPassed
AlterTable: add nested column to map value28 msPassed
AlterTable: add nested column with comment31 msPassed
AlterTable: add top-level column22 msPassed
AlterTable: change rejected by implementation25 msPassed
AlterTable: comment update column must exist16 msPassed
AlterTable: drop column24 msPassed
AlterTable: drop column must exist15 msPassed
AlterTable: drop nested column23 msPassed
AlterTable: drop nested column in array element24 msPassed
AlterTable: drop nested column in map key20 msPassed
AlterTable: drop nested column in map value23 msPassed
AlterTable: nested comment update column must exist19 msPassed
AlterTable: nested drop column must exist18 msPassed
AlterTable: nested rename column must exist18 msPassed
AlterTable: nested update column must exist17 msPassed
AlterTable: remove table property41 msPassed
AlterTable: rename column26 msPassed
AlterTable: rename column - new name should not exist29 msPassed
AlterTable: rename column must exist17 msPassed
AlterTable: rename nested column22 msPassed
AlterTable: rename nested column in array element23 msPassed
AlterTable: rename nested column in map key22 msPassed
AlterTable: rename nested column in map value24 msPassed
AlterTable: rename table basic test0.18 secPassed
AlterTable: renaming views are not supported1 msPassed
AlterTable: replace columns24 msPassed
AlterTable: set location23 msPassed
AlterTable: set partition location16 msPassed
AlterTable: set table property19 msPassed
AlterTable: table does not exist19 msPassed
AlterTable: update column array element type24 msPassed
AlterTable: update column comment23 msPassed
AlterTable: update column map value type23 msPassed
AlterTable: update column must exist24 msPassed
AlterTable: update column position57 msPassed
AlterTable: update column type int -> long23 msPassed
AlterTable: update column type must be compatible28 msPassed
AlterTable: update column type to interval16 msPassed
AlterTable: update column with array type fails18 msPassed
AlterTable: update column with map type fails16 msPassed
AlterTable: update column with struct type fails16 msPassed
AlterTable: update nested column comment22 msPassed
AlterTable: update nested column comment in array24 msPassed
AlterTable: update nested column comment in map key26 msPassed
AlterTable: update nested column comment in map value24 msPassed
AlterTable: update nested type float -> double20 msPassed
AlterTable: update nested type in array23 msPassed
AlterTable: update nested type in map key25 msPassed
AlterTable: update nested type in map value24 msPassed
CACHE TABLE17 msPassed
COMMENT ON NAMESPACE0.32 secPassed
COMMENT ON TABLE0.34 secPassed
CREATE FUNCTION: only support session catalog4 msPassed
CREATE VIEW2 msPassed
CTAS/RTAS: invalid schema if has interval type18 msPassed
CreateNameSpace: basic tests0.11 secPassed
CreateNameSpace: reserved properties0.13 secPassed
CreateNameSpace: test handling of 'IF NOT EXIST'32 msPassed
CreateTable/RepalceTable: invalid schema if has interval type12 msPassed
CreateTable: fail if table exists67 msPassed
CreateTable: if not exists64 msPassed
CreateTable: use default catalog for v2 sources when default catalog is set67 msPassed
CreateTable: use v2 plan and session catalog when provider is v275 msPassed
CreateTable: use v2 plan because catalog is set69 msPassed
CreateTable: without USING clause-1 msSkipped
CreateTableAsSelect: do not double execute on collect(), take() and other queries0.26 secPassed
CreateTableAsSelect: fail if table exists0.15 secPassed
CreateTableAsSelect: if not exists0.15 secPassed
CreateTableAsSelect: nullable schema0.32 secPassed
CreateTableAsSelect: use default catalog for v2 sources when default catalog is set89 msPassed
CreateTableAsSelect: use v2 plan and session catalog when provider is v287 msPassed
CreateTableAsSelect: use v2 plan because catalog is set0.18 secPassed
CreateTableAsSelect: v2 session catalog can load v1 source table0.19 secPassed
CreateTableAsSelect: without USING clause-1 msSkipped
DESCRIBE FUNCTION: only support session catalog2 msPassed
DROP FUNCTION: only support session catalog2 msPassed
DeleteFrom: DELETE is only supported with v2 tables37 msPassed
DeleteFrom: basic - delete all0.12 secPassed
DeleteFrom: basic - delete with where clause0.1 secPassed
DeleteFrom: delete from aliased target table0.1 secPassed
DeleteFrom: fail if has subquery0.14 secPassed
DeleteFrom: normalize attribute names0.11 secPassed
DescribeNamespace using v2 catalog43 msPassed
DescribeTable extended using v2 catalog33 msPassed
DescribeTable using v2 catalog66 msPassed
DescribeTable with v2 catalog when table does not exist3 msPassed
DropNamespace: basic tests84 msPassed
DropNamespace: drop non-empty namespace with a cascade mode64 msPassed
DropNamespace: drop non-empty namespace with a non-cascading mode0.11 secPassed
DropNamespace: test handling of 'IF EXISTS'20 msPassed
DropTable: basic55 msPassed
DropTable: if exists14 msPassed
DropTable: table qualified with the session catalog name83 msPassed
InsertInto: append - across catalog0.13 secPassed
InsertInto: append to partitioned table - static clause0.16 secPassed
InsertInto: dynamic PARTITION clause fails with non-partition column74 msPassed
InsertInto: overwrite - dynamic clause - dynamic mode0.16 secPassed
InsertInto: overwrite - dynamic clause - static mode0.17 secPassed
InsertInto: overwrite - implicit dynamic partition - dynamic mode0.14 secPassed
InsertInto: overwrite - implicit dynamic partition - static mode0.16 secPassed
InsertInto: overwrite - missing clause - dynamic mode0.14 secPassed
InsertInto: overwrite - missing clause - static mode0.14 secPassed
InsertInto: overwrite - mixed clause - dynamic mode0.17 secPassed
InsertInto: overwrite - mixed clause - static mode0.24 secPassed
InsertInto: overwrite - mixed clause reordered - dynamic mode0.15 secPassed
InsertInto: overwrite - mixed clause reordered - static mode0.16 secPassed
InsertInto: overwrite - multiple static partitions - dynamic mode0.15 secPassed
InsertInto: overwrite - static clause0.23 secPassed
InsertInto: static PARTITION clause fails with non-partition column76 msPassed
InsertInto: when the table doesn't exist35 msPassed
LOAD DATA INTO TABLE23 msPassed
MERGE INTO TABLE74 msPassed
MSCK REPAIR TABLE18 msPassed
REFRESH TABLE: v2 table29 msPassed
REPLACE TABLE: v1 table4 msPassed
Relation: CTE97 msPassed
Relation: basic0.15 secPassed
Relation: join tables in 2 catalogs0.41 secPassed
Relation: view text18 msPassed
ReplaceTable: Erases the table contents and changes the metadata35 msPassed
ReplaceTableAsSelect: Atomic catalog does not drop the table when replace fails37 msPassed
ReplaceTableAsSelect: CREATE OR REPLACE new table has same behavior as CTAS95 msPassed
ReplaceTableAsSelect: Non-atomic catalog drops the table if the write fails37 msPassed
ReplaceTableAsSelect: Non-atomic catalog drops the table permanently if the subsequent table creation fails40 msPassed
ReplaceTableAsSelect: REPLACE TABLE throws exception if table does not exist76 msPassed
ReplaceTableAsSelect: REPLACE TABLE throws exception if table is dropped before commit38 msPassed
ReplaceTableAsSelect: basic v2 implementation0.22 secPassed
ReplaceTableAsSelect: do not double execute CREATE OR REPLACE on collect()0.32 secPassed
ReplaceTableAsSelect: do not double execute REPLACE on collect()0.3 secPassed
SHOW COLUMNS18 msPassed
SHOW CREATE TABLE15 msPassed
SHOW FUNCTIONS not valid v1 namespace0.26 secPassed
SHOW PARTITIONS16 msPassed
SHOW TABLE EXTENDED not valid v1 database17 msPassed
SHOW TABLE EXTENDED valid v120 msPassed
SHOW TBLPROPERTIES(key): v2 table30 msPassed
SHOW TBLPROPERTIES(key): v2 table, key not found30 msPassed
SHOW TBLPROPERTIES: v2 table0.2 secPassed
SPARK-30001: session catalog name can be specified in SQL statements0.62 secPassed
SPARK-30094: current namespace is used during table resolution0.27 secPassed
SPARK-30104: global temp db is used as a table name under v2 catalog38 msPassed
SPARK-30104: v2 catalog named global_temp will be masked2 msPassed
SPARK-30259: session catalog can be specified in CREATE TABLE AS SELECT command81 msPassed
SPARK-30259: session catalog can be specified in CREATE TABLE command21 msPassed
SPARK-30284: CREATE VIEW should track the current catalog and namespace0.25 secPassed
SPARK-30799: temp view name can't contain catalog name41 msPassed
SPARK-30814: add column with position referencing new columns being added33 msPassed
SPARK-30885: v1 table name should be fully qualified0.32 secPassed
SPARK-31015: star expression should work for qualified column names for v2 tables0.53 secPassed
ShowCurrentNamespace: basic tests68 msPassed
ShowNamespaces: change catalog and namespace with USE statements59 msPassed
ShowNamespaces: default v2 catalog doesn't support namespace13 msPassed
ShowNamespaces: default v2 catalog is not set21 msPassed
ShowNamespaces: session catalog is used and namespace doesn't exist10 msPassed
ShowNamespaces: show namespaces with v2 catalog0.11 secPassed
ShowNamespaces: show root namespaces with default v2 catalog60 msPassed
ShowNamespaces: v2 catalog doesn't support namespace11 msPassed
ShowTables: change current catalog and namespace with USE statements53 msPassed
ShowTables: namespace is not specified and default v2 catalog is set21 msPassed
ShowTables: namespace not specified and default v2 catalog not set - fallback to v119 msPassed
ShowTables: using v1 catalog16 msPassed
ShowTables: using v1 catalog, db doesn't exist8 msPassed
ShowTables: using v2 catalog71 msPassed
ShowTables: using v2 catalog with a pattern71 msPassed
ShowTables: using v2 catalog with empty namespace21 msPassed
ShowTables: using v2 catalog, namespace doesn't exist14 msPassed
ShowViews: using v2 catalog, command not supported4 msPassed
TRUNCATE TABLE16 msPassed
UNCACHE TABLE16 msPassed
UPDATE TABLE37 msPassed
Use: basic tests with USE statements64 msPassed
Use: set v2 catalog as a current catalog6 msPassed
Use: v2 catalog is used and namespace does not exist8 msPassed
Use: v2 session catalog is used and namespace does not exist7 msPassed
b') is not allowed2 msPassed
b') is not allowed2 msPassed
create/replace - path property50 msPassed
create/replace/alter table - reserved properties0.33 secPassed
do not double insert on INSERT INTO collect()0.17 secPassed
global temp view should not be masked by v2 catalog74 msPassed
insertInto: append0.12 secPassed
insertInto: append by position0.11 secPassed
insertInto: append partitioned table0.16 secPassed
insertInto: fails when an extra column is present0.1 secPassed
insertInto: fails when missing a column80 msPassed
insertInto: overwrite non-partitioned table0.15 secPassed
insertInto: overwrite partitioned table in dynamic mode0.2 secPassed
insertInto: overwrite partitioned table in dynamic mode by position0.17 secPassed
insertInto: overwrite partitioned table in static mode0.14 secPassed
insertInto: overwrite partitioned table in static mode by position0.16 secPassed
qualified column names for v1 tables1 secPassed
qualified column names for v2 tables0.54 secPassed
table name same as catalog can be used34 msPassed
table()93 msPassed
tableCreation: bucket column name containing dot16 msPassed
tableCreation: bucket column names not in table definition9 msPassed
tableCreation: column repeated in bucket columns17 msPassed
tableCreation: column repeated in partition columns16 msPassed
tableCreation: duplicate column names in the table definition11 msPassed
tableCreation: duplicate nested column names in the table definition10 msPassed
tableCreation: partition column case insensitive resolution40 msPassed
tableCreation: partition column case sensitive resolution7 msPassed