Test Result : HiveSQLViewSuite

0 failures
51 tests
Took 28 sec.

All Tests

Test nameDurationStatus
ALTER VIEW AS should alter permanent view if view name has database part0.2 secPassed
ALTER VIEW AS should keep the previous table properties, comment, create_time, etc0.15 secPassed
ALTER VIEW AS should try to alter temp view first if view name has no database part0.21 secPassed
CTE within view0.14 secPassed
Issue exceptions for ALTER TABLE on the temporary view54 msPassed
Issue exceptions for ALTER VIEW on the temporary view28 msPassed
Issue exceptions for other table DDL on the temporary view41 msPassed
SPARK-14933 - create view from hive orc table0.55 secPassed
SPARK-14933 - create view from hive parquet table0.55 secPassed
SPARK-23519 view should be created even when query output contains duplicate col name0.46 secPassed
SPARK-34260: replace existing view using CREATE OR REPLACE0.23 secPassed
SPARK-34719: view query with duplicated output column names1.6 secPassed
Using view after adding more columns0.75 secPassed
Using view after switching current database0.7 secPassed
correctly handle ALTER VIEW0.8 secPassed
correctly handle ALTER VIEW on a referenced view1.2 secPassed
correctly handle CREATE OR REPLACE TEMPORARY VIEW0.9 secPassed
correctly handle CREATE OR REPLACE VIEW1.4 secPassed
correctly handle CREATE VIEW IF NOT EXISTS0.88 secPassed
correctly handle a cyclic view reference0.47 secPassed
correctly handle a view with custom column names1.7 secPassed
correctly parse CREATE TEMPORARY VIEW statement0.51 secPassed
correctly parse CREATE VIEW statement0.58 secPassed
correctly parse a nested view1.2 secPassed
correctly resolve a view in a self join0.66 secPassed
create a permanent view on a permanent view0.36 secPassed
create a permanent view on a temp view52 msPassed
create a permanent/temp view using a hive, built-in, and permanent user function0.92 secPassed
create a permanent/temp view using a temporary function0.46 secPassed
create a temp view on a permanent view0.26 secPassed
create a temp view on a temp view0.17 secPassed
create view for joined tables1.9 secPassed
create view for json table0.49 secPassed
create view for partitioned parquet table0.83 secPassed
error handling: disallow IF NOT EXISTS for CREATE TEMPORARY VIEW2 msPassed
error handling: existing a table with the duplicate name when creating/altering a view0.22 secPassed
error handling: fail if the referenced table or view is invalid0.7 secPassed
error handling: fail if the temp view name contains the database prefix2 msPassed
error handling: fail if the temp view sql itself is invalid33 msPassed
error handling: fail if the view sql itself is invalid29 msPassed
error handling: insert/load/truncate table commands against a view89 msPassed
existing a table with the duplicate name when CREATE VIEW IF NOT EXISTS0.24 secPassed
make sure we can resolve view created by old version of Spark0.74 secPassed
permanent view should be case-preserving0.19 secPassed
resolve a view when the dataTypes of referenced table columns changed1.7 secPassed
restrict the nested level of a view1.6 secPassed
should NOT allow CREATE TEMPORARY VIEW when TEMPORARY VIEW with same name exists27 msPassed
should allow CREATE TEMPORARY VIEW when a permanent VIEW with same name exists98 msPassed
should allow CREATE permanent VIEW when a TEMPORARY VIEW with same name exists99 msPassed
should not allow ALTER VIEW AS when the view does not exist11 msPassed
sparkSession API view resolution with different default database0.53 secPassed