ALTER VIEW AS should alter permanent view if view name has database part | 0.1 sec | Passed |
ALTER VIEW AS should keep the previous table properties, comment, create_time, etc. | 55 ms | Passed |
ALTER VIEW AS should try to alter temp view first if view name has no database part | 0.13 sec | Passed |
CTE within view | 63 ms | Passed |
Issue exceptions for ALTER TABLE on the temporary view | 9 ms | Passed |
Issue exceptions for ALTER VIEW on the temporary view | 7 ms | Passed |
Issue exceptions for other table DDL on the temporary view | 17 ms | Passed |
SPARK-23519 view should be created even when query output contains duplicate col name | 0.18 sec | Passed |
SPARK-32374: disallow setting properties for CREATE TEMPORARY VIEW | 1 ms | Passed |
SPARK-33141: view should be parsed and analyzed with configs set when creating | 1 sec | Passed |
Using view after adding more columns | 0.29 sec | Passed |
Using view after switching current database | 0.21 sec | Passed |
alter temporary view should follow current storeAnalyzedPlanForView config | 0.5 sec | Passed |
correctly handle ALTER VIEW | 0.25 sec | Passed |
correctly handle ALTER VIEW on a referenced view | 0.38 sec | Passed |
correctly handle CREATE OR REPLACE TEMPORARY VIEW | 0.31 sec | Passed |
correctly handle CREATE OR REPLACE VIEW | 0.41 sec | Passed |
correctly handle CREATE VIEW IF NOT EXISTS | 0.28 sec | Passed |
correctly handle a cyclic view reference | 0.11 sec | Passed |
correctly handle a view with custom column names | 0.63 sec | Passed |
correctly parse CREATE TEMPORARY VIEW statement | 0.14 sec | Passed |
correctly parse CREATE VIEW statement | 0.22 sec | Passed |
correctly parse a nested view | 0.35 sec | Passed |
correctly resolve a view in a self join | 0.34 sec | Passed |
create a permanent view on a permanent view | 0.19 sec | Passed |
create a permanent view on a temp view | 55 ms | Passed |
create a temp view on a permanent view | 0.16 sec | Passed |
create a temp view on a temp view | 0.14 sec | Passed |
create view for joined tables | 0.83 sec | Passed |
create view for json table | 0.14 sec | Passed |
create view for partitioned parquet table | 0.29 sec | Passed |
error handling: disallow IF NOT EXISTS for CREATE TEMPORARY VIEW | 2 ms | Passed |
error handling: existing a table with the duplicate name when creating/altering a view | 29 ms | Passed |
error handling: fail if the referenced table or view is invalid | 0.1 sec | Passed |
error handling: fail if the temp view name contains the database prefix | 2 ms | Passed |
error handling: fail if the temp view sql itself is invalid | 16 ms | Passed |
error handling: fail if the view sql itself is invalid | 17 ms | Passed |
error handling: insert/load table commands against a view | 18 ms | Passed |
existing a table with the duplicate name when CREATE VIEW IF NOT EXISTS | 0.16 sec | Passed |
global temp view refers local temp view | 64 ms | Passed |
local temp view refers global temp view | 64 ms | Passed |
permanent view should be case-preserving | 26 ms | Passed |
resolve a view when the dataTypes of referenced table columns changed | 0.64 sec | Passed |
should NOT allow CREATE TEMPORARY VIEW when TEMPORARY VIEW with same name exists | 14 ms | Passed |
should allow CREATE TEMPORARY VIEW when a permanent VIEW with same name exists | 25 ms | Passed |
should allow CREATE permanent VIEW when a TEMPORARY VIEW with same name exists | 24 ms | Passed |
should not allow ALTER VIEW AS when the view does not exist | 3 ms | Passed |
sparkSession API view resolution with different default database | 0.19 sec | Passed |
temporary view should ignore useCurrentSQLConfigsForView config | 0.17 sec | Passed |