Test Result : DataSourceV2SQLSuite

0 failures (±0)
224 tests (+1)
Took 46 sec.

All Tests

Test nameDurationStatus
ALTER TABLE ADD PARTITION27 msPassed
ALTER TABLE DROP PARTITIONS29 msPassed
ALTER TABLE RECOVER PARTITIONS18 msPassed
ALTER TABLE RENAME PARTITION40 msPassed
ALTER TABLE SerDe properties39 msPassed
ALTER VIEW AS QUERY19 msPassed
ANALYZE TABLE41 msPassed
AlterNamespaceSetLocation using v2 catalog0.14 secPassed
AlterNamespaceSetProperties using v2 catalog0.13 secPassed
AlterNamespaceSetProperties: reserved properties0.39 secPassed
AlterTable: SET/DROP NOT NULL46 msPassed
AlterTable: add column - new column should not exist35 msPassed
AlterTable: add column with NOT NULL81 msPassed
AlterTable: add column with comment73 msPassed
AlterTable: add column with interval type25 msPassed
AlterTable: add column with position95 msPassed
AlterTable: add complex column30 msPassed
AlterTable: add multiple columns34 msPassed
AlterTable: add nested column35 msPassed
AlterTable: add nested column parent must exist72 msPassed
AlterTable: add nested column to array element89 msPassed
AlterTable: add nested column to map key41 msPassed
AlterTable: add nested column to map value60 msPassed
AlterTable: add nested column with comment36 msPassed
AlterTable: add top-level column38 msPassed
AlterTable: change rejected by implementation36 msPassed
AlterTable: comment update column must exist92 msPassed
AlterTable: drop column50 msPassed
AlterTable: drop column must exist51 msPassed
AlterTable: drop nested column32 msPassed
AlterTable: drop nested column in array element33 msPassed
AlterTable: drop nested column in map key40 msPassed
AlterTable: drop nested column in map value84 msPassed
AlterTable: nested comment update column must exist22 msPassed
AlterTable: nested drop column must exist20 msPassed
AlterTable: nested rename column must exist22 msPassed
AlterTable: nested update column must exist63 msPassed
AlterTable: remove table property0.16 secPassed
AlterTable: rename column29 msPassed
AlterTable: rename column - new name should not exist23 msPassed
AlterTable: rename column must exist27 msPassed
AlterTable: rename nested column29 msPassed
AlterTable: rename nested column in array element35 msPassed
AlterTable: rename nested column in map key95 msPassed
AlterTable: rename nested column in map value30 msPassed
AlterTable: rename table basic test0.39 secPassed
AlterTable: renaming views are not supported7 msPassed
AlterTable: replace columns46 msPassed
AlterTable: set location57 msPassed
AlterTable: set partition location69 msPassed
AlterTable: set table property36 msPassed
AlterTable: table does not exist23 msPassed
AlterTable: update column array element type0.13 secPassed
AlterTable: update column comment36 msPassed
AlterTable: update column map value type38 msPassed
AlterTable: update column must exist28 msPassed
AlterTable: update column position0.12 secPassed
AlterTable: update column type int -> long38 msPassed
AlterTable: update column type must be compatible31 msPassed
AlterTable: update column type to interval23 msPassed
AlterTable: update column with array type fails69 msPassed
AlterTable: update column with map type fails27 msPassed
AlterTable: update column with struct type fails26 msPassed
AlterTable: update nested column comment64 msPassed
AlterTable: update nested column comment in array33 msPassed
AlterTable: update nested column comment in map key34 msPassed
AlterTable: update nested column comment in map value53 msPassed
AlterTable: update nested type float -> double97 msPassed
AlterTable: update nested type in array0.11 secPassed
AlterTable: update nested type in map key33 msPassed
AlterTable: update nested type in map value36 msPassed
CACHE TABLE35 msPassed
COMMENT ON NAMESPACE0.46 secPassed
COMMENT ON TABLE0.44 secPassed
CREATE FUNCTION: only support session catalog5 msPassed
CREATE VIEW3 msPassed
CTAS/RTAS: invalid schema if has interval type78 msPassed
CreateNameSpace: basic tests0.45 secPassed
CreateNameSpace: reserved properties0.29 secPassed
CreateNameSpace: test handling of 'IF NOT EXIST'51 msPassed
CreateTable/RepalceTable: invalid schema if has interval type69 msPassed
CreateTable: fail if table exists0.14 secPassed
CreateTable: if not exists0.14 secPassed
CreateTable: use default catalog for v2 sources when default catalog is set95 msPassed
CreateTable: use v2 plan and session catalog when provider is v20.11 secPassed
CreateTable: use v2 plan because catalog is set0.12 secPassed
CreateTable: without USING clause26 msPassed
CreateTableAsSelect: do not double execute on collect(), take() and other queries0.49 secPassed
CreateTableAsSelect: fail if table exists0.38 secPassed
CreateTableAsSelect: if not exists0.43 secPassed
CreateTableAsSelect: nullable schema0.53 secPassed
CreateTableAsSelect: use default catalog for v2 sources when default catalog is set0.17 secPassed
CreateTableAsSelect: use v2 plan and session catalog when provider is v20.15 secPassed
CreateTableAsSelect: use v2 plan because catalog is set0.4 secPassed
CreateTableAsSelect: v2 session catalog can load v1 source table0.34 secPassed
CreateTableAsSelect: without USING clause0.2 secPassed
DESCRIBE FUNCTION: only support session catalog3 msPassed
DROP FUNCTION: only support session catalog3 msPassed
DeleteFrom: DELETE is only supported with v2 tables39 msPassed
DeleteFrom: basic - delete all0.3 secPassed
DeleteFrom: basic - delete with where clause0.23 secPassed
DeleteFrom: delete from aliased target table0.24 secPassed
DeleteFrom: fail if has subquery0.21 secPassed
DeleteFrom: normalize attribute names0.21 secPassed
DescribeNamespace using v2 catalog0.16 secPassed
DescribeTable extended using v2 catalog53 msPassed
DescribeTable using v2 catalog0.14 secPassed
DescribeTable with v2 catalog when table does not exist4 msPassed
DropNamespace: basic tests0.28 secPassed
DropNamespace: drop non-empty namespace with a cascade mode0.11 secPassed
DropNamespace: drop non-empty namespace with a non-cascading mode0.34 secPassed
DropNamespace: test handling of 'IF EXISTS'0.24 secPassed
DropTable: basic67 msPassed
DropTable: if exists24 msPassed
DropTable: table qualified with the session catalog name0.26 secPassed
InsertInto: append - across catalog0.2 secPassed
InsertInto: append to partitioned table - static clause0.72 secPassed
InsertInto: dynamic PARTITION clause fails with non-partition column0.32 secPassed
InsertInto: overwrite - dynamic clause - dynamic mode0.56 secPassed
InsertInto: overwrite - dynamic clause - static mode0.8 secPassed
InsertInto: overwrite - implicit dynamic partition - dynamic mode0.24 secPassed
InsertInto: overwrite - implicit dynamic partition - static mode0.3 secPassed
InsertInto: overwrite - missing clause - dynamic mode1.9 secPassed
InsertInto: overwrite - missing clause - static mode0.39 secPassed
InsertInto: overwrite - mixed clause - dynamic mode0.25 secPassed
InsertInto: overwrite - mixed clause - static mode0.23 secPassed
InsertInto: overwrite - mixed clause reordered - dynamic mode0.3 secPassed
InsertInto: overwrite - mixed clause reordered - static mode0.46 secPassed
InsertInto: overwrite - multiple static partitions - dynamic mode0.34 secPassed
InsertInto: overwrite - static clause0.38 secPassed
InsertInto: static PARTITION clause fails with non-partition column0.16 secPassed
InsertInto: when the table doesn't exist66 msPassed
LOAD DATA INTO TABLE37 msPassed
MERGE INTO TABLE0.17 secPassed
MSCK REPAIR TABLE78 msPassed
REFRESH TABLE: v2 table0.1 secPassed
REPLACE TABLE: v1 table5 msPassed
Relation: CTE0.25 secPassed
Relation: basic0.45 secPassed
Relation: join tables in 2 catalogs0.66 secPassed
Relation: view text70 msPassed
ReplaceTable: Erases the table contents and changes the metadata0.18 secPassed
ReplaceTableAsSelect: Atomic catalog does not drop the table when replace fails0.19 secPassed
ReplaceTableAsSelect: CREATE OR REPLACE new table has same behavior as CTAS0.29 secPassed
ReplaceTableAsSelect: Non-atomic catalog drops the table if the write fails78 msPassed
ReplaceTableAsSelect: Non-atomic catalog drops the table permanently if the subsequent table creation fails0.41 secPassed
ReplaceTableAsSelect: REPLACE TABLE throws exception if table does not exist0.25 secPassed
ReplaceTableAsSelect: REPLACE TABLE throws exception if table is dropped before commit0.12 secPassed
ReplaceTableAsSelect: basic v2 implementation0.79 secPassed
ReplaceTableAsSelect: do not double execute CREATE OR REPLACE on collect()0.97 secPassed
ReplaceTableAsSelect: do not double execute REPLACE on collect()0.78 secPassed
SHOW COLUMNS28 msPassed
SHOW CREATE TABLE70 msPassed
SHOW FUNCTIONS not valid v1 namespace3 msPassed
SHOW PARTITIONS52 msPassed
SHOW TABLE EXTENDED not valid v1 database33 msPassed
SHOW TABLE EXTENDED valid v160 msPassed
SHOW TBLPROPERTIES(key): v2 table33 msPassed
SHOW TBLPROPERTIES(key): v2 table, key not found32 msPassed
SHOW TBLPROPERTIES: v2 table0.36 secPassed
SPARK-30001: session catalog name can be specified in SQL statements0.55 secPassed
SPARK-30094: current namespace is used during table resolution0.67 secPassed
SPARK-30104: global temp db is used as a table name under v2 catalog55 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.18 secPassed
SPARK-30259: session catalog can be specified in CREATE TABLE command85 msPassed
SPARK-30284: CREATE VIEW should track the current catalog and namespace0.61 secPassed
SPARK-30799: temp view name can't contain catalog name19 msPassed
SPARK-30814: add column with position referencing new columns being added0.16 secPassed
SPARK-30885: v1 table name should be fully qualified0.65 secPassed
SPARK-31015: star expression should work for qualified column names for v2 tables1.1 secPassed
ShowCurrentNamespace: basic tests1 secPassed
ShowNamespaces: change catalog and namespace with USE statements0.65 secPassed
ShowNamespaces: default v2 catalog doesn't support namespace17 msPassed
ShowNamespaces: default v2 catalog is not set0.27 secPassed
ShowNamespaces: session catalog is used and namespace doesn't exist13 msPassed
ShowNamespaces: show namespaces with v2 catalog0.25 secPassed
ShowNamespaces: show root namespaces with default v2 catalog0.14 secPassed
ShowNamespaces: v2 catalog doesn't support namespace15 msPassed
ShowTables: change current catalog and namespace with USE statements0.11 secPassed
ShowTables: namespace is not specified and default v2 catalog is set37 msPassed
ShowTables: namespace not specified and default v2 catalog not set - fallback to v137 msPassed
ShowTables: using v1 catalog59 msPassed
ShowTables: using v1 catalog, db doesn't exist12 msPassed
ShowTables: using v2 catalog0.48 secPassed
ShowTables: using v2 catalog with a pattern0.12 secPassed
ShowTables: using v2 catalog with empty namespace0.51 secPassed
ShowTables: using v2 catalog, namespace doesn't exist25 msPassed
ShowViews: using v2 catalog, command not supported9 msPassed
TRUNCATE TABLE72 msPassed
UNCACHE TABLE31 msPassed
UPDATE TABLE0.14 secPassed
Use: basic tests with USE statements0.41 secPassed
Use: set v2 catalog as a current catalog9 msPassed
Use: v2 catalog is used and namespace does not exist10 msPassed
Use: v2 session catalog is used and namespace does not exist1 secPassed
b') is not allowed10 msPassed
b') is not allowed2 msPassed
create/replace - path property0.11 secPassed
create/replace/alter table - reserved properties0.77 secPassed
do not double insert on INSERT INTO collect()0.33 secPassed
global temp view should not be masked by v2 catalog0.16 secPassed
insertInto: append0.39 secPassed
insertInto: append by position0.19 secPassed
insertInto: append partitioned table0.19 secPassed
insertInto: fails when an extra column is present0.24 secPassed
insertInto: fails when missing a column0.15 secPassed
insertInto: overwrite non-partitioned table0.4 secPassed
insertInto: overwrite partitioned table in dynamic mode0.55 secPassed
insertInto: overwrite partitioned table in dynamic mode by position0.3 secPassed
insertInto: overwrite partitioned table in static mode0.44 secPassed
insertInto: overwrite partitioned table in static mode by position0.48 secPassed
qualified column names for v1 tables2.1 secPassed
qualified column names for v2 tables1 secPassed
table name same as catalog can be used0.1 secPassed
table()0.23 secPassed
tableCreation: bucket column name containing dot75 msPassed
tableCreation: bucket column names not in table definition15 msPassed
tableCreation: column repeated in bucket columns64 msPassed
tableCreation: column repeated in partition columns64 msPassed
tableCreation: duplicate column names in the table definition0.21 secPassed
tableCreation: duplicate nested column names in the table definition26 msPassed
tableCreation: partition column case insensitive resolution1.2 secPassed
tableCreation: partition column case sensitive resolution14 msPassed