Repository: impala Updated Branches: refs/heads/2.x bbe534298 -> 867fc82b8
http://git-wip-us.apache.org/repos/asf/impala/blob/867fc82b/testdata/workloads/functional-query/queries/QueryTest/kudu_create.test ---------------------------------------------------------------------- diff --git a/testdata/workloads/functional-query/queries/QueryTest/kudu_create.test b/testdata/workloads/functional-query/queries/QueryTest/kudu_create.test index 204fc68..394157c 100644 --- a/testdata/workloads/functional-query/queries/QueryTest/kudu_create.test +++ b/testdata/workloads/functional-query/queries/QueryTest/kudu_create.test @@ -84,6 +84,7 @@ create table tab (a int not null primary key) partition by range (a) (partition value = false) stored as kudu ---- RESULTS +'Table has been created.' ==== ---- QUERY # Invalid hostname @@ -107,6 +108,7 @@ Couldn't resolve this master's address bogus.host.name:7051 create table tdata_master_addresses_whitespace (id int primary key) stored as kudu tblproperties('kudu.master_addresses' = ' localhost ') ---- RESULTS +'Table has been created.' ==== ---- QUERY insert into tdata_master_addresses_whitespace values (0), (1) @@ -120,6 +122,7 @@ create table ignore_column_case (Id int, NAME string, vAlf float, vali bigint, primary key (Id, NAME)) PARTITION BY RANGE (PARTITION VALUE = (1, 'Martin')) STORED AS KUDU ---- RESULTS +'Table has been created.' ==== ---- QUERY insert into ignore_column_case values (1, 'Martin', 1.0, 10); @@ -145,6 +148,7 @@ create table tbl_with_null_defaults (x int primary key, i1 tinyint default null, valdec8 decimal(18) default null, valdec16 decimal(38) default null) partition by hash (x) partitions 3 stored as kudu ---- RESULTS +'Table has been created.' ==== ---- QUERY insert into tbl_with_null_defaults (x) values (1); @@ -181,6 +185,7 @@ partition by range ( partition '2009-01-03 00:00:00' <= VALUES ) stored as kudu ---- RESULTS +'Table has been created.' ==== ---- QUERY show range partitions ts_ranges @@ -236,6 +241,7 @@ create table ts_default (i int primary key, ts1 timestamp, ts2 timestamp default cast('2009-01-01 00:00:00' as timestamp)) partition by hash(i) partitions 3 stored as kudu ---- RESULTS +'Table has been created.' ==== ---- QUERY insert into ts_default (i) values (1); @@ -267,6 +273,7 @@ INT,TIMESTAMP,TIMESTAMP create table unpartitioned_kudu_table (col0 bigint primary key, col1 string) stored as kudu ---- RESULTS +'Table has been created.' ---- ERRORS Unpartitioned Kudu tables are inefficient for large data sizes. ==== @@ -312,6 +319,7 @@ create table create_decimal primary key (decimal_4)) stored as kudu; ---- RESULTS +'Table has been created.' ==== ---- QUERY # Create as select table with decimal columns and primary key @@ -327,4 +335,4 @@ select * from ctas_decimal; 132842,333,12345.6789000000,0.12345678900000000000000000000000000000,0.77889,1 ---- TYPES DECIMAL,DECIMAL,DECIMAL,DECIMAL,DECIMAL,DECIMAL -==== \ No newline at end of file +==== http://git-wip-us.apache.org/repos/asf/impala/blob/867fc82b/testdata/workloads/functional-query/queries/QueryTest/kudu_delete.test ---------------------------------------------------------------------- diff --git a/testdata/workloads/functional-query/queries/QueryTest/kudu_delete.test b/testdata/workloads/functional-query/queries/QueryTest/kudu_delete.test index 3abcdab..9fd7f32 100644 --- a/testdata/workloads/functional-query/queries/QueryTest/kudu_delete.test +++ b/testdata/workloads/functional-query/queries/QueryTest/kudu_delete.test @@ -8,6 +8,7 @@ create table tdata PARTITION BY RANGE (PARTITION VALUES < 100, PARTITION 100 <= VALUES < 1000, PARTITION 1000 <= VALUES <= 10000) STORED AS KUDU ---- RESULTS +'Table has been created.' ==== ---- QUERY insert into table tdata values @@ -385,6 +386,7 @@ STRING,BIGINT,TINYINT,SMALLINT,BOOLEAN,INT,DOUBLE,FLOAT create table impala_3454 (key_1 tinyint, key_2 bigint, PRIMARY KEY (key_1, key_2)) PARTITION BY HASH PARTITIONS 3 STORED AS KUDU ---- RESULTS +'Table has been created.' ==== ---- QUERY insert into impala_3454 values http://git-wip-us.apache.org/repos/asf/impala/blob/867fc82b/testdata/workloads/functional-query/queries/QueryTest/kudu_insert.test ---------------------------------------------------------------------- diff --git a/testdata/workloads/functional-query/queries/QueryTest/kudu_insert.test b/testdata/workloads/functional-query/queries/QueryTest/kudu_insert.test index 6bba77a..da1bfac 100644 --- a/testdata/workloads/functional-query/queries/QueryTest/kudu_insert.test +++ b/testdata/workloads/functional-query/queries/QueryTest/kudu_insert.test @@ -8,6 +8,7 @@ create table tdata PARTITION BY RANGE (PARTITION VALUES < 10, PARTITION 10 <= VALUES < 30, PARTITION 30 <= VALUES) STORED AS KUDU ---- RESULTS +'Table has been created.' ==== ---- QUERY # VALUES, single row, all target cols, no errors @@ -295,6 +296,7 @@ create table allkeytypes (i1 tinyint, i2 smallint, i3 int, i4 bigint, name strin partition value = (2,2,2,2,'2','2009-01-01 00:02:00.100000000'), partition value = (3,3,3,3,'3','2009-01-01 00:03:00.300000000')) stored as kudu ---- RESULTS +'Table has been created.' ==== ---- QUERY insert into allkeytypes select cast(id as tinyint), smallint_col, int_col, @@ -325,6 +327,7 @@ create table tbl_with_defaults (a int primary key, b int null default 10, i decimal(9, 2) default 1111.11) partition by hash (a) partitions 3 stored as kudu ---- RESULTS +'Table has been created.' ==== ---- QUERY insert into tbl_with_defaults (a, f) values (1, 1), (2, 2), (3, 3), (4, 4) @@ -360,6 +363,7 @@ INT,INT,INT,INT,INT,INT,STRING,BOOLEAN,DECIMAL ---- QUERY alter table tbl_with_defaults add columns (j int null, k int not null default 10000) ---- RESULTS +'Column has been added/replaced.' ==== ---- QUERY select * from tbl_with_defaults @@ -421,6 +425,7 @@ INT,INT,INT,INT,INT,INT,STRING,BOOLEAN,DECIMAL,INT,INT create table multiple_partition_cols (x bigint, y bigint, z string, primary key(x, y)) partition by hash(x, y) partitions 8 stored as kudu ---- RESULTS +'Table has been created.' ==== ---- QUERY # SELECT with constant http://git-wip-us.apache.org/repos/asf/impala/blob/867fc82b/testdata/workloads/functional-query/queries/QueryTest/kudu_partition_ddl.test ---------------------------------------------------------------------- diff --git a/testdata/workloads/functional-query/queries/QueryTest/kudu_partition_ddl.test b/testdata/workloads/functional-query/queries/QueryTest/kudu_partition_ddl.test index 96cbc14..17d365b 100644 --- a/testdata/workloads/functional-query/queries/QueryTest/kudu_partition_ddl.test +++ b/testdata/workloads/functional-query/queries/QueryTest/kudu_partition_ddl.test @@ -5,6 +5,7 @@ create table simple_hash (id int, name string, valf float, vali bigint, primary key (id, name)) partition by hash(id) partitions 4, hash(name) partitions 2 stored as kudu ---- RESULTS +'Table has been created.' ==== ---- QUERY show table stats simple_hash @@ -29,6 +30,7 @@ create table range_part_bounds (id int, name string, valf float, vali bigint, (partition values <= 10, partition 10 < values <= 20, partition 20 < values) stored as kudu ---- RESULTS +'Table has been created.' ==== ---- QUERY show table stats range_part_bounds @@ -48,6 +50,7 @@ create table range_part_single (id int, name string, valf float, vali bigint, (partition value = 1, partition value = 10, partition value = 100) stored as kudu ---- RESULTS +'Table has been created.' ==== ---- QUERY show table stats range_part_single @@ -68,6 +71,7 @@ create table range_part_multiple_bounds (id int, name string, valf float, (partition values <= 10, partition 10 < values <= 20, partition 20 < values <= 30, partition value = 40, partition value = 50) stored as kudu ---- RESULTS +'Table has been created.' ==== ---- QUERY show table stats range_part_multiple_bounds @@ -89,6 +93,7 @@ create table range_part_multiple_cols (id int, name string, valf float, vali big (partition value = (10, 'martin'), partition value = (20, 'dimitris'), partition value = (30, 'matthew')) stored as kudu ---- RESULTS +'Table has been created.' ==== ---- QUERY -- Test printing of multiple column range partitioning @@ -116,6 +121,7 @@ create table range_part_single_string_col (id int, name string, valf float, (partition values <= 'aaa', partition 'aaa' < values <= 'bbb', partition 'bbb' < values <= 'ccc', partition value = 'ddd') stored as kudu ---- RESULTS +'Table has been created.' ==== ---- QUERY show table stats range_part_single_string_col @@ -135,6 +141,7 @@ create table simple_hash_range (id int, name string, valf float, vali bigint, primary key (id, name)) partition by hash(id) partitions 4, range(id, name) (partition value = (10, 'martin'), partition value = (20, 'alex')) stored as kudu ---- RESULTS +'Table has been created.' ==== ---- QUERY show table stats simple_hash_range @@ -182,6 +189,7 @@ INT,STRING,STRING,STRING,INT create table simple_hash_all_columns (id int, name string, valf float, vali bigint, primary key (id, name)) partition by hash partitions 4 stored as kudu ---- RESULTS +'Table has been created.' ==== ---- QUERY show table stats simple_hash_all_columns @@ -202,6 +210,7 @@ create table simple_range_all_columns (id int, name string, valf float, vali big (partition value = (1, 'a'), partition value = (2, 'b')) stored as kudu ---- RESULTS +'Table has been created.' ==== ---- QUERY show table stats simple_range_all_columns @@ -220,6 +229,7 @@ create table range_complex_const_boundary_vals (x int, y int, primary key (x)) partition factorial(4) < values < factorial(5), partition value = factorial(6)) stored as kudu ---- RESULTS +'Table has been created.' ==== ---- QUERY show table stats range_complex_const_boundary_vals http://git-wip-us.apache.org/repos/asf/impala/blob/867fc82b/testdata/workloads/functional-query/queries/QueryTest/kudu_stats.test ---------------------------------------------------------------------- diff --git a/testdata/workloads/functional-query/queries/QueryTest/kudu_stats.test b/testdata/workloads/functional-query/queries/QueryTest/kudu_stats.test index 697a3a3..23a43b5 100644 --- a/testdata/workloads/functional-query/queries/QueryTest/kudu_stats.test +++ b/testdata/workloads/functional-query/queries/QueryTest/kudu_stats.test @@ -4,6 +4,7 @@ create table simple (id int primary key, name string, valf float, vali bigint) partition by range (partition values < 10, partition 10 <= values < 30, partition 30 <= values) stored as kudu tblproperties('kudu.num_tablet_replicas' = '1') ---- RESULTS +'Table has been created.' ==== ---- QUERY show table stats simple http://git-wip-us.apache.org/repos/asf/impala/blob/867fc82b/testdata/workloads/functional-query/queries/QueryTest/kudu_update.test ---------------------------------------------------------------------- diff --git a/testdata/workloads/functional-query/queries/QueryTest/kudu_update.test b/testdata/workloads/functional-query/queries/QueryTest/kudu_update.test index 8520677..8b7759b 100644 --- a/testdata/workloads/functional-query/queries/QueryTest/kudu_update.test +++ b/testdata/workloads/functional-query/queries/QueryTest/kudu_update.test @@ -8,6 +8,7 @@ create table tdata PARTITION BY RANGE (PARTITION VALUES < 10, PARTITION 10 <= VALUES < 30, PARTITION 30 <= VALUES <= 10000) STORED AS KUDU ---- RESULTS +'Table has been created.' ==== ---- QUERY insert into tdata values http://git-wip-us.apache.org/repos/asf/impala/blob/867fc82b/testdata/workloads/functional-query/queries/QueryTest/kudu_upsert.test ---------------------------------------------------------------------- diff --git a/testdata/workloads/functional-query/queries/QueryTest/kudu_upsert.test b/testdata/workloads/functional-query/queries/QueryTest/kudu_upsert.test index 1c12f33..5cdfef2 100644 --- a/testdata/workloads/functional-query/queries/QueryTest/kudu_upsert.test +++ b/testdata/workloads/functional-query/queries/QueryTest/kudu_upsert.test @@ -7,6 +7,7 @@ create table tdata PARTITION BY RANGE (PARTITION VALUES < 10, PARTITION 10 <= VALUES < 30, PARTITION 30 <= VALUES) STORED AS KUDU ---- RESULTS +'Table has been created.' ==== ---- QUERY insert into table tdata values http://git-wip-us.apache.org/repos/asf/impala/blob/867fc82b/testdata/workloads/functional-query/queries/QueryTest/libs_with_same_filenames.test ---------------------------------------------------------------------- diff --git a/testdata/workloads/functional-query/queries/QueryTest/libs_with_same_filenames.test b/testdata/workloads/functional-query/queries/QueryTest/libs_with_same_filenames.test index 64fdced..71ab444 100644 --- a/testdata/workloads/functional-query/queries/QueryTest/libs_with_same_filenames.test +++ b/testdata/workloads/functional-query/queries/QueryTest/libs_with_same_filenames.test @@ -6,6 +6,7 @@ location '$FILESYSTEM_PREFIX/test-warehouse/libTestUdfs.so' symbol='NoArgs'; create function no_args2() returns string location '$FILESYSTEM_PREFIX/test-warehouse/udf_test/libTestUdfs.so' symbol='NoArgs'; ---- RESULTS +'Function has been created.' ==== ---- QUERY select no_args(); http://git-wip-us.apache.org/repos/asf/impala/blob/867fc82b/testdata/workloads/functional-query/queries/QueryTest/load.test ---------------------------------------------------------------------- diff --git a/testdata/workloads/functional-query/queries/QueryTest/load.test b/testdata/workloads/functional-query/queries/QueryTest/load.test index 060868f..4528380 100644 --- a/testdata/workloads/functional-query/queries/QueryTest/load.test +++ b/testdata/workloads/functional-query/queries/QueryTest/load.test @@ -3,11 +3,13 @@ alter table functional.test_load add partition (year=2009, month=1) ---- RESULTS +'New partition has been added to the table.' ==== ---- QUERY alter table functional.test_load add partition (year=2010, month=1) ---- RESULTS +'New partition has been added to the table.' ==== ---- QUERY # Insert some data into one of the partitions, used to verify we are not clobbering http://git-wip-us.apache.org/repos/asf/impala/blob/867fc82b/testdata/workloads/functional-query/queries/QueryTest/local-filesystem.test ---------------------------------------------------------------------- diff --git a/testdata/workloads/functional-query/queries/QueryTest/local-filesystem.test b/testdata/workloads/functional-query/queries/QueryTest/local-filesystem.test index 50e2666..1239eea 100644 --- a/testdata/workloads/functional-query/queries/QueryTest/local-filesystem.test +++ b/testdata/workloads/functional-query/queries/QueryTest/local-filesystem.test @@ -5,6 +5,7 @@ create external table tbl row format delimited fields terminated by ',' location 'file://$IMPALA_HOME/testdata/data/local_tbl' ---- RESULTS +'Table has been created.' ==== ---- QUERY describe tbl http://git-wip-us.apache.org/repos/asf/impala/blob/867fc82b/testdata/workloads/functional-query/queries/QueryTest/partition-ddl-predicates-all-fs.test ---------------------------------------------------------------------- diff --git a/testdata/workloads/functional-query/queries/QueryTest/partition-ddl-predicates-all-fs.test b/testdata/workloads/functional-query/queries/QueryTest/partition-ddl-predicates-all-fs.test index f90dcff..ea4fb0d 100644 --- a/testdata/workloads/functional-query/queries/QueryTest/partition-ddl-predicates-all-fs.test +++ b/testdata/workloads/functional-query/queries/QueryTest/partition-ddl-predicates-all-fs.test @@ -157,7 +157,7 @@ STRING, STRING, BIGINT, BIGINT, STRING, STRING, STRING, STRING, STRING, STRING # Tests no matching partition. alter table p1 partition (j=100) set location '$FILESYSTEM_PREFIX/test-warehouse/newtable'; ---- RESULTS -# TODO: IMPALA-6775 +'New location has been set.' ==== QUERY # Check nothing was updated. show partitions p1 @@ -204,4 +204,4 @@ alter table p1 partition (j=100) set row format delimited fields terminated by ' 'Updated 0 partition(s).' ---- TYPES STRING -==== \ No newline at end of file +==== http://git-wip-us.apache.org/repos/asf/impala/blob/867fc82b/testdata/workloads/functional-query/queries/QueryTest/test-unmatched-schema.test ---------------------------------------------------------------------- diff --git a/testdata/workloads/functional-query/queries/QueryTest/test-unmatched-schema.test b/testdata/workloads/functional-query/queries/QueryTest/test-unmatched-schema.test index 926c5bf..4605458 100644 --- a/testdata/workloads/functional-query/queries/QueryTest/test-unmatched-schema.test +++ b/testdata/workloads/functional-query/queries/QueryTest/test-unmatched-schema.test @@ -29,6 +29,7 @@ BIGINT, STRING, INT, INT ---- QUERY alter table jointbl_test add columns(new_col string) ---- RESULTS +'New column(s) have been added to the table.' ==== ---- QUERY select * from jointbl_test @@ -58,6 +59,7 @@ BIGINT, STRING, INT, INT, STRING ---- QUERY alter table jointbl_test add columns(new_int_col int) ---- RESULTS +'New column(s) have been added to the table.' ==== ---- QUERY select * from jointbl_test @@ -87,6 +89,7 @@ BIGINT, STRING, INT, INT, STRING, INT ---- QUERY alter table jointbl_test drop column new_int_col ---- RESULTS +'Column has been dropped.' ==== ---- QUERY select * from jointbl_test @@ -116,10 +119,12 @@ BIGINT, STRING, INT, INT, STRING ---- QUERY alter table jointbl_test drop column new_col ---- RESULTS +'Column has been dropped.' ==== ---- QUERY alter table jointbl_test drop column alltypes_id ---- RESULTS +'Column has been dropped.' ==== ---- QUERY select * from jointbl_test http://git-wip-us.apache.org/repos/asf/impala/blob/867fc82b/testdata/workloads/functional-query/queries/QueryTest/truncate-table.test ---------------------------------------------------------------------- diff --git a/testdata/workloads/functional-query/queries/QueryTest/truncate-table.test b/testdata/workloads/functional-query/queries/QueryTest/truncate-table.test index 6bfa21c..a8d2a80 100644 --- a/testdata/workloads/functional-query/queries/QueryTest/truncate-table.test +++ b/testdata/workloads/functional-query/queries/QueryTest/truncate-table.test @@ -166,6 +166,7 @@ STRING, STRING, BIGINT, BIGINT, BIGINT, DOUBLE # TRUNCATE IF EXISTS does not fail on non existent table truncate table if exists non_existent; ---- RESULTS +'Table does not exist.' ==== ---- QUERY # Create an unpartitioned table. @@ -182,6 +183,7 @@ BIGINT # TRUNCATE IF EXISTS base scenario truncate table if exists t3; ---- RESULTS +'Table has been truncated.' ==== ---- QUERY # Verify that truncate was successful http://git-wip-us.apache.org/repos/asf/impala/blob/867fc82b/testdata/workloads/functional-query/queries/QueryTest/udf-errors.test ---------------------------------------------------------------------- diff --git a/testdata/workloads/functional-query/queries/QueryTest/udf-errors.test b/testdata/workloads/functional-query/queries/QueryTest/udf-errors.test index fb91070..252d85c 100644 --- a/testdata/workloads/functional-query/queries/QueryTest/udf-errors.test +++ b/testdata/workloads/functional-query/queries/QueryTest/udf-errors.test @@ -4,6 +4,7 @@ create function if not exists hive_pi() returns double location '$FILESYSTEM_PREFIX/test-warehouse/hive-exec.jar' symbol='org.apache.hadoop.hive.ql.udf.UDFPI'; ---- RESULTS +'Function has been created.' ==== ---- QUERY create function if not exists foo() returns double @@ -33,6 +34,7 @@ create function if not exists twenty_args(int, int, int, int, int, int, location '$FILESYSTEM_PREFIX/test-warehouse/libTestUdfs.so' symbol='TwentyArgs'; ---- RESULTS +'Function has been created.' ==== ---- QUERY # Verifies that interpretation can support up to 20 arguments @@ -49,6 +51,7 @@ create function if not exists twenty_one_args(int, int, int, int, int, int, location '$FILESYSTEM_PREFIX/test-warehouse/libTestUdfs.so' symbol='TwentyOneArgs'; ---- RESULTS +'Function has been created.' ==== ---- QUERY # Verifies that interpretation fails with more than 20 arguments. @@ -63,6 +66,7 @@ create function if not exists nine_args_ir(int, int, int, int, int, int, location '$FILESYSTEM_PREFIX/test-warehouse/test-udfs.ll' symbol='NineArgs'; ---- RESULTS +'Function has been created.' ==== ---- QUERY select nine_args_ir(1,2,3,4,5,6,7,8,9); @@ -74,12 +78,14 @@ create function if not exists bad_expr(double) returns boolean location '$FILESYSTEM_PREFIX/test-warehouse/libTestUdfs.so' symbol='BadExpr' prepare_fn='BadExprPrepare' close_fn='BadExprClose'; ---- RESULTS +'Function has been created.' ==== ---- QUERY create function if not exists bad_expr2(double) returns boolean location '$FILESYSTEM_PREFIX/test-warehouse/libTestUdfs.so' symbol='BadExpr' prepare_fn='BadExpr2Prepare' close_fn='BadExprClose'; ---- RESULTS +'Function has been created.' ==== ---- QUERY select count(t1.int_col) from functional.alltypes t1 join functional.alltypes t2 @@ -120,4 +126,5 @@ drop function nine_args_ir(int, int, int, int, int, int, int, int, int); drop function bad_expr(double); drop function bad_expr2(double); ---- RESULTS +'Function has been dropped.' ==== http://git-wip-us.apache.org/repos/asf/impala/blob/867fc82b/testdata/workloads/functional-query/queries/QueryTest/views-ddl.test ---------------------------------------------------------------------- diff --git a/testdata/workloads/functional-query/queries/QueryTest/views-ddl.test b/testdata/workloads/functional-query/queries/QueryTest/views-ddl.test index 98f116f..0461222 100644 --- a/testdata/workloads/functional-query/queries/QueryTest/views-ddl.test +++ b/testdata/workloads/functional-query/queries/QueryTest/views-ddl.test @@ -4,12 +4,14 @@ create view $DATABASE.simple_view as select * from functional.alltypes ---- RESULTS +'View has been created.' ==== ---- QUERY # Test that 'if not exists' swallows the error (view already exists) create view if not exists $DATABASE.simple_view as select * from functional.alltypesagg ---- RESULTS +'View already exists.' ==== ---- QUERY # Create another simple view with 'if not exists' on a subset of @@ -18,12 +20,14 @@ create view if not exists $DATABASE.simple_view_sub (x, y comment 'hello', z) as select int_col, string_col, timestamp_col from functional.alltypes ---- RESULTS +'View has been created.' ==== ---- QUERY # Create a view on a parquet table (Hive cannot create/read/write parquet) create view $DATABASE.parquet_view as select * from functional_parquet.alltypes where id < 20 ---- RESULTS +'View has been created.' ==== ---- QUERY # Create a complex view with predicates, joins, aggregates and order by @@ -34,12 +38,14 @@ on a.id = b.id where a.bigint_col < 50 group by b.string_col having count(a.bigint_col) > 1 order by b.string_col limit 100 ---- RESULTS +'View has been created.' ==== ---- QUERY # Create a view on a view create view $DATABASE.view_view (aaa, bbb) as select * from $DATABASE.complex_view ---- RESULTS +'View has been created.' ==== ---- QUERY # Test that the views are displayed by 'show tables' @@ -155,6 +161,7 @@ bigint # Test dropping a view drop view $DATABASE.simple_view_sub ---- RESULTS +'View has been dropped.' ==== ---- QUERY # Test that the view is gone @@ -169,15 +176,18 @@ show tables in $DATABASE # Test 'if exists' for dropping a view (view does not exist) drop view if exists $DATABASE.bad_view ---- RESULTS +'View does not exist.' ==== ---- QUERY # Test 'if exists' does not drop a table with same name create table $DATABASE.drop_tbl_test(a int) ---- RESULTS +'Table has been created.' ==== ---- QUERY drop view if exists $DATABASE.drop_tbl_test ---- RESULTS +'Drop view is not allowed on a table.' ==== ---- QUERY # Test drop table 'if exists' does not drop a view with same name. @@ -185,6 +195,7 @@ drop view if exists $DATABASE.drop_tbl_test # still be listed in the subsequent show tables output (as a view). drop table if exists $DATABASE.complex_view ---- RESULTS +'Drop table is not allowed on a view.' ==== ---- QUERY # Test that the table is present @@ -200,11 +211,13 @@ show tables in $DATABASE # Test renaming a view alter view $DATABASE.view_view rename to $DATABASE.view_on_view ---- RESULTS +'Renaming was successful.' ==== ---- QUERY # Test renaming a parquet view alter view $DATABASE.parquet_view rename to $DATABASE.new_parquet_view ---- RESULTS +'Renaming was successful.' ==== ---- QUERY # Test that the view was renamed @@ -222,6 +235,7 @@ alter view $DATABASE.new_parquet_view as select bigint_col, string_col from functional_parquet.alltypesagg where bigint_col is null limit 10 ---- RESULTS +'View has been altered.' ==== ---- QUERY # Test querying the altered view @@ -236,6 +250,7 @@ bigint,bigint create view $DATABASE.const_view as select 1, 'a', cast(10.0 as float) ---- RESULTS +'View has been created.' ==== ---- QUERY select * from $DATABASE.const_view @@ -251,6 +266,7 @@ create view $DATABASE.paren_view as select count(*) from functional.alltypessmall where true and (true or false) and false ---- RESULTS +'View has been created.' ==== ---- QUERY # Test that parentheses are preserved in view creation. @@ -265,6 +281,7 @@ bigint create view $DATABASE.decimal_view as select * from functional.decimal_tbl ---- RESULTS +'View has been created.' ==== ---- QUERY # Query a view with decimal columns. Regression test for IMPALA-1021.