http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/subquery_exists_implicit_gby.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/subquery_exists_implicit_gby.q b/ql/src/test/queries/clientnegative/subquery_exists_implicit_gby.q index 497f3c2..6650dc2 100644 --- a/ql/src/test/queries/clientnegative/subquery_exists_implicit_gby.q +++ b/ql/src/test/queries/clientnegative/subquery_exists_implicit_gby.q @@ -1,3 +1,4 @@ +--! qt:dataset:src select *
http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/subquery_in_groupby.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/subquery_in_groupby.q b/ql/src/test/queries/clientnegative/subquery_in_groupby.q index a9bc6ee..74e9a07 100644 --- a/ql/src/test/queries/clientnegative/subquery_in_groupby.q +++ b/ql/src/test/queries/clientnegative/subquery_in_groupby.q @@ -1,3 +1,4 @@ +--! qt:dataset:src select count(*) http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/subquery_in_lhs.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/subquery_in_lhs.q b/ql/src/test/queries/clientnegative/subquery_in_lhs.q index 087c3f3..e24de1e 100644 --- a/ql/src/test/queries/clientnegative/subquery_in_lhs.q +++ b/ql/src/test/queries/clientnegative/subquery_in_lhs.q @@ -1,2 +1,3 @@ +--! qt:dataset:part select * from part where (select max(p_size) from part) IN (select p_size from part); \ No newline at end of file http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/subquery_in_on.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/subquery_in_on.q b/ql/src/test/queries/clientnegative/subquery_in_on.q index 5f44f72..fb30d44 100644 --- a/ql/src/test/queries/clientnegative/subquery_in_on.q +++ b/ql/src/test/queries/clientnegative/subquery_in_on.q @@ -1,3 +1,4 @@ +--! qt:dataset:part -- subquery in ON clause explain SELECT p1.p_name FROM part p1 LEFT JOIN (select p_type as p_col from part ) p2 ON (select pp1.p_type as p_col from part pp1 where pp1.p_partkey = p2.p_col); \ No newline at end of file http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/subquery_multiple_cols_in_select.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/subquery_multiple_cols_in_select.q b/ql/src/test/queries/clientnegative/subquery_multiple_cols_in_select.q index 6805c5b..c7a53e0 100644 --- a/ql/src/test/queries/clientnegative/subquery_multiple_cols_in_select.q +++ b/ql/src/test/queries/clientnegative/subquery_multiple_cols_in_select.q @@ -1,3 +1,4 @@ +--! qt:dataset:src explain http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/subquery_notexists_implicit_gby.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/subquery_notexists_implicit_gby.q b/ql/src/test/queries/clientnegative/subquery_notexists_implicit_gby.q index 57c72d2..63847bf 100644 --- a/ql/src/test/queries/clientnegative/subquery_notexists_implicit_gby.q +++ b/ql/src/test/queries/clientnegative/subquery_notexists_implicit_gby.q @@ -1,3 +1,4 @@ +--! qt:dataset:src select * http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/subquery_scalar_corr_multi_rows.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/subquery_scalar_corr_multi_rows.q b/ql/src/test/queries/clientnegative/subquery_scalar_corr_multi_rows.q index e71a60d..47fb513 100644 --- a/ql/src/test/queries/clientnegative/subquery_scalar_corr_multi_rows.q +++ b/ql/src/test/queries/clientnegative/subquery_scalar_corr_multi_rows.q @@ -1,3 +1,4 @@ +--! qt:dataset:part -- inner query produces more than one row select * from part where p_size > (select count(*) from part p where p.p_mfgr = part.p_mfgr group by p_type); \ No newline at end of file http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/subquery_scalar_multi_columns.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/subquery_scalar_multi_columns.q b/ql/src/test/queries/clientnegative/subquery_scalar_multi_columns.q index 1f6ad1a..948ed0e 100644 --- a/ql/src/test/queries/clientnegative/subquery_scalar_multi_columns.q +++ b/ql/src/test/queries/clientnegative/subquery_scalar_multi_columns.q @@ -1,2 +1,3 @@ +--! qt:dataset:part set hive.mapred.mode=nonstrict; select p_name from part where p_size > (select p_size, p_type from part); http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/subquery_scalar_multi_rows.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/subquery_scalar_multi_rows.q b/ql/src/test/queries/clientnegative/subquery_scalar_multi_rows.q index 14b68b9..77f4f08 100644 --- a/ql/src/test/queries/clientnegative/subquery_scalar_multi_rows.q +++ b/ql/src/test/queries/clientnegative/subquery_scalar_multi_rows.q @@ -1,2 +1,3 @@ +--! qt:dataset:part set hive.mapred.mode=nonstrict; select p_name from part where p_size > (select p_size from part); http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/subquery_select_aggregate.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/subquery_select_aggregate.q b/ql/src/test/queries/clientnegative/subquery_select_aggregate.q index 8da8521..8bd4460 100644 --- a/ql/src/test/queries/clientnegative/subquery_select_aggregate.q +++ b/ql/src/test/queries/clientnegative/subquery_select_aggregate.q @@ -1,2 +1,3 @@ +--! qt:dataset:part -- subqueries in UDFs are not allowed explain SELECT count((SELECT max(p_size) FROM part p WHERE p.p_type = part.p_type)) from part; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/subquery_select_distinct.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/subquery_select_distinct.q b/ql/src/test/queries/clientnegative/subquery_select_distinct.q index 5682ae7..34ee8cb 100644 --- a/ql/src/test/queries/clientnegative/subquery_select_distinct.q +++ b/ql/src/test/queries/clientnegative/subquery_select_distinct.q @@ -1,2 +1,3 @@ +--! qt:dataset:part -- subqueries in UDFs are not allowed explain SELECT distinct (SELECT max(p_size) FROM part p WHERE p.p_type = part.p_type) from part; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/subquery_select_distinct2.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/subquery_select_distinct2.q b/ql/src/test/queries/clientnegative/subquery_select_distinct2.q index 90c0588..060dd3a 100644 --- a/ql/src/test/queries/clientnegative/subquery_select_distinct2.q +++ b/ql/src/test/queries/clientnegative/subquery_select_distinct2.q @@ -1,2 +1,3 @@ +--! qt:dataset:part -- subqueries in UDFs are not allowed explain SELECT distinct p_size, (SELECT max(p_size) FROM part p WHERE p.p_type = part.p_type) from part; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/subquery_subquery_chain.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/subquery_subquery_chain.q b/ql/src/test/queries/clientnegative/subquery_subquery_chain.q index 8ea94c5..a969d37 100644 --- a/ql/src/test/queries/clientnegative/subquery_subquery_chain.q +++ b/ql/src/test/queries/clientnegative/subquery_subquery_chain.q @@ -1,3 +1,4 @@ +--! qt:dataset:src explain select * http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/subquery_subquery_chain_exists.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/subquery_subquery_chain_exists.q b/ql/src/test/queries/clientnegative/subquery_subquery_chain_exists.q index 0a771e2..497a548 100644 --- a/ql/src/test/queries/clientnegative/subquery_subquery_chain_exists.q +++ b/ql/src/test/queries/clientnegative/subquery_subquery_chain_exists.q @@ -1,3 +1,4 @@ +--! qt:dataset:src explain select * from src http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/subquery_windowing_corr.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/subquery_windowing_corr.q b/ql/src/test/queries/clientnegative/subquery_windowing_corr.q index ac15310..86cad1e 100644 --- a/ql/src/test/queries/clientnegative/subquery_windowing_corr.q +++ b/ql/src/test/queries/clientnegative/subquery_windowing_corr.q @@ -1,3 +1,4 @@ +--! qt:dataset:part -- corr and windowing select p_mfgr, p_name, p_size from part a http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/touch1.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/touch1.q b/ql/src/test/queries/clientnegative/touch1.q index 9efbba0..8cc2b91 100644 --- a/ql/src/test/queries/clientnegative/touch1.q +++ b/ql/src/test/queries/clientnegative/touch1.q @@ -1 +1,2 @@ +--! qt:dataset:srcpart ALTER TABLE srcpart TOUCH PARTITION (ds='2008-04-08', hr='13'); http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/touch2.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/touch2.q b/ql/src/test/queries/clientnegative/touch2.q index 923a171..c96ba42 100644 --- a/ql/src/test/queries/clientnegative/touch2.q +++ b/ql/src/test/queries/clientnegative/touch2.q @@ -1 +1,2 @@ +--! qt:dataset:src ALTER TABLE src TOUCH PARTITION (ds='2008-04-08', hr='12'); http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/truncate_bucketed_column.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/truncate_bucketed_column.q b/ql/src/test/queries/clientnegative/truncate_bucketed_column.q index e536656..955802e 100644 --- a/ql/src/test/queries/clientnegative/truncate_bucketed_column.q +++ b/ql/src/test/queries/clientnegative/truncate_bucketed_column.q @@ -1,3 +1,4 @@ +--! qt:dataset:src -- Tests truncating a bucketed column CREATE TABLE test_tab (key STRING, value STRING) CLUSTERED BY (key) INTO 2 BUCKETS STORED AS RCFILE; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/truncate_column_list_bucketing.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/truncate_column_list_bucketing.q b/ql/src/test/queries/clientnegative/truncate_column_list_bucketing.q index 90f6cf7..70cbce8 100644 --- a/ql/src/test/queries/clientnegative/truncate_column_list_bucketing.q +++ b/ql/src/test/queries/clientnegative/truncate_column_list_bucketing.q @@ -1,3 +1,4 @@ +--! qt:dataset:src set mapred.input.dir.recursive=true; -- Tests truncating a column on which a table is list bucketed http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/truncate_column_seqfile.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/truncate_column_seqfile.q b/ql/src/test/queries/clientnegative/truncate_column_seqfile.q index 903540d..4e42935 100644 --- a/ql/src/test/queries/clientnegative/truncate_column_seqfile.q +++ b/ql/src/test/queries/clientnegative/truncate_column_seqfile.q @@ -1,3 +1,4 @@ +--! qt:dataset:src -- Tests truncating a column from a table stored as a sequence file CREATE TABLE test_tab (key STRING, value STRING) STORED AS SEQUENCEFILE; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/truncate_nonexistant_column.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/truncate_nonexistant_column.q b/ql/src/test/queries/clientnegative/truncate_nonexistant_column.q index 5509552..08d07e5 100644 --- a/ql/src/test/queries/clientnegative/truncate_nonexistant_column.q +++ b/ql/src/test/queries/clientnegative/truncate_nonexistant_column.q @@ -1,3 +1,4 @@ +--! qt:dataset:src -- Tests attempting to truncate a column in a table that doesn't exist CREATE TABLE test_tab (key STRING, value STRING) STORED AS RCFILE; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/truncate_partition_column.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/truncate_partition_column.q b/ql/src/test/queries/clientnegative/truncate_partition_column.q index 134743a..40b8735 100644 --- a/ql/src/test/queries/clientnegative/truncate_partition_column.q +++ b/ql/src/test/queries/clientnegative/truncate_partition_column.q @@ -1,3 +1,5 @@ +--! qt:dataset:src +--! qt:dataset:part -- Tests truncating a partition column CREATE TABLE test_tab (key STRING, value STRING) PARTITIONED BY (part STRING) STORED AS RCFILE; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/truncate_partition_column2.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/truncate_partition_column2.q b/ql/src/test/queries/clientnegative/truncate_partition_column2.q index 4763520..e90db9b 100644 --- a/ql/src/test/queries/clientnegative/truncate_partition_column2.q +++ b/ql/src/test/queries/clientnegative/truncate_partition_column2.q @@ -1,3 +1,5 @@ +--! qt:dataset:src +--! qt:dataset:part -- Tests truncating a partition column CREATE TABLE test_tab (key STRING, value STRING) PARTITIONED BY (part STRING) STORED AS RCFILE; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/truncate_table_failure1.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/truncate_table_failure1.q b/ql/src/test/queries/clientnegative/truncate_table_failure1.q index f6cfa44..ac59138 100644 --- a/ql/src/test/queries/clientnegative/truncate_table_failure1.q +++ b/ql/src/test/queries/clientnegative/truncate_table_failure1.q @@ -1,2 +1,3 @@ +--! qt:dataset:src -- partition spec for non-partitioned table TRUNCATE TABLE src partition (ds='2008-04-08', hr='11'); http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/truncate_table_failure2.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/truncate_table_failure2.q b/ql/src/test/queries/clientnegative/truncate_table_failure2.q index 1137d89..2959b1d 100644 --- a/ql/src/test/queries/clientnegative/truncate_table_failure2.q +++ b/ql/src/test/queries/clientnegative/truncate_table_failure2.q @@ -1,2 +1,3 @@ +--! qt:dataset:srcpart -- full partition spec for not existing partition TRUNCATE TABLE srcpart partition (ds='2012-12-17', hr='15'); http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udaf_collect_set_unsupported.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udaf_collect_set_unsupported.q b/ql/src/test/queries/clientnegative/udaf_collect_set_unsupported.q index ed03620..9ba443e 100644 --- a/ql/src/test/queries/clientnegative/udaf_collect_set_unsupported.q +++ b/ql/src/test/queries/clientnegative/udaf_collect_set_unsupported.q @@ -1,3 +1,4 @@ +--! qt:dataset:src SELECT key, collect_set(create_union(value)) FROM src GROUP BY key ORDER BY key limit 20; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udaf_invalid_place.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udaf_invalid_place.q b/ql/src/test/queries/clientnegative/udaf_invalid_place.q index f37ce72..3411aa2 100644 --- a/ql/src/test/queries/clientnegative/udaf_invalid_place.q +++ b/ql/src/test/queries/clientnegative/udaf_invalid_place.q @@ -1 +1,2 @@ +--! qt:dataset:src select distinct key, sum(key) from src; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_array_contains_wrong1.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_array_contains_wrong1.q b/ql/src/test/queries/clientnegative/udf_array_contains_wrong1.q index c2a132d..edc8369 100644 --- a/ql/src/test/queries/clientnegative/udf_array_contains_wrong1.q +++ b/ql/src/test/queries/clientnegative/udf_array_contains_wrong1.q @@ -1,2 +1,3 @@ +--! qt:dataset:src -- invalid first argument SELECT array_contains(1, 2) FROM src LIMIT 1; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_array_contains_wrong2.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_array_contains_wrong2.q b/ql/src/test/queries/clientnegative/udf_array_contains_wrong2.q index 36f85d3..f7c0e74 100644 --- a/ql/src/test/queries/clientnegative/udf_array_contains_wrong2.q +++ b/ql/src/test/queries/clientnegative/udf_array_contains_wrong2.q @@ -1,2 +1,3 @@ +--! qt:dataset:src -- invalid second argument SELECT array_contains(array(1, 2, 3), '2') FROM src LIMIT 1; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_assert_true.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_assert_true.q b/ql/src/test/queries/clientnegative/udf_assert_true.q index 73b3f96..1b5b2a0 100644 --- a/ql/src/test/queries/clientnegative/udf_assert_true.q +++ b/ql/src/test/queries/clientnegative/udf_assert_true.q @@ -1,3 +1,4 @@ +--! qt:dataset:src DESCRIBE FUNCTION ASSERT_TRUE; EXPLAIN SELECT ASSERT_TRUE(x > 0) FROM src LATERAL VIEW EXPLODE(ARRAY(1, 2)) a AS x LIMIT 2; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_assert_true2.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_assert_true2.q b/ql/src/test/queries/clientnegative/udf_assert_true2.q index 4b62220..738ff3b 100644 --- a/ql/src/test/queries/clientnegative/udf_assert_true2.q +++ b/ql/src/test/queries/clientnegative/udf_assert_true2.q @@ -1,2 +1,3 @@ +--! qt:dataset:src EXPLAIN SELECT 1 + ASSERT_TRUE(x < 2) FROM src LATERAL VIEW EXPLODE(ARRAY(1, 2)) a AS x LIMIT 2; SELECT 1 + ASSERT_TRUE(x < 2) FROM src LATERAL VIEW EXPLODE(ARRAY(1, 2)) a AS x LIMIT 2; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_coalesce.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_coalesce.q b/ql/src/test/queries/clientnegative/udf_coalesce.q index 7405e38..bb4718e 100644 --- a/ql/src/test/queries/clientnegative/udf_coalesce.q +++ b/ql/src/test/queries/clientnegative/udf_coalesce.q @@ -1 +1,2 @@ +--! qt:dataset:src SELECT COALESCE(array('a', 'b'), '2.0') FROM src LIMIT 1; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_concat_ws_wrong1.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_concat_ws_wrong1.q b/ql/src/test/queries/clientnegative/udf_concat_ws_wrong1.q index 8c2017b..6aca60f 100644 --- a/ql/src/test/queries/clientnegative/udf_concat_ws_wrong1.q +++ b/ql/src/test/queries/clientnegative/udf_concat_ws_wrong1.q @@ -1,2 +1,3 @@ +--! qt:dataset:src -- invalid argument number SELECT concat_ws('-') FROM src LIMIT 1; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_concat_ws_wrong2.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_concat_ws_wrong2.q b/ql/src/test/queries/clientnegative/udf_concat_ws_wrong2.q index c49e786..dc65846 100644 --- a/ql/src/test/queries/clientnegative/udf_concat_ws_wrong2.q +++ b/ql/src/test/queries/clientnegative/udf_concat_ws_wrong2.q @@ -1,2 +1,3 @@ +--! qt:dataset:src -- invalid argument type SELECT concat_ws('[]', array(100, 200, 50)) FROM src LIMIT 1; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_concat_ws_wrong3.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_concat_ws_wrong3.q b/ql/src/test/queries/clientnegative/udf_concat_ws_wrong3.q index 72b8627..0356cd8 100644 --- a/ql/src/test/queries/clientnegative/udf_concat_ws_wrong3.q +++ b/ql/src/test/queries/clientnegative/udf_concat_ws_wrong3.q @@ -1,2 +1,3 @@ +--! qt:dataset:src -- invalid argument type SELECT concat_ws(1234, array('www', 'facebook', 'com')) FROM src LIMIT 1; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_elt_wrong_args_len.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_elt_wrong_args_len.q b/ql/src/test/queries/clientnegative/udf_elt_wrong_args_len.q index fbe4902..4c3e64d 100644 --- a/ql/src/test/queries/clientnegative/udf_elt_wrong_args_len.q +++ b/ql/src/test/queries/clientnegative/udf_elt_wrong_args_len.q @@ -1 +1,2 @@ +--! qt:dataset:src SELECT elt(3) FROM src; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_elt_wrong_type.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_elt_wrong_type.q b/ql/src/test/queries/clientnegative/udf_elt_wrong_type.q index bb1fdbf..8581dbb 100644 --- a/ql/src/test/queries/clientnegative/udf_elt_wrong_type.q +++ b/ql/src/test/queries/clientnegative/udf_elt_wrong_type.q @@ -1,3 +1,4 @@ +--! qt:dataset:src_thrift FROM src_thrift SELECT elt(1, src_thrift.lintstring) WHERE src_thrift.lintstring IS NOT NULL; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_field_wrong_args_len.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_field_wrong_args_len.q b/ql/src/test/queries/clientnegative/udf_field_wrong_args_len.q index 9703c82..2bed0ec 100644 --- a/ql/src/test/queries/clientnegative/udf_field_wrong_args_len.q +++ b/ql/src/test/queries/clientnegative/udf_field_wrong_args_len.q @@ -1 +1,2 @@ +--! qt:dataset:src SELECT field(3) FROM src; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_field_wrong_type.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_field_wrong_type.q b/ql/src/test/queries/clientnegative/udf_field_wrong_type.q index 61b2cd0..5b9c58e 100644 --- a/ql/src/test/queries/clientnegative/udf_field_wrong_type.q +++ b/ql/src/test/queries/clientnegative/udf_field_wrong_type.q @@ -1,3 +1,4 @@ +--! qt:dataset:src_thrift FROM src_thrift SELECT field(1, src_thrift.lintstring) WHERE src_thrift.lintstring IS NOT NULL; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_format_number_wrong1.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_format_number_wrong1.q b/ql/src/test/queries/clientnegative/udf_format_number_wrong1.q index 18c985c..03b4a29 100644 --- a/ql/src/test/queries/clientnegative/udf_format_number_wrong1.q +++ b/ql/src/test/queries/clientnegative/udf_format_number_wrong1.q @@ -1,2 +1,3 @@ +--! qt:dataset:src -- invalid argument length SELECT format_number(12332.123456) FROM src LIMIT 1; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_format_number_wrong2.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_format_number_wrong2.q b/ql/src/test/queries/clientnegative/udf_format_number_wrong2.q index 7959c20..4ccadaf 100644 --- a/ql/src/test/queries/clientnegative/udf_format_number_wrong2.q +++ b/ql/src/test/queries/clientnegative/udf_format_number_wrong2.q @@ -1,2 +1,3 @@ +--! qt:dataset:src -- invalid argument length SELECT format_number(12332.123456, 2, 3) FROM src LIMIT 1; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_format_number_wrong3.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_format_number_wrong3.q b/ql/src/test/queries/clientnegative/udf_format_number_wrong3.q index 7d90ef8..5837502 100644 --- a/ql/src/test/queries/clientnegative/udf_format_number_wrong3.q +++ b/ql/src/test/queries/clientnegative/udf_format_number_wrong3.q @@ -1,2 +1,3 @@ +--! qt:dataset:src -- invalid argument(second argument should be >= 0) SELECT format_number(12332.123456, -4) FROM src LIMIT 1; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_format_number_wrong4.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_format_number_wrong4.q b/ql/src/test/queries/clientnegative/udf_format_number_wrong4.q index e545f4a..0ac54c0 100644 --- a/ql/src/test/queries/clientnegative/udf_format_number_wrong4.q +++ b/ql/src/test/queries/clientnegative/udf_format_number_wrong4.q @@ -1,2 +1,3 @@ +--! qt:dataset:src -- invalid argument type SELECT format_number(12332.123456, 4.01) FROM src LIMIT 1; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_format_number_wrong5.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_format_number_wrong5.q b/ql/src/test/queries/clientnegative/udf_format_number_wrong5.q index a6f7177..7935562 100644 --- a/ql/src/test/queries/clientnegative/udf_format_number_wrong5.q +++ b/ql/src/test/queries/clientnegative/udf_format_number_wrong5.q @@ -1,2 +1,3 @@ +--! qt:dataset:src -- invalid argument type SELECT format_number(array(12332.123456, 321.23), 5) FROM src LIMIT 1; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_format_number_wrong7.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_format_number_wrong7.q b/ql/src/test/queries/clientnegative/udf_format_number_wrong7.q index aa4a3a4..17b888d 100644 --- a/ql/src/test/queries/clientnegative/udf_format_number_wrong7.q +++ b/ql/src/test/queries/clientnegative/udf_format_number_wrong7.q @@ -1,2 +1,3 @@ +--! qt:dataset:src -- invalid argument type(format_number returns the result as a string) SELECT format_number(format_number(12332.123456, 4), 2) FROM src LIMIT 1; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_greatest_error_1.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_greatest_error_1.q b/ql/src/test/queries/clientnegative/udf_greatest_error_1.q index e3347ed..2927be5 100644 --- a/ql/src/test/queries/clientnegative/udf_greatest_error_1.q +++ b/ql/src/test/queries/clientnegative/udf_greatest_error_1.q @@ -1 +1,2 @@ +--! qt:dataset:src SELECT GREATEST(array('a', 'b'), '2.0') FROM src LIMIT 1; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_greatest_error_2.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_greatest_error_2.q b/ql/src/test/queries/clientnegative/udf_greatest_error_2.q index ae6d928..ba99347 100644 --- a/ql/src/test/queries/clientnegative/udf_greatest_error_2.q +++ b/ql/src/test/queries/clientnegative/udf_greatest_error_2.q @@ -1 +1,2 @@ +--! qt:dataset:src SELECT GREATEST(1) FROM src LIMIT 1; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_if_not_bool.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_if_not_bool.q b/ql/src/test/queries/clientnegative/udf_if_not_bool.q index 74458d0..6052d49 100644 --- a/ql/src/test/queries/clientnegative/udf_if_not_bool.q +++ b/ql/src/test/queries/clientnegative/udf_if_not_bool.q @@ -1 +1,2 @@ +--! qt:dataset:src SELECT IF('STRING', 1, 1) FROM src; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_if_wrong_args_len.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_if_wrong_args_len.q b/ql/src/test/queries/clientnegative/udf_if_wrong_args_len.q index ad19364..ef97f0b 100644 --- a/ql/src/test/queries/clientnegative/udf_if_wrong_args_len.q +++ b/ql/src/test/queries/clientnegative/udf_if_wrong_args_len.q @@ -1 +1,2 @@ +--! qt:dataset:src SELECT IF(TRUE, 1) FROM src; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_in.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_in.q b/ql/src/test/queries/clientnegative/udf_in.q index ce9ce54..9ede156 100644 --- a/ql/src/test/queries/clientnegative/udf_in.q +++ b/ql/src/test/queries/clientnegative/udf_in.q @@ -1 +1,2 @@ +--! qt:dataset:src SELECT 3 IN (array(1,2,3)) FROM src; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_instr_wrong_args_len.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_instr_wrong_args_len.q b/ql/src/test/queries/clientnegative/udf_instr_wrong_args_len.q index ac8253f..302a3ee 100644 --- a/ql/src/test/queries/clientnegative/udf_instr_wrong_args_len.q +++ b/ql/src/test/queries/clientnegative/udf_instr_wrong_args_len.q @@ -1 +1,2 @@ +--! qt:dataset:src SELECT instr('abcd') FROM src; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_instr_wrong_type.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_instr_wrong_type.q b/ql/src/test/queries/clientnegative/udf_instr_wrong_type.q index 9ac3ed6..b9f7807 100644 --- a/ql/src/test/queries/clientnegative/udf_instr_wrong_type.q +++ b/ql/src/test/queries/clientnegative/udf_instr_wrong_type.q @@ -1,3 +1,4 @@ +--! qt:dataset:src_thrift FROM src_thrift SELECT instr('abcd', src_thrift.lintstring) WHERE src_thrift.lintstring IS NOT NULL; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_invalid.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_invalid.q b/ql/src/test/queries/clientnegative/udf_invalid.q index 68050fd..b10ac78 100644 --- a/ql/src/test/queries/clientnegative/udf_invalid.q +++ b/ql/src/test/queries/clientnegative/udf_invalid.q @@ -1 +1,2 @@ +--! qt:dataset:src select default.nonexistfunc() from src; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_likeall_wrong1.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_likeall_wrong1.q b/ql/src/test/queries/clientnegative/udf_likeall_wrong1.q index 2578ee2..055a4ec 100644 --- a/ql/src/test/queries/clientnegative/udf_likeall_wrong1.q +++ b/ql/src/test/queries/clientnegative/udf_likeall_wrong1.q @@ -1,2 +1,3 @@ +--! qt:dataset:src SELECT 120 like all ('a%','%bc%','%c') FROM src WHERE src.key = 86; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_likeany_wrong1.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_likeany_wrong1.q b/ql/src/test/queries/clientnegative/udf_likeany_wrong1.q index fcc0905..50b161c 100644 --- a/ql/src/test/queries/clientnegative/udf_likeany_wrong1.q +++ b/ql/src/test/queries/clientnegative/udf_likeany_wrong1.q @@ -1,2 +1,3 @@ +--! qt:dataset:src SELECT 120 like any ('a%','%bc%','%c') FROM src WHERE src.key = 86; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_locate_wrong_args_len.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_locate_wrong_args_len.q b/ql/src/test/queries/clientnegative/udf_locate_wrong_args_len.q index ca7caad..38492b9 100644 --- a/ql/src/test/queries/clientnegative/udf_locate_wrong_args_len.q +++ b/ql/src/test/queries/clientnegative/udf_locate_wrong_args_len.q @@ -1 +1,2 @@ +--! qt:dataset:src SELECT locate('a', 'b', 1, 2) FROM src; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_locate_wrong_type.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_locate_wrong_type.q b/ql/src/test/queries/clientnegative/udf_locate_wrong_type.q index 4bbf79a..b59bd8a 100644 --- a/ql/src/test/queries/clientnegative/udf_locate_wrong_type.q +++ b/ql/src/test/queries/clientnegative/udf_locate_wrong_type.q @@ -1,3 +1,4 @@ +--! qt:dataset:src_thrift FROM src_thrift SELECT locate('abcd', src_thrift.lintstring) WHERE src_thrift.lintstring IS NOT NULL; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_map_keys_arg_num.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_map_keys_arg_num.q b/ql/src/test/queries/clientnegative/udf_map_keys_arg_num.q index ebb6c2a..be00af1 100644 --- a/ql/src/test/queries/clientnegative/udf_map_keys_arg_num.q +++ b/ql/src/test/queries/clientnegative/udf_map_keys_arg_num.q @@ -1 +1,2 @@ +--! qt:dataset:src SELECT map_keys(map("a", "1"), map("b", "2")) FROM src LIMIT 1; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_map_keys_arg_type.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_map_keys_arg_type.q b/ql/src/test/queries/clientnegative/udf_map_keys_arg_type.q index 0757d14..a3cafe7 100644 --- a/ql/src/test/queries/clientnegative/udf_map_keys_arg_type.q +++ b/ql/src/test/queries/clientnegative/udf_map_keys_arg_type.q @@ -1 +1,2 @@ +--! qt:dataset:src SELECT map_keys(array(1, 2, 3)) FROM src LIMIT 1; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_map_values_arg_num.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_map_values_arg_num.q b/ql/src/test/queries/clientnegative/udf_map_values_arg_num.q index c97476a..e9c0ec5 100644 --- a/ql/src/test/queries/clientnegative/udf_map_values_arg_num.q +++ b/ql/src/test/queries/clientnegative/udf_map_values_arg_num.q @@ -1 +1,2 @@ +--! qt:dataset:src SELECT map_values(map("a", "1"), map("b", "2")) FROM src LIMIT 1; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_map_values_arg_type.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_map_values_arg_type.q b/ql/src/test/queries/clientnegative/udf_map_values_arg_type.q index cc060ea..1e25f7e 100644 --- a/ql/src/test/queries/clientnegative/udf_map_values_arg_type.q +++ b/ql/src/test/queries/clientnegative/udf_map_values_arg_type.q @@ -1 +1,2 @@ +--! qt:dataset:src SELECT map_values(array(1, 2, 3, 4)) FROM src LIMIT 1; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_max.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_max.q b/ql/src/test/queries/clientnegative/udf_max.q index 7282e07..d7072fa 100644 --- a/ql/src/test/queries/clientnegative/udf_max.q +++ b/ql/src/test/queries/clientnegative/udf_max.q @@ -1,2 +1,3 @@ +--! qt:dataset:src SELECT max(map("key", key, "value", value)) FROM src; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_min.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_min.q b/ql/src/test/queries/clientnegative/udf_min.q index b9528fa..6ce87ba 100644 --- a/ql/src/test/queries/clientnegative/udf_min.q +++ b/ql/src/test/queries/clientnegative/udf_min.q @@ -1,2 +1,3 @@ +--! qt:dataset:src SELECT min(map("key", key, "value", value)) FROM src; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_printf_wrong1.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_printf_wrong1.q b/ql/src/test/queries/clientnegative/udf_printf_wrong1.q index 88ca4fe..3a8ea12 100644 --- a/ql/src/test/queries/clientnegative/udf_printf_wrong1.q +++ b/ql/src/test/queries/clientnegative/udf_printf_wrong1.q @@ -1,2 +1,3 @@ +--! qt:dataset:src -- invalid argument length SELECT printf() FROM src LIMIT 1; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_printf_wrong2.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_printf_wrong2.q b/ql/src/test/queries/clientnegative/udf_printf_wrong2.q index 01ed2ff..a4836cd 100644 --- a/ql/src/test/queries/clientnegative/udf_printf_wrong2.q +++ b/ql/src/test/queries/clientnegative/udf_printf_wrong2.q @@ -1,2 +1,3 @@ +--! qt:dataset:src -- invalid argument type SELECT printf(100) FROM src LIMIT 1; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_printf_wrong3.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_printf_wrong3.q b/ql/src/test/queries/clientnegative/udf_printf_wrong3.q index 71f118b..bc51d20 100644 --- a/ql/src/test/queries/clientnegative/udf_printf_wrong3.q +++ b/ql/src/test/queries/clientnegative/udf_printf_wrong3.q @@ -1,2 +1,3 @@ +--! qt:dataset:src -- invalid argument type SELECT printf("Hello World %s", array("invalid", "argument")) FROM src LIMIT 1; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_printf_wrong4.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_printf_wrong4.q b/ql/src/test/queries/clientnegative/udf_printf_wrong4.q index 71f118b..bc51d20 100644 --- a/ql/src/test/queries/clientnegative/udf_printf_wrong4.q +++ b/ql/src/test/queries/clientnegative/udf_printf_wrong4.q @@ -1,2 +1,3 @@ +--! qt:dataset:src -- invalid argument type SELECT printf("Hello World %s", array("invalid", "argument")) FROM src LIMIT 1; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_reflect_neg.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_reflect_neg.q b/ql/src/test/queries/clientnegative/udf_reflect_neg.q index 67efb64..fedc439 100644 --- a/ql/src/test/queries/clientnegative/udf_reflect_neg.q +++ b/ql/src/test/queries/clientnegative/udf_reflect_neg.q @@ -1,3 +1,4 @@ +--! qt:dataset:src SELECT reflect("java.lang.StringClassThatDoesNotExist", "valueOf", 1), reflect("java.lang.String", "methodThatDoesNotExist"), reflect("java.lang.Math", "max", "overloadthatdoesnotexist", 3), http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_size_wrong_args_len.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_size_wrong_args_len.q b/ql/src/test/queries/clientnegative/udf_size_wrong_args_len.q index c628ff8..69554ab 100644 --- a/ql/src/test/queries/clientnegative/udf_size_wrong_args_len.q +++ b/ql/src/test/queries/clientnegative/udf_size_wrong_args_len.q @@ -1,3 +1,4 @@ +--! qt:dataset:src_thrift FROM src_thrift SELECT size(src_thrift.lint, src_thrift.lintstring), size() http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_size_wrong_type.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_size_wrong_type.q b/ql/src/test/queries/clientnegative/udf_size_wrong_type.q index 16695f6..6eecb46 100644 --- a/ql/src/test/queries/clientnegative/udf_size_wrong_type.q +++ b/ql/src/test/queries/clientnegative/udf_size_wrong_type.q @@ -1 +1,2 @@ +--! qt:dataset:src SELECT SIZE('wrong type: string') FROM src; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_sort_array_by_wrong1.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_sort_array_by_wrong1.q b/ql/src/test/queries/clientnegative/udf_sort_array_by_wrong1.q index 9101c7e..4ec26d0 100644 --- a/ql/src/test/queries/clientnegative/udf_sort_array_by_wrong1.q +++ b/ql/src/test/queries/clientnegative/udf_sort_array_by_wrong1.q @@ -1,2 +1,3 @@ +--! qt:dataset:src -- invalid argument type for first argument SELECT sort_array_by(array(2, 5, 4),'col1') FROM src LIMIT 1; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_sort_array_by_wrong2.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_sort_array_by_wrong2.q b/ql/src/test/queries/clientnegative/udf_sort_array_by_wrong2.q index 241d98e..6f3fd8b 100644 --- a/ql/src/test/queries/clientnegative/udf_sort_array_by_wrong2.q +++ b/ql/src/test/queries/clientnegative/udf_sort_array_by_wrong2.q @@ -1,2 +1,3 @@ +--! qt:dataset:src -- invalid numbers of arguments SELECT sort_array_by(array(struct(800 ,'Foo',28,80000) , struct(100,'Boo',21,70000))) FROM src LIMIT 1; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_sort_array_wrong1.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_sort_array_wrong1.q b/ql/src/test/queries/clientnegative/udf_sort_array_wrong1.q index 9954f4a..8f9ffef 100644 --- a/ql/src/test/queries/clientnegative/udf_sort_array_wrong1.q +++ b/ql/src/test/queries/clientnegative/udf_sort_array_wrong1.q @@ -1,2 +1,3 @@ +--! qt:dataset:src -- invalid argument number SELECT sort_array(array(2, 5, 4), 3) FROM src LIMIT 1; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_sort_array_wrong2.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_sort_array_wrong2.q b/ql/src/test/queries/clientnegative/udf_sort_array_wrong2.q index 32c2645..141403a 100644 --- a/ql/src/test/queries/clientnegative/udf_sort_array_wrong2.q +++ b/ql/src/test/queries/clientnegative/udf_sort_array_wrong2.q @@ -1,2 +1,3 @@ +--! qt:dataset:src -- invalid argument type SELECT sort_array("Invalid") FROM src LIMIT 1; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_sort_array_wrong3.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_sort_array_wrong3.q b/ql/src/test/queries/clientnegative/udf_sort_array_wrong3.q index 49856ae..8ad8015 100644 --- a/ql/src/test/queries/clientnegative/udf_sort_array_wrong3.q +++ b/ql/src/test/queries/clientnegative/udf_sort_array_wrong3.q @@ -1,2 +1,3 @@ +--! qt:dataset:src -- invalid argument type SELECT sort_array(array(create_union(0,"a"))) FROM src LIMIT 1; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_test_error.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_test_error.q b/ql/src/test/queries/clientnegative/udf_test_error.q index 846f87c..bd19fc5 100644 --- a/ql/src/test/queries/clientnegative/udf_test_error.q +++ b/ql/src/test/queries/clientnegative/udf_test_error.q @@ -1,3 +1,4 @@ +--! qt:dataset:src CREATE TEMPORARY FUNCTION test_error AS 'org.apache.hadoop.hive.ql.udf.UDFTestErrorOnFalse'; SELECT test_error(key < 125 OR key > 130) FROM src; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_test_error_reduce.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_test_error_reduce.q b/ql/src/test/queries/clientnegative/udf_test_error_reduce.q index b1a06f2..e5c77cc 100644 --- a/ql/src/test/queries/clientnegative/udf_test_error_reduce.q +++ b/ql/src/test/queries/clientnegative/udf_test_error_reduce.q @@ -1,3 +1,4 @@ +--! qt:dataset:src CREATE TEMPORARY FUNCTION test_error AS 'org.apache.hadoop.hive.ql.udf.UDFTestErrorOnFalse'; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udf_when_type_wrong.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udf_when_type_wrong.q b/ql/src/test/queries/clientnegative/udf_when_type_wrong.q index d4d2d2e..f36ddd3 100644 --- a/ql/src/test/queries/clientnegative/udf_when_type_wrong.q +++ b/ql/src/test/queries/clientnegative/udf_when_type_wrong.q @@ -1,3 +1,4 @@ +--! qt:dataset:src SELECT CASE WHEN TRUE THEN 2 WHEN '1' THEN 4 http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udtf_explode_not_supported1.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udtf_explode_not_supported1.q b/ql/src/test/queries/clientnegative/udtf_explode_not_supported1.q index 942ae5d..678f5fd 100644 --- a/ql/src/test/queries/clientnegative/udtf_explode_not_supported1.q +++ b/ql/src/test/queries/clientnegative/udtf_explode_not_supported1.q @@ -1 +1,2 @@ +--! qt:dataset:src SELECT explode(map(1,'one',2,'two',3,'three')) as (myKey,myVal) FROM src GROUP BY key; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udtf_explode_not_supported2.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udtf_explode_not_supported2.q b/ql/src/test/queries/clientnegative/udtf_explode_not_supported2.q index 00d359a..f085c9e 100644 --- a/ql/src/test/queries/clientnegative/udtf_explode_not_supported2.q +++ b/ql/src/test/queries/clientnegative/udtf_explode_not_supported2.q @@ -1 +1,2 @@ +--! qt:dataset:src SELECT explode(map(1,'one',2,'two',3,'three')) as (myKey,myVal,myVal2) FROM src; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udtf_explode_not_supported3.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udtf_explode_not_supported3.q b/ql/src/test/queries/clientnegative/udtf_explode_not_supported3.q index 51df8fa..4eed8c3 100644 --- a/ql/src/test/queries/clientnegative/udtf_explode_not_supported3.q +++ b/ql/src/test/queries/clientnegative/udtf_explode_not_supported3.q @@ -1 +1,2 @@ +--! qt:dataset:src select explode(array(1),array(2)) as myCol from src; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udtf_explode_not_supported4.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udtf_explode_not_supported4.q b/ql/src/test/queries/clientnegative/udtf_explode_not_supported4.q index ae8dff7..9004d33 100644 --- a/ql/src/test/queries/clientnegative/udtf_explode_not_supported4.q +++ b/ql/src/test/queries/clientnegative/udtf_explode_not_supported4.q @@ -1 +1,2 @@ +--! qt:dataset:src SELECT explode(null) as myNull FROM src GROUP BY key; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udtf_invalid_place.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udtf_invalid_place.q b/ql/src/test/queries/clientnegative/udtf_invalid_place.q index ab84a80..69a4b6c 100644 --- a/ql/src/test/queries/clientnegative/udtf_invalid_place.q +++ b/ql/src/test/queries/clientnegative/udtf_invalid_place.q @@ -1 +1,2 @@ +--! qt:dataset:src select distinct key, explode(key) from src; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udtf_not_supported1.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udtf_not_supported1.q b/ql/src/test/queries/clientnegative/udtf_not_supported1.q index 04e98d5..1fe4abe 100644 --- a/ql/src/test/queries/clientnegative/udtf_not_supported1.q +++ b/ql/src/test/queries/clientnegative/udtf_not_supported1.q @@ -1 +1,2 @@ +--! qt:dataset:src SELECT explode(array(1,2,3)) as myCol, key FROM src; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/udtf_not_supported3.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/udtf_not_supported3.q b/ql/src/test/queries/clientnegative/udtf_not_supported3.q index f4fe0dd..0cf1bd6 100644 --- a/ql/src/test/queries/clientnegative/udtf_not_supported3.q +++ b/ql/src/test/queries/clientnegative/udtf_not_supported3.q @@ -1 +1,2 @@ +--! qt:dataset:src SELECT explode(array(1,2,3)) as myCol FROM src GROUP BY key; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/union22.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/union22.q b/ql/src/test/queries/clientnegative/union22.q index 0e43cd3..7d84423 100644 --- a/ql/src/test/queries/clientnegative/union22.q +++ b/ql/src/test/queries/clientnegative/union22.q @@ -1,3 +1,4 @@ +--! qt:dataset:src set hive.mapred.mode=nonstrict; create table dst_union22(k1 string, k2 string, k3 string, k4 string) partitioned by (ds string); create table dst_union22_delta(k0 string, k1 string, k2 string, k3 string, k4 string, k5 string) partitioned by (ds string); http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/unionClusterBy.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/unionClusterBy.q b/ql/src/test/queries/clientnegative/unionClusterBy.q index f2bf837..e9bf95b 100644 --- a/ql/src/test/queries/clientnegative/unionClusterBy.q +++ b/ql/src/test/queries/clientnegative/unionClusterBy.q @@ -1,3 +1,4 @@ +--! qt:dataset:src -- orderByClause clusterByClause distributeByClause sortByClause limitClause -- can only be applied to the whole union. http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/unionDistributeBy.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/unionDistributeBy.q b/ql/src/test/queries/clientnegative/unionDistributeBy.q index fe2a544..0b9b1c6 100644 --- a/ql/src/test/queries/clientnegative/unionDistributeBy.q +++ b/ql/src/test/queries/clientnegative/unionDistributeBy.q @@ -1,3 +1,4 @@ +--! qt:dataset:src -- orderByClause clusterByClause distributeByClause sortByClause limitClause -- can only be applied to the whole union. http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/unionLimit.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/unionLimit.q b/ql/src/test/queries/clientnegative/unionLimit.q index 91f2af5..55c2a98 100644 --- a/ql/src/test/queries/clientnegative/unionLimit.q +++ b/ql/src/test/queries/clientnegative/unionLimit.q @@ -1,3 +1,4 @@ +--! qt:dataset:src -- orderByClause clusterByClause distributeByClause sortByClause limitClause -- can only be applied to the whole union. http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/unionOrderBy.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/unionOrderBy.q b/ql/src/test/queries/clientnegative/unionOrderBy.q index 0477e2d..fdd5e9c 100644 --- a/ql/src/test/queries/clientnegative/unionOrderBy.q +++ b/ql/src/test/queries/clientnegative/unionOrderBy.q @@ -1,3 +1,4 @@ +--! qt:dataset:src -- orderByClause clusterByClause distributeByClause sortByClause limitClause -- can only be applied to the whole union. http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/unionSortBy.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/unionSortBy.q b/ql/src/test/queries/clientnegative/unionSortBy.q index 8cf8b90..4cd5226 100644 --- a/ql/src/test/queries/clientnegative/unionSortBy.q +++ b/ql/src/test/queries/clientnegative/unionSortBy.q @@ -1,3 +1,4 @@ +--! qt:dataset:src -- orderByClause clusterByClause distributeByClause sortByClause limitClause -- can only be applied to the whole union. http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/uniquejoin.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/uniquejoin.q b/ql/src/test/queries/clientnegative/uniquejoin.q index d6a19c3..3a69f93 100644 --- a/ql/src/test/queries/clientnegative/uniquejoin.q +++ b/ql/src/test/queries/clientnegative/uniquejoin.q @@ -1,3 +1,4 @@ +--! qt:dataset:src FROM UNIQUEJOIN (SELECT src.key from src WHERE src.key<4) a (a.key), PRESERVE src b(b.key) SELECT a.key, b.key; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/uniquejoin2.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/uniquejoin2.q b/ql/src/test/queries/clientnegative/uniquejoin2.q index 6e9a082..f14f38e 100644 --- a/ql/src/test/queries/clientnegative/uniquejoin2.q +++ b/ql/src/test/queries/clientnegative/uniquejoin2.q @@ -1,3 +1,4 @@ +--! qt:dataset:src FROM UNIQUEJOIN src a (a.key), PRESERVE src b (b.key, b.val) SELECT a.key, b.key; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/uniquejoin3.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/uniquejoin3.q b/ql/src/test/queries/clientnegative/uniquejoin3.q index 89a8f1b..7673224 100644 --- a/ql/src/test/queries/clientnegative/uniquejoin3.q +++ b/ql/src/test/queries/clientnegative/uniquejoin3.q @@ -1,3 +1,4 @@ +--! qt:dataset:src FROM UNIQUEJOIN src a (a.key), PRESERVE src b (b.key) JOIN src c ON c.key SELECT a.key; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/unset_view_property.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/unset_view_property.q b/ql/src/test/queries/clientnegative/unset_view_property.q index 1113100..19ad44c 100644 --- a/ql/src/test/queries/clientnegative/unset_view_property.q +++ b/ql/src/test/queries/clientnegative/unset_view_property.q @@ -1,3 +1,4 @@ +--! qt:dataset:src CREATE VIEW testView AS SELECT value FROM src WHERE key=86; ALTER VIEW testView SET TBLPROPERTIES ('propA'='100', 'propB'='200'); SHOW TBLPROPERTIES testView; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/updateBasicStats.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/updateBasicStats.q b/ql/src/test/queries/clientnegative/updateBasicStats.q index b9e642d..28be485 100644 --- a/ql/src/test/queries/clientnegative/updateBasicStats.q +++ b/ql/src/test/queries/clientnegative/updateBasicStats.q @@ -1,3 +1,4 @@ +--! qt:dataset:src set hive.mapred.mode=nonstrict; create table s as select * from src limit 10; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/update_non_acid_table.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/update_non_acid_table.q b/ql/src/test/queries/clientnegative/update_non_acid_table.q index f588f68..59f01f9 100644 --- a/ql/src/test/queries/clientnegative/update_non_acid_table.q +++ b/ql/src/test/queries/clientnegative/update_non_acid_table.q @@ -1,3 +1,4 @@ +--! qt:dataset:alltypesorc set hive.mapred.mode=nonstrict; set hive.support.concurrency=true; set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/windowing_invalid_udaf.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/windowing_invalid_udaf.q b/ql/src/test/queries/clientnegative/windowing_invalid_udaf.q index c5b593e..e3a5a5a 100644 --- a/ql/src/test/queries/clientnegative/windowing_invalid_udaf.q +++ b/ql/src/test/queries/clientnegative/windowing_invalid_udaf.q @@ -1 +1,2 @@ +--! qt:dataset:src select nonexistfunc(key) over () from src limit 1; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/windowing_leadlag_in_udaf.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/windowing_leadlag_in_udaf.q b/ql/src/test/queries/clientnegative/windowing_leadlag_in_udaf.q index 971f960..e401b53 100644 --- a/ql/src/test/queries/clientnegative/windowing_leadlag_in_udaf.q +++ b/ql/src/test/queries/clientnegative/windowing_leadlag_in_udaf.q @@ -1 +1,2 @@ +--! qt:dataset:part select sum(lead(p_retailprice,1)) as s1 from part; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/windowing_ll_no_neg.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/windowing_ll_no_neg.q b/ql/src/test/queries/clientnegative/windowing_ll_no_neg.q index 3aba793..7e2a374 100644 --- a/ql/src/test/queries/clientnegative/windowing_ll_no_neg.q +++ b/ql/src/test/queries/clientnegative/windowing_ll_no_neg.q @@ -1,3 +1,4 @@ +--! qt:dataset:part select p_mfgr, p_name, p_size, min(p_retailprice), rank() over(distribute by p_mfgr sort by p_name)as r, http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/windowing_ll_no_over.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/windowing_ll_no_over.q b/ql/src/test/queries/clientnegative/windowing_ll_no_over.q index 6fc6df6..c6bd63e 100644 --- a/ql/src/test/queries/clientnegative/windowing_ll_no_over.q +++ b/ql/src/test/queries/clientnegative/windowing_ll_no_over.q @@ -1,3 +1,4 @@ +--! qt:dataset:part select p_mfgr, lead(p_retailprice,1) as s1 from part; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientnegative/wrong_column_type.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientnegative/wrong_column_type.q b/ql/src/test/queries/clientnegative/wrong_column_type.q index 490f0c3..c1a937e 100644 --- a/ql/src/test/queries/clientnegative/wrong_column_type.q +++ b/ql/src/test/queries/clientnegative/wrong_column_type.q @@ -1,3 +1,4 @@ +--! qt:dataset:src CREATE TABLE dest1(a float); INSERT OVERWRITE TABLE dest1 http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/acid_bucket_pruning.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/acid_bucket_pruning.q b/ql/src/test/queries/clientpositive/acid_bucket_pruning.q index d8d59b2..476db6d 100644 --- a/ql/src/test/queries/clientpositive/acid_bucket_pruning.q +++ b/ql/src/test/queries/clientpositive/acid_bucket_pruning.q @@ -1,3 +1,4 @@ +--! qt:dataset:alltypesorc set hive.mapred.mode=nonstrict; set hive.optimize.ppd=true; set hive.optimize.index.filter=true; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/acid_globallimit.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/acid_globallimit.q b/ql/src/test/queries/clientpositive/acid_globallimit.q index 233b6b4..ed986c3 100644 --- a/ql/src/test/queries/clientpositive/acid_globallimit.q +++ b/ql/src/test/queries/clientpositive/acid_globallimit.q @@ -1,3 +1,4 @@ +--! qt:dataset:alltypesorc set hive.support.concurrency=true; set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager; set hive.fetch.task.conversion=none; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/acid_no_buckets.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/acid_no_buckets.q b/ql/src/test/queries/clientpositive/acid_no_buckets.q index 189ad08..bcf9e06 100644 --- a/ql/src/test/queries/clientpositive/acid_no_buckets.q +++ b/ql/src/test/queries/clientpositive/acid_no_buckets.q @@ -1,3 +1,4 @@ +--! qt:dataset:srcpart --this has 4 groups of tests --Acid tables w/o bucketing --the tests with bucketing (make sure we get the same results) http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/acid_nullscan.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/acid_nullscan.q b/ql/src/test/queries/clientpositive/acid_nullscan.q index 3c71242..0d8ca2a 100644 --- a/ql/src/test/queries/clientpositive/acid_nullscan.q +++ b/ql/src/test/queries/clientpositive/acid_nullscan.q @@ -1,3 +1,4 @@ +--! qt:dataset:alltypesorc set hive.mapred.mode=nonstrict; set hive.support.concurrency=true; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/acid_table_stats.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/acid_table_stats.q b/ql/src/test/queries/clientpositive/acid_table_stats.q index 9a3d97e..268028a 100644 --- a/ql/src/test/queries/clientpositive/acid_table_stats.q +++ b/ql/src/test/queries/clientpositive/acid_table_stats.q @@ -1,3 +1,4 @@ +--! qt:dataset:srcpart set hive.mapred.mode=nonstrict; set hive.support.concurrency=true; set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/acid_vectorization.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/acid_vectorization.q b/ql/src/test/queries/clientpositive/acid_vectorization.q index 4c37563..1d27768 100644 --- a/ql/src/test/queries/clientpositive/acid_vectorization.q +++ b/ql/src/test/queries/clientpositive/acid_vectorization.q @@ -1,3 +1,4 @@ +--! qt:dataset:alltypesorc set hive.mapred.mode=nonstrict; set hive.support.concurrency=true; set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/acid_vectorization_partition.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/acid_vectorization_partition.q b/ql/src/test/queries/clientpositive/acid_vectorization_partition.q index d912677..975767c 100644 --- a/ql/src/test/queries/clientpositive/acid_vectorization_partition.q +++ b/ql/src/test/queries/clientpositive/acid_vectorization_partition.q @@ -1,3 +1,4 @@ +--! qt:dataset:alltypesorc set hive.mapred.mode=nonstrict; set hive.support.concurrency=true; set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/acid_vectorization_project.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/acid_vectorization_project.q b/ql/src/test/queries/clientpositive/acid_vectorization_project.q index 3725cb1..a726470 100644 --- a/ql/src/test/queries/clientpositive/acid_vectorization_project.q +++ b/ql/src/test/queries/clientpositive/acid_vectorization_project.q @@ -1,3 +1,4 @@ +--! qt:dataset:alltypesorc set hive.mapred.mode=nonstrict; set hive.support.concurrency=true; set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/add_jar_with_file_removed.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/add_jar_with_file_removed.q b/ql/src/test/queries/clientpositive/add_jar_with_file_removed.q index 95d7001..b45f712 100644 --- a/ql/src/test/queries/clientpositive/add_jar_with_file_removed.q +++ b/ql/src/test/queries/clientpositive/add_jar_with_file_removed.q @@ -1,3 +1,4 @@ +--! qt:dataset:src !mkdir ${system:test.tmp.dir}/tmpjars; !touch ${system:test.tmp.dir}/tmpjars/added1.jar; !touch ${system:test.tmp.dir}/tmpjars/added2.jar; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/add_part_exist.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/add_part_exist.q b/ql/src/test/queries/clientpositive/add_part_exist.q index b8ace72..a531bbc 100644 --- a/ql/src/test/queries/clientpositive/add_part_exist.q +++ b/ql/src/test/queries/clientpositive/add_part_exist.q @@ -14,7 +14,6 @@ ALTER TABLE add_part_test ADD IF NOT EXISTS PARTITION (ds='2010-01-01') PARTITIO SHOW PARTITIONS add_part_test; DROP TABLE add_part_test; -SHOW TABLES; -- Test ALTER TABLE ADD PARTITION in non-default Database CREATE DATABASE add_part_test_db; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/add_part_multiple.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/add_part_multiple.q b/ql/src/test/queries/clientpositive/add_part_multiple.q index 93ed787..9403368 100644 --- a/ql/src/test/queries/clientpositive/add_part_multiple.q +++ b/ql/src/test/queries/clientpositive/add_part_multiple.q @@ -1,3 +1,4 @@ +--! qt:dataset:src set hive.mapred.mode=nonstrict; -- HIVE-5122 locations for 2nd, 3rd... partition are ignored http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/add_partition_with_whitelist.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/add_partition_with_whitelist.q b/ql/src/test/queries/clientpositive/add_partition_with_whitelist.q index 009c761..ab06484 100644 --- a/ql/src/test/queries/clientpositive/add_partition_with_whitelist.q +++ b/ql/src/test/queries/clientpositive/add_partition_with_whitelist.q @@ -1,3 +1,4 @@ +--! qt:dataset:part SET hive.metastore.partition.name.whitelist.pattern=[A-Za-z]*; -- This pattern matches only letters. http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/alias_casted_column.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/alias_casted_column.q b/ql/src/test/queries/clientpositive/alias_casted_column.q index f1fc91a..c6a6a09 100644 --- a/ql/src/test/queries/clientpositive/alias_casted_column.q +++ b/ql/src/test/queries/clientpositive/alias_casted_column.q @@ -1,3 +1,4 @@ +--! qt:dataset:src -- HIVE-2477 Use name of original expression for name of CAST output explain select key from (select cast(key as int) from src )t; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/allcolref_in_udf.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/allcolref_in_udf.q b/ql/src/test/queries/clientpositive/allcolref_in_udf.q index ecba251..c28d26e 100644 --- a/ql/src/test/queries/clientpositive/allcolref_in_udf.q +++ b/ql/src/test/queries/clientpositive/allcolref_in_udf.q @@ -1,3 +1,4 @@ +--! qt:dataset:src set hive.mapred.mode=nonstrict; explain select concat(*),array(*) from src where key < 100 limit 10; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/alter1.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/alter1.q b/ql/src/test/queries/clientpositive/alter1.q index 767ab5c..0843351 100644 --- a/ql/src/test/queries/clientpositive/alter1.q +++ b/ql/src/test/queries/clientpositive/alter1.q @@ -28,7 +28,7 @@ describe alter1; -- Cleanup DROP TABLE alter1; -SHOW TABLES; +SHOW TABLES LIKE "alter*"; -- With non-default Database http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/alter2.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/alter2.q b/ql/src/test/queries/clientpositive/alter2.q index ddf5787..6586afc 100644 --- a/ql/src/test/queries/clientpositive/alter2.q +++ b/ql/src/test/queries/clientpositive/alter2.q @@ -21,13 +21,13 @@ show partitions alter2; -- Cleanup DROP TABLE alter2; -SHOW TABLES; +SHOW TABLES LIKE "alter*"; -- Using non-default Database CREATE DATABASE alter2_db; USE alter2_db; -SHOW TABLES; +SHOW TABLES LIKE "alter*"; CREATE TABLE alter2(a int, b int) PARTITIONED BY (insertdate string); DESCRIBE EXTENDED alter2; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/alter3.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/alter3.q b/ql/src/test/queries/clientpositive/alter3.q index 91e4e9b..a38643d 100644 --- a/ql/src/test/queries/clientpositive/alter3.q +++ b/ql/src/test/queries/clientpositive/alter3.q @@ -25,7 +25,7 @@ describe extended alter3_like_renamed; DROP TABLE alter3_src; DROP TABLE alter3_renamed; DROP TABLE alter3_like_renamed; -SHOW TABLES; +SHOW TABLES LIKE "alter3_*"; -- With non-default Database http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/alter4.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/alter4.q b/ql/src/test/queries/clientpositive/alter4.q index 542ff01..7a87113 100644 --- a/ql/src/test/queries/clientpositive/alter4.q +++ b/ql/src/test/queries/clientpositive/alter4.q @@ -6,7 +6,7 @@ DESCRIBE EXTENDED set_bucketing_test; -- Cleanup DROP TABLE set_bucketing_test; -SHOW TABLES; +SHOW TABLES LIKE "set_bucketing_*"; -- with non-default Database http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/alter5.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/alter5.q b/ql/src/test/queries/clientpositive/alter5.q index 66c9f8d..62a73a4 100644 --- a/ql/src/test/queries/clientpositive/alter5.q +++ b/ql/src/test/queries/clientpositive/alter5.q @@ -23,7 +23,7 @@ describe extended alter5 partition (dt='a'); -- Cleanup DROP TABLE alter5_src; DROP TABLE alter5; -SHOW TABLES; +SHOW TABLES LIKE "alter*"; -- With non-default Database http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/alter_char1.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/alter_char1.q b/ql/src/test/queries/clientpositive/alter_char1.q index b604656..f828d39 100644 --- a/ql/src/test/queries/clientpositive/alter_char1.q +++ b/ql/src/test/queries/clientpositive/alter_char1.q @@ -1,3 +1,4 @@ +--! qt:dataset:src -- SORT_QUERY_RESULTS create database ac; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/alter_char2.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/alter_char2.q b/ql/src/test/queries/clientpositive/alter_char2.q index 24f9c58..44b352b 100644 --- a/ql/src/test/queries/clientpositive/alter_char2.q +++ b/ql/src/test/queries/clientpositive/alter_char2.q @@ -1,3 +1,4 @@ +--! qt:dataset:src set hive.mapred.mode=nonstrict; -- alter column type, with partitioned table http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/alter_merge_2_orc.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/alter_merge_2_orc.q b/ql/src/test/queries/clientpositive/alter_merge_2_orc.q index 10ba6e4..90257cf 100644 --- a/ql/src/test/queries/clientpositive/alter_merge_2_orc.q +++ b/ql/src/test/queries/clientpositive/alter_merge_2_orc.q @@ -1,3 +1,4 @@ +--! qt:dataset:src set hive.mapred.mode=nonstrict; create table src_orc_merge_test_part(key int, value string) partitioned by (ds string, ts string) stored as orc; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/alter_merge_orc.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/alter_merge_orc.q b/ql/src/test/queries/clientpositive/alter_merge_orc.q index aac98a8..f88b2a4 100644 --- a/ql/src/test/queries/clientpositive/alter_merge_orc.q +++ b/ql/src/test/queries/clientpositive/alter_merge_orc.q @@ -1,3 +1,4 @@ +--! qt:dataset:src set hive.compute.query.using.stats=false; set hive.mapred.mode=nonstrict; create table src_orc_merge_test(key int, value string) stored as orc; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/alter_merge_stats_orc.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/alter_merge_stats_orc.q b/ql/src/test/queries/clientpositive/alter_merge_stats_orc.q index 8d0c7bd..af02b58 100644 --- a/ql/src/test/queries/clientpositive/alter_merge_stats_orc.q +++ b/ql/src/test/queries/clientpositive/alter_merge_stats_orc.q @@ -1,3 +1,4 @@ +--! qt:dataset:src set hive.exec.submitviachild=false; set hive.exec.submit.local.task.via.child=false; create table src_orc_merge_test_stat(key int, value string) stored as orc; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/alter_numbuckets_partitioned_table2_h23.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/alter_numbuckets_partitioned_table2_h23.q b/ql/src/test/queries/clientpositive/alter_numbuckets_partitioned_table2_h23.q index 15a88bb..1aa6401 100644 --- a/ql/src/test/queries/clientpositive/alter_numbuckets_partitioned_table2_h23.q +++ b/ql/src/test/queries/clientpositive/alter_numbuckets_partitioned_table2_h23.q @@ -1,3 +1,4 @@ +--! qt:dataset:src -- Tests that when overwriting a partition in a table after altering the bucketing/sorting metadata -- the partition metadata is updated as well. http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/alter_numbuckets_partitioned_table_h23.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/alter_numbuckets_partitioned_table_h23.q b/ql/src/test/queries/clientpositive/alter_numbuckets_partitioned_table_h23.q index 7d523d9..d214715 100644 --- a/ql/src/test/queries/clientpositive/alter_numbuckets_partitioned_table_h23.q +++ b/ql/src/test/queries/clientpositive/alter_numbuckets_partitioned_table_h23.q @@ -1,3 +1,4 @@ +--! qt:dataset:src -- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.20S) create table tst1(key string, value string) partitioned by (ds string) clustered by (key) into 10 buckets; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/alter_partition_coltype.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/alter_partition_coltype.q b/ql/src/test/queries/clientpositive/alter_partition_coltype.q index c9a898b..b902a60 100644 --- a/ql/src/test/queries/clientpositive/alter_partition_coltype.q +++ b/ql/src/test/queries/clientpositive/alter_partition_coltype.q @@ -1,3 +1,5 @@ +--! qt:dataset:src1 +--! qt:dataset:src -- create testing table. create table alter_coltype(key string, value string) partitioned by (dt string, ts string); http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/alter_partition_update_status.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/alter_partition_update_status.q b/ql/src/test/queries/clientpositive/alter_partition_update_status.q index f8bf2a2..434cff5 100644 --- a/ql/src/test/queries/clientpositive/alter_partition_update_status.q +++ b/ql/src/test/queries/clientpositive/alter_partition_update_status.q @@ -1,3 +1,4 @@ +--! qt:dataset:src1 create table src_stat_part_one(key string, value string) partitioned by (partitionId int); insert overwrite table src_stat_part_one partition (partitionId=1) http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/alter_partition_with_whitelist.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/alter_partition_with_whitelist.q b/ql/src/test/queries/clientpositive/alter_partition_with_whitelist.q index 301362a..3547503 100644 --- a/ql/src/test/queries/clientpositive/alter_partition_with_whitelist.q +++ b/ql/src/test/queries/clientpositive/alter_partition_with_whitelist.q @@ -1,3 +1,4 @@ +--! qt:dataset:part SET hive.metastore.partition.name.whitelist.pattern=[A-Za-z]*; -- This pattern matches only letters. http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/alter_rename_partition.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/alter_rename_partition.q b/ql/src/test/queries/clientpositive/alter_rename_partition.q index 8ebbe9882..b6f6ccc 100644 --- a/ql/src/test/queries/clientpositive/alter_rename_partition.q +++ b/ql/src/test/queries/clientpositive/alter_rename_partition.q @@ -1,7 +1,6 @@ -- Cleanup DROP TABLE alter_rename_partition_src; DROP TABLE alter_rename_partition; -SHOW TABLES; create table alter_rename_partition_src ( col1 string ) stored as textfile ; load data local inpath '../../data/files/test.dat' overwrite into table alter_rename_partition_src ; @@ -19,7 +18,6 @@ select * from alter_rename_partition where pcol1='new_part1:' and pcol2='new_par -- Cleanup DROP TABLE alter_rename_partition_src; DROP TABLE alter_rename_partition; -SHOW TABLES; -- With non-default Database http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/alter_rename_partition_authorization.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/alter_rename_partition_authorization.q b/ql/src/test/queries/clientpositive/alter_rename_partition_authorization.q index 70f2bb4..5ffcaf0 100644 --- a/ql/src/test/queries/clientpositive/alter_rename_partition_authorization.q +++ b/ql/src/test/queries/clientpositive/alter_rename_partition_authorization.q @@ -1,3 +1,4 @@ +--! qt:dataset:src set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.DefaultHiveAuthorizationProvider; -- SORT_BEFORE_DIFF http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/alter_rename_table.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/alter_rename_table.q b/ql/src/test/queries/clientpositive/alter_rename_table.q index 2061850..53fb230 100644 --- a/ql/src/test/queries/clientpositive/alter_rename_table.q +++ b/ql/src/test/queries/clientpositive/alter_rename_table.q @@ -1,3 +1,6 @@ +--! qt:dataset:srcpart +--! qt:dataset:src1 +--! qt:dataset:src set hive.mapred.mode=nonstrict; create database source; create database target; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/alter_table_column_stats.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/alter_table_column_stats.q b/ql/src/test/queries/clientpositive/alter_table_column_stats.q index 8892d3f..9bb9ed7 100644 --- a/ql/src/test/queries/clientpositive/alter_table_column_stats.q +++ b/ql/src/test/queries/clientpositive/alter_table_column_stats.q @@ -1,3 +1,5 @@ +--! qt:dataset:src +--! qt:dataset:part set hive.mapred.mode=nonstrict; set hive.metastore.try.direct.sql=true; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/alter_table_serde2.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/alter_table_serde2.q b/ql/src/test/queries/clientpositive/alter_table_serde2.q index 6ca3be3..b7717f9 100644 --- a/ql/src/test/queries/clientpositive/alter_table_serde2.q +++ b/ql/src/test/queries/clientpositive/alter_table_serde2.q @@ -1,3 +1,4 @@ +--! qt:dataset:src -- Tests that when overwriting a partition in a table after altering the serde properties -- the partition metadata is updated as well. http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/alter_table_stats_status.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/alter_table_stats_status.q b/ql/src/test/queries/clientpositive/alter_table_stats_status.q index 8e07b81..9101f30 100644 --- a/ql/src/test/queries/clientpositive/alter_table_stats_status.q +++ b/ql/src/test/queries/clientpositive/alter_table_stats_status.q @@ -1,3 +1,5 @@ +--! qt:dataset:srcpart +--! qt:dataset:src create database statsdb; use statsdb; create table srctable like default.src; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/alter_table_update_status.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/alter_table_update_status.q b/ql/src/test/queries/clientpositive/alter_table_update_status.q index 9415c97..8882584 100644 --- a/ql/src/test/queries/clientpositive/alter_table_update_status.q +++ b/ql/src/test/queries/clientpositive/alter_table_update_status.q @@ -1,3 +1,4 @@ +--! qt:dataset:src1 create table src_stat as select * from src1; create table src_stat_int ( http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/alter_table_update_status_disable_bitvector.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/alter_table_update_status_disable_bitvector.q b/ql/src/test/queries/clientpositive/alter_table_update_status_disable_bitvector.q index d64263f..f49c7a0 100644 --- a/ql/src/test/queries/clientpositive/alter_table_update_status_disable_bitvector.q +++ b/ql/src/test/queries/clientpositive/alter_table_update_status_disable_bitvector.q @@ -1,3 +1,4 @@ +--! qt:dataset:src1 set hive.stats.fetch.bitvector=false; create table src_stat as select * from src1; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/alter_varchar1.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/alter_varchar1.q b/ql/src/test/queries/clientpositive/alter_varchar1.q index 8ed3d20..4ca2954 100644 --- a/ql/src/test/queries/clientpositive/alter_varchar1.q +++ b/ql/src/test/queries/clientpositive/alter_varchar1.q @@ -1,3 +1,4 @@ +--! qt:dataset:src -- SORT_QUERY_RESULTS create database avc; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/alter_varchar2.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/alter_varchar2.q b/ql/src/test/queries/clientpositive/alter_varchar2.q index 558969a..ba70456 100644 --- a/ql/src/test/queries/clientpositive/alter_varchar2.q +++ b/ql/src/test/queries/clientpositive/alter_varchar2.q @@ -1,3 +1,4 @@ +--! qt:dataset:src set hive.mapred.mode=nonstrict; -- alter column type, with partitioned table http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/alter_view_as_select.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/alter_view_as_select.q b/ql/src/test/queries/clientpositive/alter_view_as_select.q index d2519a8..20c57b3 100644 --- a/ql/src/test/queries/clientpositive/alter_view_as_select.q +++ b/ql/src/test/queries/clientpositive/alter_view_as_select.q @@ -1,3 +1,5 @@ +--! qt:dataset:srcpart +--! qt:dataset:src CREATE DATABASE tv; CREATE VIEW tv.testView as SELECT * FROM srcpart; DESCRIBE FORMATTED tv.testView; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/ambiguitycheck.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/ambiguitycheck.q b/ql/src/test/queries/clientpositive/ambiguitycheck.q index 2334bc6..80b2fb4 100644 --- a/ql/src/test/queries/clientpositive/ambiguitycheck.q +++ b/ql/src/test/queries/clientpositive/ambiguitycheck.q @@ -1,3 +1,4 @@ +--! qt:dataset:src -- check cluster/distribute/partitionBy SELECT * FROM SRC x where x.key = 20 CLUSTER BY (key,value) ; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/ambiguous_col.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/ambiguous_col.q b/ql/src/test/queries/clientpositive/ambiguous_col.q index d1cebeb..0854718 100644 --- a/ql/src/test/queries/clientpositive/ambiguous_col.q +++ b/ql/src/test/queries/clientpositive/ambiguous_col.q @@ -1,3 +1,5 @@ +--! qt:dataset:src1 +--! qt:dataset:src set hive.support.quoted.identifiers=none; -- TOK_ALLCOLREF explain select * from (select a.key, a.* from (select * from src) a join (select * from src1) b on (a.key = b.key)) t; http://git-wip-us.apache.org/repos/asf/hive/blob/86b678f5/ql/src/test/queries/clientpositive/analyze_tbl_part.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/analyze_tbl_part.q b/ql/src/test/queries/clientpositive/analyze_tbl_part.q index e8010bd..7198547 100644 --- a/ql/src/test/queries/clientpositive/analyze_tbl_part.q +++ b/ql/src/test/queries/clientpositive/analyze_tbl_part.q @@ -1,3 +1,4 @@ +--! qt:dataset:src1 set hive.mapred.mode=nonstrict; create table src_stat_part(key string, value string) partitioned by (partitionId int);