spark-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From r...@apache.org
Subject [8/8] spark git commit: [SPARK-14770][SQL] Remove unused queries in hive module test resources
Date Wed, 20 Apr 2016 23:30:34 GMT
[SPARK-14770][SQL] Remove unused queries in hive module test resources

## What changes were proposed in this pull request?
We currently have five folders in queries: clientcompare, clientnegative, clientpositive, negative, and positive. Only clientpositive is used. We can remove the rest.

## How was this patch tested?
N/A - removing unused test resources.

Author: Reynold Xin <rxin@databricks.com>

Closes #12540 from rxin/SPARK-14770.


Project: http://git-wip-us.apache.org/repos/asf/spark/repo
Commit: http://git-wip-us.apache.org/repos/asf/spark/commit/b28fe448
Tree: http://git-wip-us.apache.org/repos/asf/spark/tree/b28fe448
Diff: http://git-wip-us.apache.org/repos/asf/spark/diff/b28fe448

Branch: refs/heads/master
Commit: b28fe448d91330afc84e369c548ab0a5de91e9ac
Parents: fd82681
Author: Reynold Xin <rxin@databricks.com>
Authored: Wed Apr 20 16:29:26 2016 -0700
Committer: Reynold Xin <rxin@databricks.com>
Committed: Wed Apr 20 16:29:26 2016 -0700

----------------------------------------------------------------------
 .../clientcompare/vectorized_math_funcs.q       | 43 ------------
 .../clientcompare/vectorized_math_funcs_00.qv   |  1 -
 .../clientcompare/vectorized_math_funcs_01.qv   |  1 -
 .../add_partition_with_whitelist.q              |  8 ---
 .../src/test/queries/clientnegative/addpart1.q  | 11 ---
 .../alter_concatenate_indexed_table.q           | 16 -----
 .../queries/clientnegative/alter_non_native.q   |  6 --
 .../alter_partition_coltype_2columns.q          | 11 ---
 .../alter_partition_coltype_invalidcolname.q    | 12 ----
 .../alter_partition_coltype_invalidtype.q       | 11 ---
 .../alter_partition_invalidspec.q               |  8 ---
 .../clientnegative/alter_partition_nodrop.q     |  9 ---
 .../alter_partition_nodrop_table.q              |  9 ---
 .../clientnegative/alter_partition_offline.q    | 11 ---
 .../alter_partition_with_whitelist.q            |  9 ---
 .../alter_rename_partition_failure.q            |  6 --
 .../alter_rename_partition_failure2.q           |  6 --
 .../alter_rename_partition_failure3.q           |  6 --
 .../clientnegative/alter_table_add_partition.q  |  5 --
 .../clientnegative/alter_table_wrong_regex.q    |  7 --
 .../alter_view_as_select_not_exist.q            |  4 --
 .../alter_view_as_select_with_partition.q       | 12 ----
 .../queries/clientnegative/alter_view_failure.q |  3 -
 .../clientnegative/alter_view_failure2.q        |  8 ---
 .../clientnegative/alter_view_failure3.q        |  2 -
 .../clientnegative/alter_view_failure4.q        |  8 ---
 .../clientnegative/alter_view_failure5.q        |  8 ---
 .../clientnegative/alter_view_failure6.q        | 11 ---
 .../clientnegative/alter_view_failure7.q        |  8 ---
 .../clientnegative/alter_view_failure8.q        |  3 -
 .../clientnegative/alter_view_failure9.q        |  7 --
 .../src/test/queries/clientnegative/altern1.q   |  4 --
 .../test/queries/clientnegative/ambiguous_col.q |  1 -
 .../queries/clientnegative/ambiguous_col0.q     |  2 -
 .../queries/clientnegative/ambiguous_col1.q     |  3 -
 .../queries/clientnegative/ambiguous_col2.q     |  3 -
 .../src/test/queries/clientnegative/analyze.q   |  1 -
 .../src/test/queries/clientnegative/analyze1.q  |  1 -
 .../clientnegative/analyze_non_existent_tbl.q   |  1 -
 .../test/queries/clientnegative/analyze_view.q  |  6 --
 .../src/test/queries/clientnegative/archive1.q  | 11 ---
 .../src/test/queries/clientnegative/archive2.q  | 10 ---
 .../src/test/queries/clientnegative/archive3.q  |  5 --
 .../src/test/queries/clientnegative/archive4.q  |  5 --
 .../src/test/queries/clientnegative/archive5.q  |  5 --
 .../queries/clientnegative/archive_corrupt.q    | 18 -----
 .../queries/clientnegative/archive_insert1.q    | 13 ----
 .../queries/clientnegative/archive_insert2.q    | 13 ----
 .../queries/clientnegative/archive_insert3.q    | 13 ----
 .../queries/clientnegative/archive_insert4.q    | 15 ----
 .../queries/clientnegative/archive_multi1.q     | 13 ----
 .../queries/clientnegative/archive_multi2.q     | 12 ----
 .../queries/clientnegative/archive_multi3.q     | 13 ----
 .../queries/clientnegative/archive_multi4.q     | 13 ----
 .../queries/clientnegative/archive_multi5.q     | 13 ----
 .../queries/clientnegative/archive_multi6.q     | 13 ----
 .../queries/clientnegative/archive_multi7.q     | 12 ----
 .../queries/clientnegative/archive_partspec1.q  | 10 ---
 .../queries/clientnegative/archive_partspec2.q  | 10 ---
 .../queries/clientnegative/archive_partspec3.q  | 10 ---
 .../queries/clientnegative/archive_partspec4.q  | 10 ---
 .../queries/clientnegative/archive_partspec5.q  | 10 ---
 .../clientnegative/authorization_addjar.q       |  7 --
 .../clientnegative/authorization_addpartition.q | 10 ---
 .../authorization_alter_db_owner.q              | 11 ---
 .../authorization_alter_db_owner_default.q      |  8 ---
 .../authorization_cannot_create_all_role.q      |  6 --
 .../authorization_cannot_create_default_role.q  |  6 --
 .../authorization_cannot_create_none_role.q     |  6 --
 .../authorization_caseinsensitivity.q           | 17 -----
 .../clientnegative/authorization_create_func1.q |  7 --
 .../clientnegative/authorization_create_func2.q |  8 ---
 .../authorization_create_macro1.q               |  8 ---
 .../authorization_create_role_no_admin.q        |  3 -
 .../clientnegative/authorization_createview.q   | 10 ---
 .../queries/clientnegative/authorization_ctas.q | 10 ---
 .../authorization_desc_table_nosel.q            | 14 ----
 .../queries/clientnegative/authorization_dfs.q  |  7 --
 .../authorization_disallow_transform.q          |  3 -
 .../authorization_drop_db_cascade.q             | 22 ------
 .../authorization_drop_db_empty.q               | 27 -------
 .../authorization_drop_role_no_admin.q          | 10 ---
 .../authorization_droppartition.q               | 11 ---
 .../clientnegative/authorization_fail_1.q       |  7 --
 .../clientnegative/authorization_fail_2.q       |  7 --
 .../clientnegative/authorization_fail_3.q       | 12 ----
 .../clientnegative/authorization_fail_4.q       | 15 ----
 .../clientnegative/authorization_fail_5.q       | 20 ------
 .../clientnegative/authorization_fail_6.q       |  6 --
 .../clientnegative/authorization_fail_7.q       | 17 -----
 .../authorization_fail_create_db.q              |  5 --
 .../clientnegative/authorization_fail_drop_db.q |  5 --
 .../authorization_grant_table_allpriv.q         | 14 ----
 .../authorization_grant_table_dup.q             | 16 -----
 .../authorization_grant_table_fail1.q           | 11 ---
 .../authorization_grant_table_fail_nogrant.q    | 14 ----
 .../authorization_insert_noinspriv.q            | 11 ---
 .../authorization_insert_noselectpriv.q         | 11 ---
 .../authorization_invalid_priv_v1.q             |  6 --
 .../authorization_invalid_priv_v2.q             |  5 --
 .../authorization_not_owner_alter_tab_rename.q  | 10 ---
 ...uthorization_not_owner_alter_tab_serdeprop.q | 10 ---
 .../authorization_not_owner_drop_tab.q          | 11 ---
 .../authorization_not_owner_drop_view.q         | 11 ---
 .../queries/clientnegative/authorization_part.q | 37 ----------
 .../authorization_priv_current_role_neg.q       | 29 --------
 .../authorization_public_create.q               |  1 -
 .../clientnegative/authorization_public_drop.q  |  1 -
 .../authorization_revoke_table_fail1.q          | 14 ----
 .../authorization_revoke_table_fail2.q          | 18 -----
 .../clientnegative/authorization_role_cycles1.q | 12 ----
 .../clientnegative/authorization_role_cycles2.q | 24 -------
 .../clientnegative/authorization_role_grant.q   | 22 ------
 .../authorization_rolehierarchy_privs.q         | 74 --------------------
 .../clientnegative/authorization_select.q       |  9 ---
 .../clientnegative/authorization_select_view.q  | 11 ---
 .../authorization_set_role_neg1.q               |  6 --
 .../authorization_set_role_neg2.q               | 16 -----
 .../authorization_show_parts_nosel.q            | 10 ---
 ...uthorization_show_role_principals_no_admin.q |  3 -
 .../authorization_show_role_principals_v1.q     |  2 -
 .../authorization_show_roles_no_admin.q         |  3 -
 .../clientnegative/authorization_truncate.q     |  9 ---
 .../authorization_uri_add_partition.q           | 10 ---
 .../authorization_uri_alterpart_loc.q           | 16 -----
 .../authorization_uri_altertab_setloc.q         | 13 ----
 .../authorization_uri_create_table1.q           | 11 ---
 .../authorization_uri_create_table_ext.q        | 11 ---
 .../clientnegative/authorization_uri_createdb.q | 12 ----
 .../clientnegative/authorization_uri_export.q   | 22 ------
 .../clientnegative/authorization_uri_import.q   | 25 -------
 .../clientnegative/authorization_uri_index.q    | 13 ----
 .../clientnegative/authorization_uri_insert.q   | 14 ----
 .../authorization_uri_insert_local.q            | 14 ----
 .../authorization_uri_load_data.q               | 11 ---
 .../clientnegative/authorize_create_tbl.q       | 10 ---
 .../clientnegative/authorize_grant_public.q     |  1 -
 .../clientnegative/authorize_revoke_public.q    |  1 -
 .../test/queries/clientnegative/autolocal1.q    | 15 ----
 .../queries/clientnegative/bad_exec_hooks.q     |  6 --
 .../test/queries/clientnegative/bad_indextype.q |  1 -
 .../queries/clientnegative/bad_sample_clause.q  |  6 --
 .../clientnegative/bucket_mapjoin_mismatch1.q   | 42 -----------
 .../bucket_mapjoin_wrong_table_metadata_1.q     | 20 ------
 .../bucket_mapjoin_wrong_table_metadata_2.q     | 24 -------
 .../queries/clientnegative/cachingprintstream.q |  8 ---
 .../clientnegative/cluster_tasklog_retrieval.q  |  6 --
 .../clientnegative/clusterbydistributeby.q      |  8 ---
 .../queries/clientnegative/clusterbyorderby.q   |  5 --
 .../queries/clientnegative/clusterbysortby.q    |  8 ---
 .../src/test/queries/clientnegative/clustern2.q |  3 -
 .../src/test/queries/clientnegative/clustern3.q |  2 -
 .../src/test/queries/clientnegative/clustern4.q |  2 -
 .../column_change_skewedcol_type1.q             |  5 --
 .../queries/clientnegative/column_rename1.q     |  6 --
 .../queries/clientnegative/column_rename2.q     |  6 --
 .../queries/clientnegative/column_rename3.q     |  1 -
 .../queries/clientnegative/column_rename4.q     |  6 --
 .../queries/clientnegative/column_rename5.q     |  6 --
 .../clientnegative/columnstats_partlvl_dp.q     | 16 -----
 .../columnstats_partlvl_incorrect_num_keys.q    | 16 -----
 .../columnstats_partlvl_invalid_values.q        | 16 -----
 .../columnstats_partlvl_multiple_part_clause.q  | 16 -----
 .../queries/clientnegative/columnstats_tbllvl.q | 22 ------
 .../columnstats_tbllvl_complex_type.q           | 17 -----
 .../columnstats_tbllvl_incorrect_column.q       | 22 ------
 .../clientnegative/compare_double_bigint.q      |  5 --
 .../clientnegative/compare_string_bigint.q      |  5 --
 .../queries/clientnegative/compile_processor.q  |  8 ---
 .../queries/clientnegative/compute_stats_long.q |  7 --
 .../create_function_nonexistent_class.q         |  1 -
 .../create_function_nonexistent_db.q            |  1 -
 .../create_function_nonudf_class.q              |  1 -
 .../clientnegative/create_insert_outputformat.q | 11 ---
 .../clientnegative/create_or_replace_view1.q    |  6 --
 .../clientnegative/create_or_replace_view2.q    |  6 --
 .../clientnegative/create_or_replace_view3.q    |  3 -
 .../clientnegative/create_or_replace_view4.q    |  5 --
 .../clientnegative/create_or_replace_view5.q    |  5 --
 .../clientnegative/create_or_replace_view6.q    |  5 --
 .../clientnegative/create_or_replace_view7.q    |  7 --
 .../clientnegative/create_or_replace_view8.q    |  5 --
 ...te_skewed_table_col_name_value_no_mismatch.q |  3 -
 .../create_skewed_table_dup_col_name.q          |  3 -
 ...eate_skewed_table_failure_invalid_col_name.q |  4 --
 .../clientnegative/create_table_failure1.q      |  1 -
 .../clientnegative/create_table_failure2.q      |  1 -
 .../clientnegative/create_table_failure3.q      |  1 -
 .../clientnegative/create_table_failure4.q      |  1 -
 .../clientnegative/create_table_wrong_regex.q   |  4 --
 .../clientnegative/create_udaf_failure.q        |  6 --
 .../clientnegative/create_unknown_genericudf.q  |  1 -
 .../clientnegative/create_unknown_udf_udaf.q    |  1 -
 .../clientnegative/create_view_failure1.q       |  6 --
 .../clientnegative/create_view_failure2.q       |  6 --
 .../clientnegative/create_view_failure3.q       |  5 --
 .../clientnegative/create_view_failure4.q       |  5 --
 .../clientnegative/create_view_failure5.q       |  9 ---
 .../clientnegative/create_view_failure6.q       |  6 --
 .../clientnegative/create_view_failure7.q       |  6 --
 .../clientnegative/create_view_failure8.q       |  6 --
 .../clientnegative/create_view_failure9.q       |  6 --
 .../ql/src/test/queries/clientnegative/ctas.q   |  5 --
 .../test/queries/clientnegative/cte_recursion.q |  4 --
 .../clientnegative/cte_with_in_subquery.q       |  1 -
 .../database_create_already_exists.q            |  5 --
 .../database_create_invalid_name.q              |  4 --
 .../database_drop_does_not_exist.q              |  4 --
 .../clientnegative/database_drop_not_empty.q    |  8 ---
 .../database_drop_not_empty_restrict.q          |  8 ---
 .../database_switch_does_not_exist.q            |  4 --
 .../test/queries/clientnegative/date_literal2.q |  2 -
 .../test/queries/clientnegative/date_literal3.q |  2 -
 .../queries/clientnegative/dbtxnmgr_nodblock.q  |  6 --
 .../clientnegative/dbtxnmgr_nodbunlock.q        |  6 --
 .../clientnegative/dbtxnmgr_notablelock.q       |  6 --
 .../clientnegative/dbtxnmgr_notableunlock.q     |  6 --
 .../src/test/queries/clientnegative/ddltime.q   |  6 --
 .../queries/clientnegative/decimal_precision.q  | 10 ---
 .../clientnegative/decimal_precision_1.q        | 10 ---
 .../clientnegative/default_partition_name.q     |  3 -
 .../src/test/queries/clientnegative/deletejar.q |  4 --
 .../test/queries/clientnegative/desc_failure1.q |  1 -
 .../test/queries/clientnegative/desc_failure2.q |  2 -
 .../test/queries/clientnegative/desc_failure3.q |  5 --
 .../queries/clientnegative/describe_xpath1.q    |  1 -
 .../queries/clientnegative/describe_xpath2.q    |  1 -
 .../queries/clientnegative/describe_xpath3.q    |  1 -
 .../queries/clientnegative/describe_xpath4.q    |  1 -
 .../disallow_incompatible_type_change_on1.q     | 17 -----
 .../disallow_incompatible_type_change_on2.q     |  6 --
 .../clientnegative/drop_func_nonexistent.q      |  3 -
 .../clientnegative/drop_function_failure.q      |  3 -
 .../queries/clientnegative/drop_index_failure.q |  3 -
 .../queries/clientnegative/drop_native_udf.q    |  1 -
 .../clientnegative/drop_partition_failure.q     | 11 ---
 .../drop_partition_filter_failure.q             |  8 ---
 .../clientnegative/drop_table_failure1.q        |  3 -
 .../clientnegative/drop_table_failure2.q        |  3 -
 .../clientnegative/drop_table_failure3.q        | 12 ----
 .../queries/clientnegative/drop_view_failure1.q |  6 --
 .../queries/clientnegative/drop_view_failure2.q |  3 -
 .../duplicate_alias_in_transform.q              |  1 -
 .../duplicate_alias_in_transform_schema.q       |  1 -
 .../queries/clientnegative/duplicate_insert1.q  |  7 --
 .../queries/clientnegative/duplicate_insert2.q  |  6 --
 .../queries/clientnegative/duplicate_insert3.q  |  4 --
 .../src/test/queries/clientnegative/dyn_part1.q | 11 ---
 .../src/test/queries/clientnegative/dyn_part2.q | 11 ---
 .../src/test/queries/clientnegative/dyn_part3.q |  9 ---
 .../src/test/queries/clientnegative/dyn_part4.q |  7 --
 .../clientnegative/dyn_part_empty.q.disabled    | 24 -------
 .../test/queries/clientnegative/dyn_part_max.q  | 16 -----
 .../clientnegative/dyn_part_max_per_node.q      | 15 ----
 .../dynamic_partitions_with_whitelist.q         | 17 -----
 ...xchange_partition_neg_incomplete_partition.q | 12 ----
 .../exchange_partition_neg_partition_exists.q   | 12 ----
 .../exchange_partition_neg_partition_exists2.q  | 13 ----
 .../exchange_partition_neg_partition_exists3.q  | 13 ----
 .../exchange_partition_neg_partition_missing.q  |  6 --
 .../exchange_partition_neg_table_missing.q      |  2 -
 .../exchange_partition_neg_table_missing2.q     |  8 ---
 .../exchange_partition_neg_test.q               | 11 ---
 .../clientnegative/exim_00_unsupported_schema.q | 12 ----
 .../exim_01_nonpart_over_loaded.q               | 24 -------
 .../exim_02_all_part_over_overlap.q             | 38 ----------
 .../exim_03_nonpart_noncompat_colschema.q       | 23 ------
 .../exim_04_nonpart_noncompat_colnumber.q       | 23 ------
 .../exim_05_nonpart_noncompat_coltype.q         | 23 ------
 .../exim_06_nonpart_noncompat_storage.q         | 23 ------
 .../exim_07_nonpart_noncompat_ifof.q            | 26 -------
 .../exim_08_nonpart_noncompat_serde.q           | 24 -------
 .../exim_09_nonpart_noncompat_serdeparam.q      | 28 --------
 .../exim_10_nonpart_noncompat_bucketing.q       | 24 -------
 .../exim_11_nonpart_noncompat_sorting.q         | 25 -------
 .../clientnegative/exim_12_nonnative_export.q   |  9 ---
 .../clientnegative/exim_13_nonnative_import.q   | 24 -------
 .../clientnegative/exim_14_nonpart_part.q       | 25 -------
 .../clientnegative/exim_15_part_nonpart.q       | 25 -------
 .../exim_16_part_noncompat_schema.q             | 26 -------
 .../exim_17_part_spec_underspec.q               | 30 --------
 .../clientnegative/exim_18_part_spec_missing.q  | 30 --------
 .../exim_19_external_over_existing.q            | 23 ------
 .../exim_20_managed_location_over_existing.q    | 30 --------
 .../exim_21_part_managed_external.q             | 35 ---------
 .../clientnegative/exim_22_export_authfail.q    | 14 ----
 .../exim_23_import_exist_authfail.q             | 22 ------
 .../exim_24_import_part_authfail.q              | 31 --------
 .../exim_25_import_nonexist_authfail.q          | 23 ------
 .../src/test/queries/clientnegative/external1.q |  3 -
 .../src/test/queries/clientnegative/external2.q |  4 --
 .../clientnegative/fetchtask_ioexception.q      |  7 --
 .../file_with_header_footer_negative.q          | 13 ----
 .../clientnegative/fileformat_bad_class.q       |  3 -
 .../clientnegative/fileformat_void_input.q      |  8 ---
 .../clientnegative/fileformat_void_output.q     |  6 --
 .../queries/clientnegative/fs_default_name1.q   |  2 -
 .../queries/clientnegative/fs_default_name2.q   |  2 -
 .../queries/clientnegative/genericFileFormat.q  |  1 -
 .../groupby2_map_skew_multi_distinct.q          | 14 ----
 .../clientnegative/groupby2_multi_distinct.q    | 13 ----
 .../groupby3_map_skew_multi_distinct.q          | 36 ----------
 .../clientnegative/groupby3_multi_distinct.q    | 36 ----------
 .../test/queries/clientnegative/groupby_cube1.q |  4 --
 .../test/queries/clientnegative/groupby_cube2.q |  4 --
 .../clientnegative/groupby_grouping_id1.q       |  4 --
 .../clientnegative/groupby_grouping_sets1.q     |  5 --
 .../clientnegative/groupby_grouping_sets2.q     |  4 --
 .../clientnegative/groupby_grouping_sets3.q     |  4 --
 .../clientnegative/groupby_grouping_sets4.q     |  4 --
 .../clientnegative/groupby_grouping_sets5.q     |  5 --
 .../clientnegative/groupby_grouping_sets6.q     |  8 ---
 .../clientnegative/groupby_grouping_sets7.q     | 10 ---
 .../clientnegative/groupby_invalid_position.q   |  4 --
 .../test/queries/clientnegative/groupby_key.q   |  1 -
 .../queries/clientnegative/groupby_rollup1.q    |  4 --
 .../queries/clientnegative/groupby_rollup2.q    |  4 --
 .../src/test/queries/clientnegative/having1.q   |  2 -
 .../clientnegative/illegal_partition_type.q     |  7 --
 .../clientnegative/illegal_partition_type2.q    |  3 -
 .../clientnegative/illegal_partition_type3.q    |  4 --
 .../clientnegative/illegal_partition_type4.q    |  3 -
 .../clientnegative/index_bitmap_no_map_aggr.q   |  7 --
 .../clientnegative/index_compact_entry_limit.q  | 12 ----
 .../clientnegative/index_compact_size_limit.q   | 13 ----
 .../ql/src/test/queries/clientnegative/input1.q |  1 -
 .../ql/src/test/queries/clientnegative/input2.q |  1 -
 .../ql/src/test/queries/clientnegative/input4.q |  5 --
 .../src/test/queries/clientnegative/input41.q   |  5 --
 .../queries/clientnegative/input_part0_neg.q    |  3 -
 .../test/queries/clientnegative/insert_into1.q  | 11 ---
 .../test/queries/clientnegative/insert_into2.q  | 10 ---
 .../test/queries/clientnegative/insert_into3.q  | 16 -----
 .../test/queries/clientnegative/insert_into4.q  | 16 -----
 .../test/queries/clientnegative/insert_into5.q  |  9 ---
 .../test/queries/clientnegative/insert_into6.q  | 17 -----
 .../clientnegative/insert_view_failure.q        |  5 --
 .../queries/clientnegative/insertexternal1.q    |  8 ---
 .../insertover_dynapart_ifnotexists.q           |  9 ---
 .../clientnegative/invalid_arithmetic_type.q    |  3 -
 .../queries/clientnegative/invalid_avg_syntax.q |  1 -
 .../clientnegative/invalid_cast_from_binary_1.q |  2 -
 .../clientnegative/invalid_cast_from_binary_2.q |  2 -
 .../clientnegative/invalid_cast_from_binary_3.q |  2 -
 .../clientnegative/invalid_cast_from_binary_4.q |  2 -
 .../clientnegative/invalid_cast_from_binary_5.q |  2 -
 .../clientnegative/invalid_cast_from_binary_6.q |  2 -
 .../clientnegative/invalid_cast_to_binary_1.q   |  1 -
 .../clientnegative/invalid_cast_to_binary_2.q   |  1 -
 .../clientnegative/invalid_cast_to_binary_3.q   |  1 -
 .../clientnegative/invalid_cast_to_binary_4.q   |  1 -
 .../clientnegative/invalid_cast_to_binary_5.q   |  1 -
 .../clientnegative/invalid_cast_to_binary_6.q   |  1 -
 .../clientnegative/invalid_char_length_1.q      |  2 -
 .../clientnegative/invalid_char_length_2.q      |  1 -
 .../clientnegative/invalid_char_length_3.q      |  3 -
 .../queries/clientnegative/invalid_config1.q    |  3 -
 .../queries/clientnegative/invalid_config2.q    |  4 --
 .../clientnegative/invalid_create_tbl1.q        |  9 ---
 .../clientnegative/invalid_create_tbl2.q        |  1 -
 .../queries/clientnegative/invalid_mapjoin1.q   |  1 -
 .../queries/clientnegative/invalid_max_syntax.q |  1 -
 .../queries/clientnegative/invalid_min_syntax.q |  1 -
 .../clientnegative/invalid_select_column.q      |  4 --
 .../invalid_select_column_with_subquery.q       |  4 --
 .../invalid_select_column_with_tablename.q      |  4 --
 .../clientnegative/invalid_select_expression.q  |  1 -
 .../queries/clientnegative/invalid_std_syntax.q |  1 -
 .../clientnegative/invalid_stddev_samp_syntax.q |  1 -
 .../queries/clientnegative/invalid_sum_syntax.q |  1 -
 .../queries/clientnegative/invalid_t_alter1.q   |  2 -
 .../queries/clientnegative/invalid_t_alter2.q   |  2 -
 .../queries/clientnegative/invalid_t_create2.q  |  1 -
 .../clientnegative/invalid_t_transform.q        |  1 -
 .../queries/clientnegative/invalid_tbl_name.q   |  1 -
 .../clientnegative/invalid_var_samp_syntax.q    |  1 -
 .../clientnegative/invalid_varchar_length_1.q   |  2 -
 .../clientnegative/invalid_varchar_length_2.q   |  1 -
 .../clientnegative/invalid_varchar_length_3.q   |  3 -
 .../clientnegative/invalid_variance_syntax.q    |  1 -
 .../queries/clientnegative/invalidate_view1.q   | 11 ---
 .../ql/src/test/queries/clientnegative/join2.q  |  5 --
 .../ql/src/test/queries/clientnegative/join28.q | 15 ----
 .../ql/src/test/queries/clientnegative/join29.q | 10 ---
 .../ql/src/test/queries/clientnegative/join32.q | 14 ----
 .../ql/src/test/queries/clientnegative/join35.q | 18 -----
 .../clientnegative/join_alt_syntax_comma_on.q   |  3 -
 .../clientnegative/join_cond_unqual_ambiguous.q |  6 --
 .../join_cond_unqual_ambiguous_vc.q             |  5 --
 .../clientnegative/join_nonexistent_part.q      |  4 --
 .../src/test/queries/clientnegative/joinneg.q   |  6 --
 .../queries/clientnegative/lateral_view_alias.q |  3 -
 .../queries/clientnegative/lateral_view_join.q  |  1 -
 .../queries/clientnegative/limit_partition.q    |  7 --
 .../clientnegative/limit_partition_stats.q      | 18 -----
 .../queries/clientnegative/line_terminator.q    |  3 -
 .../clientnegative/load_exist_part_authfail.q   |  4 --
 .../queries/clientnegative/load_non_native.q    |  5 --
 .../clientnegative/load_nonpart_authfail.q      |  3 -
 .../queries/clientnegative/load_part_authfail.q |  3 -
 .../queries/clientnegative/load_part_nospec.q   |  2 -
 .../clientnegative/load_stored_as_dirs.q        |  7 --
 .../queries/clientnegative/load_view_failure.q  |  3 -
 .../clientnegative/load_wrong_fileformat.q      |  6 --
 .../load_wrong_fileformat_rc_seq.q              |  6 --
 .../load_wrong_fileformat_txt_seq.q             |  6 --
 .../clientnegative/load_wrong_noof_part.q       |  3 -
 .../clientnegative/local_mapred_error_cache.q   |  4 --
 .../src/test/queries/clientnegative/lockneg1.q  | 10 ---
 .../src/test/queries/clientnegative/lockneg2.q  |  6 --
 .../src/test/queries/clientnegative/lockneg3.q  |  9 ---
 .../src/test/queries/clientnegative/lockneg4.q  | 12 ----
 .../src/test/queries/clientnegative/lockneg5.q  |  2 -
 .../lockneg_query_tbl_in_locked_db.q            | 17 -----
 .../lockneg_try_db_lock_conflict.q              |  6 --
 .../clientnegative/lockneg_try_drop_locked_db.q |  8 ---
 .../clientnegative/lockneg_try_lock_db_in_use.q | 15 ----
 .../clientnegative/macro_unused_parameter.q     |  1 -
 .../clientnegative/mapreduce_stack_trace.q      | 13 ----
 .../mapreduce_stack_trace_hadoop20.q            | 13 ----
 .../mapreduce_stack_trace_turnoff.q             | 13 ----
 .../mapreduce_stack_trace_turnoff_hadoop20.q    | 13 ----
 .../queries/clientnegative/merge_negative_1.q   |  3 -
 .../queries/clientnegative/merge_negative_2.q   |  3 -
 .../queries/clientnegative/merge_negative_3.q   |  6 --
 .../queries/clientnegative/minimr_broken_pipe.q |  4 --
 .../queries/clientnegative/nested_complex_neg.q | 15 ----
 .../queries/clientnegative/no_matching_udf.q    |  1 -
 .../queries/clientnegative/nonkey_groupby.q     |  1 -
 .../test/queries/clientnegative/nopart_insert.q |  7 --
 .../test/queries/clientnegative/nopart_load.q   |  5 --
 .../queries/clientnegative/notable_alias4.q     |  4 --
 .../clientnegative/orderby_invalid_position.q   |  4 --
 .../orderby_position_unsupported.q              |  4 --
 .../test/queries/clientnegative/orderbysortby.q |  8 ---
 .../test/queries/clientnegative/parquet_char.q  |  3 -
 .../test/queries/clientnegative/parquet_date.q  |  3 -
 .../queries/clientnegative/parquet_decimal.q    |  3 -
 .../queries/clientnegative/parquet_timestamp.q  |  3 -
 .../queries/clientnegative/parquet_varchar.q    |  3 -
 .../clientnegative/part_col_complex_type.q      |  1 -
 .../queries/clientnegative/protectmode_part.q   | 15 ----
 .../queries/clientnegative/protectmode_part1.q  | 21 ------
 .../queries/clientnegative/protectmode_part2.q  |  9 ---
 .../clientnegative/protectmode_part_no_drop.q   | 10 ---
 .../queries/clientnegative/protectmode_tbl1.q   |  8 ---
 .../queries/clientnegative/protectmode_tbl2.q   | 12 ----
 .../queries/clientnegative/protectmode_tbl3.q   | 10 ---
 .../queries/clientnegative/protectmode_tbl4.q   | 15 ----
 .../queries/clientnegative/protectmode_tbl5.q   | 15 ----
 .../queries/clientnegative/protectmode_tbl6.q   |  8 ---
 .../queries/clientnegative/protectmode_tbl7.q   | 13 ----
 .../queries/clientnegative/protectmode_tbl8.q   | 13 ----
 .../clientnegative/protectmode_tbl_no_drop.q    |  9 ---
 .../ptf_negative_AggrFuncsWithNoGBYNoPartDef.q  | 20 ------
 .../ptf_negative_AmbiguousWindowDefn.q          | 28 --------
 .../ptf_negative_DistributeByOrderBy.q          | 19 -----
 .../ptf_negative_DuplicateWindowAlias.q         | 22 ------
 ...tf_negative_HavingLeadWithNoGBYNoWindowing.q | 20 ------
 .../ptf_negative_HavingLeadWithPTF.q            | 22 ------
 .../ptf_negative_InvalidValueBoundary.q         | 21 ------
 .../ptf_negative_JoinWithAmbigousAlias.q        | 20 ------
 .../ptf_negative_PartitionBySortBy.q            | 19 -----
 .../ptf_negative_WhereWithRankCond.q            | 21 ------
 .../clientnegative/ptf_window_boundaries.q      | 17 -----
 .../clientnegative/ptf_window_boundaries2.q     | 17 -----
 .../queries/clientnegative/recursive_view.q     | 15 ----
 .../test/queries/clientnegative/regex_col_1.q   |  3 -
 .../test/queries/clientnegative/regex_col_2.q   |  3 -
 .../queries/clientnegative/regex_col_groupby.q  |  3 -
 .../test/queries/clientnegative/sa_fail_hook3.q |  4 --
 .../ql/src/test/queries/clientnegative/sample.q |  1 -
 .../clientnegative/script_broken_pipe2.q        |  3 -
 .../clientnegative/script_broken_pipe3.q        |  3 -
 .../test/queries/clientnegative/script_error.q  |  7 --
 .../queries/clientnegative/select_charliteral.q |  3 -
 .../queries/clientnegative/select_udtf_alias.q  |  3 -
 .../src/test/queries/clientnegative/semijoin1.q |  2 -
 .../src/test/queries/clientnegative/semijoin2.q |  2 -
 .../src/test/queries/clientnegative/semijoin3.q |  2 -
 .../src/test/queries/clientnegative/semijoin4.q |  3 -
 .../test/queries/clientnegative/serde_regex.q   | 17 -----
 .../test/queries/clientnegative/serde_regex2.q  | 23 ------
 .../test/queries/clientnegative/serde_regex3.q  | 14 ----
 .../clientnegative/set_hiveconf_validation0.q   |  5 --
 .../clientnegative/set_hiveconf_validation1.q   |  5 --
 .../clientnegative/set_hiveconf_validation2.q   |  5 --
 .../queries/clientnegative/set_table_property.q |  4 --
 .../test/queries/clientnegative/show_columns1.q |  2 -
 .../test/queries/clientnegative/show_columns2.q |  2 -
 .../test/queries/clientnegative/show_columns3.q |  7 --
 .../show_create_table_does_not_exist.q          |  2 -
 .../clientnegative/show_create_table_index.q    |  6 --
 .../queries/clientnegative/show_partitions1.q   |  1 -
 .../clientnegative/show_tableproperties1.q      |  1 -
 .../queries/clientnegative/show_tables_bad1.q   |  1 -
 .../queries/clientnegative/show_tables_bad2.q   |  1 -
 .../clientnegative/show_tables_bad_db1.q        |  1 -
 .../clientnegative/show_tables_bad_db2.q        |  1 -
 .../queries/clientnegative/show_tablestatus.q   |  1 -
 .../show_tablestatus_not_existing_part.q        |  1 -
 .../queries/clientnegative/smb_bucketmapjoin.q  | 23 ------
 .../queries/clientnegative/smb_mapjoin_14.q     | 38 ----------
 .../sortmerge_mapjoin_mismatch_1.q              | 28 --------
 .../clientnegative/split_sample_out_of_range.q  |  3 -
 .../clientnegative/split_sample_wrong_format.q  |  3 -
 .../clientnegative/split_sample_wrong_format2.q |  3 -
 .../clientnegative/stats_aggregator_error_1.q   | 18 -----
 .../clientnegative/stats_aggregator_error_2.q   | 16 -----
 .../clientnegative/stats_noscan_non_native.q    |  6 --
 .../stats_partialscan_autogether.q              | 31 --------
 .../stats_partialscan_non_external.q            |  5 --
 .../stats_partialscan_non_native.q              |  6 --
 .../clientnegative/stats_partscan_norcfile.q    | 12 ----
 .../clientnegative/stats_publisher_error_1.q    | 18 -----
 .../clientnegative/stats_publisher_error_2.q    | 16 -----
 .../test/queries/clientnegative/strict_join.q   |  3 -
 .../queries/clientnegative/strict_orderby.q     |  7 --
 .../queries/clientnegative/strict_pruning.q     |  6 --
 .../test/queries/clientnegative/subq_insert.q   |  2 -
 .../subquery_exists_implicit_gby.q              | 10 ---
 .../clientnegative/subquery_in_groupby.q        |  5 --
 .../queries/clientnegative/subquery_in_select.q |  6 --
 .../subquery_multiple_cols_in_select.q          |  7 --
 .../clientnegative/subquery_nested_subquery.q   | 18 -----
 .../subquery_notexists_implicit_gby.q           | 10 ---
 .../clientnegative/subquery_shared_alias.q      |  6 --
 .../clientnegative/subquery_subquery_chain.q    |  6 --
 .../clientnegative/subquery_unqual_corr_expr.q  |  6 --
 .../clientnegative/subquery_windowing_corr.q    | 26 -------
 .../clientnegative/subquery_with_or_cond.q      |  5 --
 .../ql/src/test/queries/clientnegative/touch1.q |  1 -
 .../ql/src/test/queries/clientnegative/touch2.q |  1 -
 .../clientnegative/truncate_bucketed_column.q   |  7 --
 .../truncate_column_indexed_table.q             |  9 ---
 .../truncate_column_list_bucketing.q            | 14 ----
 .../clientnegative/truncate_column_seqfile.q    |  7 --
 .../truncate_nonexistant_column.q               |  7 --
 .../clientnegative/truncate_partition_column.q  |  7 --
 .../clientnegative/truncate_partition_column2.q |  7 --
 .../clientnegative/truncate_table_failure1.q    |  2 -
 .../clientnegative/truncate_table_failure2.q    |  2 -
 .../clientnegative/truncate_table_failure3.q    |  4 --
 .../clientnegative/truncate_table_failure4.q    |  5 --
 .../queries/clientnegative/udaf_invalid_place.q |  1 -
 .../clientnegative/udf_array_contains_wrong1.q  |  2 -
 .../clientnegative/udf_array_contains_wrong2.q  |  2 -
 .../queries/clientnegative/udf_assert_true.q    |  7 --
 .../queries/clientnegative/udf_assert_true2.q   |  2 -
 .../test/queries/clientnegative/udf_coalesce.q  |  1 -
 .../clientnegative/udf_concat_ws_wrong1.q       |  2 -
 .../clientnegative/udf_concat_ws_wrong2.q       |  2 -
 .../clientnegative/udf_concat_ws_wrong3.q       |  2 -
 .../clientnegative/udf_elt_wrong_args_len.q     |  1 -
 .../queries/clientnegative/udf_elt_wrong_type.q |  3 -
 .../clientnegative/udf_field_wrong_args_len.q   |  1 -
 .../clientnegative/udf_field_wrong_type.q       |  3 -
 .../clientnegative/udf_format_number_wrong1.q   |  2 -
 .../clientnegative/udf_format_number_wrong2.q   |  2 -
 .../clientnegative/udf_format_number_wrong3.q   |  2 -
 .../clientnegative/udf_format_number_wrong4.q   |  2 -
 .../clientnegative/udf_format_number_wrong5.q   |  2 -
 .../clientnegative/udf_format_number_wrong6.q   |  2 -
 .../clientnegative/udf_format_number_wrong7.q   |  2 -
 .../udf_function_does_not_implement_udf.q       |  1 -
 .../queries/clientnegative/udf_if_not_bool.q    |  1 -
 .../clientnegative/udf_if_wrong_args_len.q      |  1 -
 .../ql/src/test/queries/clientnegative/udf_in.q |  1 -
 .../clientnegative/udf_instr_wrong_args_len.q   |  1 -
 .../clientnegative/udf_instr_wrong_type.q       |  3 -
 .../test/queries/clientnegative/udf_invalid.q   |  1 -
 .../queries/clientnegative/udf_local_resource.q |  1 -
 .../clientnegative/udf_locate_wrong_args_len.q  |  1 -
 .../clientnegative/udf_locate_wrong_type.q      |  3 -
 .../clientnegative/udf_map_keys_arg_num.q       |  1 -
 .../clientnegative/udf_map_keys_arg_type.q      |  1 -
 .../clientnegative/udf_map_values_arg_num.q     |  1 -
 .../clientnegative/udf_map_values_arg_type.q    |  1 -
 .../src/test/queries/clientnegative/udf_max.q   |  2 -
 .../src/test/queries/clientnegative/udf_min.q   |  2 -
 .../clientnegative/udf_nonexistent_resource.q   |  1 -
 .../queries/clientnegative/udf_printf_wrong1.q  |  2 -
 .../queries/clientnegative/udf_printf_wrong2.q  |  2 -
 .../queries/clientnegative/udf_printf_wrong3.q  |  2 -
 .../queries/clientnegative/udf_printf_wrong4.q  |  2 -
 .../queries/clientnegative/udf_qualified_name.q |  1 -
 .../queries/clientnegative/udf_reflect_neg.q    |  9 ---
 .../clientnegative/udf_size_wrong_args_len.q    |  5 --
 .../clientnegative/udf_size_wrong_type.q        |  1 -
 .../clientnegative/udf_sort_array_wrong1.q      |  2 -
 .../clientnegative/udf_sort_array_wrong2.q      |  2 -
 .../clientnegative/udf_sort_array_wrong3.q      |  2 -
 .../queries/clientnegative/udf_test_error.q     |  3 -
 .../clientnegative/udf_test_error_reduce.q      | 11 ---
 .../clientnegative/udf_when_type_wrong.q        |  6 --
 .../udtf_explode_not_supported1.q               |  1 -
 .../udtf_explode_not_supported2.q               |  1 -
 .../udtf_explode_not_supported3.q               |  1 -
 .../udtf_explode_not_supported4.q               |  1 -
 .../queries/clientnegative/udtf_invalid_place.q |  1 -
 .../clientnegative/udtf_not_supported1.q        |  1 -
 .../clientnegative/udtf_not_supported3.q        |  1 -
 .../ql/src/test/queries/clientnegative/union2.q | 13 ----
 .../src/test/queries/clientnegative/union22.q   | 26 -------
 .../ql/src/test/queries/clientnegative/union3.q |  5 --
 .../test/queries/clientnegative/uniquejoin.q    |  3 -
 .../test/queries/clientnegative/uniquejoin2.q   |  3 -
 .../test/queries/clientnegative/uniquejoin3.q   |  3 -
 .../clientnegative/unset_table_property.q       |  6 --
 .../clientnegative/unset_view_property.q        |  6 --
 .../clientnegative/windowing_invalid_udaf.q     |  1 -
 .../clientnegative/windowing_leadlag_in_udaf.q  | 15 ----
 .../clientnegative/windowing_ll_no_neg.q        | 26 -------
 .../clientnegative/windowing_ll_no_over.q       | 17 -----
 .../queries/clientnegative/wrong_column_type.q  |  4 --
 .../test/queries/negative/ambiguous_join_col.q  |  2 -
 .../src/test/queries/negative/duplicate_alias.q |  2 -
 .../ql/src/test/queries/negative/garbage.q      |  1 -
 .../negative/insert_wrong_number_columns.q      |  2 -
 .../queries/negative/invalid_create_table.q     |  4 --
 .../ql/src/test/queries/negative/invalid_dot.q  |  2 -
 .../queries/negative/invalid_function_param2.q  |  2 -
 .../src/test/queries/negative/invalid_index.q   |  2 -
 .../test/queries/negative/invalid_list_index.q  |  2 -
 .../test/queries/negative/invalid_list_index2.q |  2 -
 .../test/queries/negative/invalid_map_index.q   |  2 -
 .../test/queries/negative/invalid_map_index2.q  |  2 -
 .../src/test/queries/negative/invalid_select.q  |  4 --
 .../test/queries/negative/macro_reserved_word.q |  1 -
 .../test/queries/negative/missing_overwrite.q   |  2 -
 .../src/test/queries/negative/nonkey_groupby.q  |  2 -
 .../src/test/queries/negative/quoted_string.q   |  2 -
 .../src/test/queries/negative/unknown_column1.q |  2 -
 .../src/test/queries/negative/unknown_column2.q |  2 -
 .../src/test/queries/negative/unknown_column3.q |  2 -
 .../src/test/queries/negative/unknown_column4.q |  2 -
 .../src/test/queries/negative/unknown_column5.q |  2 -
 .../src/test/queries/negative/unknown_column6.q |  2 -
 .../test/queries/negative/unknown_function1.q   |  2 -
 .../test/queries/negative/unknown_function2.q   |  2 -
 .../test/queries/negative/unknown_function3.q   |  2 -
 .../test/queries/negative/unknown_function4.q   |  2 -
 .../src/test/queries/negative/unknown_table1.q  |  2 -
 .../src/test/queries/negative/unknown_table2.q  |  2 -
 .../src/test/queries/negative/wrong_distinct1.q |  2 -
 .../src/test/queries/negative/wrong_distinct2.q |  2 -
 .../test/queries/positive/case_sensitivity.q    |  2 -
 .../ql/src/test/queries/positive/cast1.q        |  2 -
 .../ql/src/test/queries/positive/groupby1.q     |  2 -
 .../ql/src/test/queries/positive/groupby2.q     |  2 -
 .../ql/src/test/queries/positive/groupby3.q     |  2 -
 .../ql/src/test/queries/positive/groupby4.q     |  2 -
 .../ql/src/test/queries/positive/groupby5.q     |  4 --
 .../ql/src/test/queries/positive/groupby6.q     |  2 -
 .../ql/src/test/queries/positive/input1.q       |  2 -
 .../ql/src/test/queries/positive/input2.q       |  4 --
 .../ql/src/test/queries/positive/input20.q      |  9 ---
 .../ql/src/test/queries/positive/input3.q       |  5 --
 .../ql/src/test/queries/positive/input4.q       |  7 --
 .../ql/src/test/queries/positive/input5.q       |  7 --
 .../ql/src/test/queries/positive/input6.q       |  2 -
 .../ql/src/test/queries/positive/input7.q       |  2 -
 .../ql/src/test/queries/positive/input8.q       |  2 -
 .../ql/src/test/queries/positive/input9.q       |  2 -
 .../ql/src/test/queries/positive/input_part1.q  |  2 -
 .../queries/positive/input_testsequencefile.q   |  2 -
 .../src/test/queries/positive/input_testxpath.q |  2 -
 .../test/queries/positive/input_testxpath2.q    |  2 -
 .../ql/src/test/queries/positive/join1.q        |  3 -
 .../ql/src/test/queries/positive/join2.q        |  3 -
 .../ql/src/test/queries/positive/join3.q        |  4 --
 .../ql/src/test/queries/positive/join4.q        | 14 ----
 .../ql/src/test/queries/positive/join5.q        | 15 ----
 .../ql/src/test/queries/positive/join6.q        | 16 -----
 .../ql/src/test/queries/positive/join7.q        | 21 ------
 .../ql/src/test/queries/positive/join8.q        | 14 ----
 .../ql/src/test/queries/positive/sample1.q      |  5 --
 .../ql/src/test/queries/positive/sample2.q      |  4 --
 .../ql/src/test/queries/positive/sample3.q      |  4 --
 .../ql/src/test/queries/positive/sample4.q      |  4 --
 .../ql/src/test/queries/positive/sample5.q      |  3 -
 .../ql/src/test/queries/positive/sample6.q      |  3 -
 .../ql/src/test/queries/positive/sample7.q      |  4 --
 .../ql/src/test/queries/positive/subq.q         |  4 --
 .../ql/src/test/queries/positive/udf1.q         |  5 --
 .../ql/src/test/queries/positive/udf4.q         |  1 -
 .../ql/src/test/queries/positive/udf6.q         |  1 -
 .../ql/src/test/queries/positive/udf_case.q     | 10 ---
 .../ql/src/test/queries/positive/udf_when.q     | 10 ---
 .../ql/src/test/queries/positive/union.q        |  6 --
 690 files changed, 5352 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientcompare/vectorized_math_funcs.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientcompare/vectorized_math_funcs.q b/sql/hive/src/test/resources/ql/src/test/queries/clientcompare/vectorized_math_funcs.q
deleted file mode 100644
index c640ca1..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientcompare/vectorized_math_funcs.q
+++ /dev/null
@@ -1,43 +0,0 @@
-
-select
-   cdouble
-  ,Round(cdouble, 2)
-  ,Floor(cdouble)
-  ,Ceil(cdouble)
-  ,Rand(98007) as rnd
-  ,Exp(ln(cdouble))
-  ,Ln(cdouble)  
-  ,Ln(cfloat)
-  ,Log10(cdouble)
-  -- Use log2 as a representative function to test all input types.
-  ,Log2(cdouble)
-  ,Log2(cfloat)
-  ,Log2(cbigint)
-  ,Log2(cint)
-  ,Log2(csmallint)
-  ,Log2(ctinyint)
-  ,Log(2.0, cdouble)
-  ,Pow(log2(cdouble), 2.0)  
-  ,Power(log2(cdouble), 2.0)
-  ,Sqrt(cdouble)
-  ,Sqrt(cbigint)
-  ,Bin(cbigint)
-  ,Hex(cdouble)
-  ,Conv(cbigint, 10, 16)
-  ,Abs(cdouble)
-  ,Abs(ctinyint)
-  ,Pmod(cint, 3)
-  ,Sin(cdouble)
-  ,Asin(cdouble)
-  ,Cos(cdouble)
-  ,ACos(cdouble)
-  ,Atan(cdouble)
-  ,Degrees(cdouble)
-  ,Radians(cdouble)
-  ,Positive(cdouble)
-  ,Positive(cbigint)
-  ,Negative(cdouble)
-  ,Sign(cdouble)
-  ,Sign(cbigint)
-from alltypesorc order by rnd limit 400;
-

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientcompare/vectorized_math_funcs_00.qv
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientcompare/vectorized_math_funcs_00.qv b/sql/hive/src/test/resources/ql/src/test/queries/clientcompare/vectorized_math_funcs_00.qv
deleted file mode 100644
index 51f2310..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientcompare/vectorized_math_funcs_00.qv
+++ /dev/null
@@ -1 +0,0 @@
-SET hive.vectorized.execution.enabled = false;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientcompare/vectorized_math_funcs_01.qv
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientcompare/vectorized_math_funcs_01.qv b/sql/hive/src/test/resources/ql/src/test/queries/clientcompare/vectorized_math_funcs_01.qv
deleted file mode 100644
index 18e02dc..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientcompare/vectorized_math_funcs_01.qv
+++ /dev/null
@@ -1 +0,0 @@
-SET hive.vectorized.execution.enabled = true;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/add_partition_with_whitelist.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/add_partition_with_whitelist.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/add_partition_with_whitelist.q
deleted file mode 100644
index 8f0a60b..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/add_partition_with_whitelist.q
+++ /dev/null
@@ -1,8 +0,0 @@
-SET hive.metastore.partition.name.whitelist.pattern=[\\x20-\\x7E&&[^,]]* ;
--- This pattern matches all printable ASCII characters (disallow unicode) and disallows commas
-
-CREATE TABLE part_whitelist_test (key STRING, value STRING) PARTITIONED BY (ds STRING);
-SHOW PARTITIONS part_whitelist_test;
-
-ALTER TABLE part_whitelist_test ADD PARTITION (ds='1,2,3,4');
-

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/addpart1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/addpart1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/addpart1.q
deleted file mode 100644
index a7c9fe9..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/addpart1.q
+++ /dev/null
@@ -1,11 +0,0 @@
-
-create table addpart1 (a int) partitioned by (b string, c string);
-
-alter table addpart1 add partition (b='f', c='s');
-
-show partitions addpart1;
-
-alter table addpart1 add partition (b='f', c='');
-
-show prtitions addpart1;
-

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_concatenate_indexed_table.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_concatenate_indexed_table.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_concatenate_indexed_table.q
deleted file mode 100644
index 4193315..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_concatenate_indexed_table.q
+++ /dev/null
@@ -1,16 +0,0 @@
-set hive.exec.concatenate.check.index=true;
-create table src_rc_concatenate_test(key int, value string) stored as rcfile;
-
-load data local inpath '../../data/files/smbbucket_1.rc' into table src_rc_concatenate_test;
-load data local inpath '../../data/files/smbbucket_2.rc' into table src_rc_concatenate_test;
-load data local inpath '../../data/files/smbbucket_3.rc' into table src_rc_concatenate_test;
-
-show table extended like `src_rc_concatenate_test`;
-
-select count(1) from src_rc_concatenate_test;
-select sum(hash(key)), sum(hash(value)) from src_rc_concatenate_test;
-
-create index src_rc_concatenate_test_index on table src_rc_concatenate_test(key) as 'compact' WITH DEFERRED REBUILD IDXPROPERTIES ("prop1"="val1", "prop2"="val2"); 
-show indexes on src_rc_concatenate_test;
-
-alter table src_rc_concatenate_test concatenate;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_non_native.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_non_native.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_non_native.q
deleted file mode 100644
index 73ae853..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_non_native.q
+++ /dev/null
@@ -1,6 +0,0 @@
-
-CREATE TABLE non_native1(key int, value string) 
-STORED BY 'org.apache.hadoop.hive.ql.metadata.DefaultStorageHandler';
-
--- we do not support ALTER TABLE on non-native tables yet
-ALTER TABLE non_native1 RENAME TO new_non_native;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_partition_coltype_2columns.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_partition_coltype_2columns.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_partition_coltype_2columns.q
deleted file mode 100644
index e10f77c..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_partition_coltype_2columns.q
+++ /dev/null
@@ -1,11 +0,0 @@
--- create testing table
-create table alter_coltype(key string, value string) partitioned by (dt string, ts string);
-
--- insert and create a partition
-insert overwrite table alter_coltype partition(dt='100x', ts='6:30pm') select * from src1;
-
-desc alter_coltype;
-
--- alter partition change multiple keys at same time 
-alter table alter_coltype partition column (dt int, ts int);
-

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_partition_coltype_invalidcolname.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_partition_coltype_invalidcolname.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_partition_coltype_invalidcolname.q
deleted file mode 100644
index 66eba75..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_partition_coltype_invalidcolname.q
+++ /dev/null
@@ -1,12 +0,0 @@
--- create testing table
-create table alter_coltype(key string, value string) partitioned by (dt string, ts string);
-
--- insert and create a partition
-insert overwrite table alter_coltype partition(dt='100x', ts='6:30pm') select * from src1;
-
-desc alter_coltype;
-
--- alter partition key column with invalid column name
-alter table alter_coltype partition column (dd int);
-
-

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_partition_coltype_invalidtype.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_partition_coltype_invalidtype.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_partition_coltype_invalidtype.q
deleted file mode 100644
index ad016c5..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_partition_coltype_invalidtype.q
+++ /dev/null
@@ -1,11 +0,0 @@
--- create testing table
-create table alter_coltype(key string, value string) partitioned by (dt string, ts string);
-
--- insert and create a partition
-insert overwrite table alter_coltype partition(dt='100x', ts='6:30pm') select * from src1;
-
-desc alter_coltype;
-
--- alter partition key column data type for ts column to a wrong type
-alter table alter_coltype partition column (ts time);
-

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_partition_invalidspec.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_partition_invalidspec.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_partition_invalidspec.q
deleted file mode 100644
index 8cbb25c..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_partition_invalidspec.q
+++ /dev/null
@@ -1,8 +0,0 @@
--- Create table
-create table if not exists alter_part_invalidspec(key string, value string ) partitioned by (year string, month string) stored as textfile ;
-
--- Load data
-load data local inpath '../../data/files/T1.txt' overwrite into table alter_part_invalidspec partition (year='1996', month='10');
-load data local inpath '../../data/files/T1.txt' overwrite into table alter_part_invalidspec partition (year='1996', month='12');
-
-alter table alter_part_invalidspec partition (year='1997') enable no_drop;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_partition_nodrop.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_partition_nodrop.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_partition_nodrop.q
deleted file mode 100644
index 3c0ff02..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_partition_nodrop.q
+++ /dev/null
@@ -1,9 +0,0 @@
--- Create table
-create table if not exists alter_part_nodrop_part(key string, value string ) partitioned by (year string, month string) stored as textfile ;
-
--- Load data
-load data local inpath '../../data/files/T1.txt' overwrite into table alter_part_nodrop_part partition (year='1996', month='10');
-load data local inpath '../../data/files/T1.txt' overwrite into table alter_part_nodrop_part partition (year='1996', month='12');
-
-alter table alter_part_nodrop_part partition (year='1996') enable no_drop;
-alter table alter_part_nodrop_part drop partition (year='1996');

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_partition_nodrop_table.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_partition_nodrop_table.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_partition_nodrop_table.q
deleted file mode 100644
index f2135b1..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_partition_nodrop_table.q
+++ /dev/null
@@ -1,9 +0,0 @@
--- Create table
-create table if not exists alter_part_nodrop_table(key string, value string ) partitioned by (year string, month string) stored as textfile ;
-
--- Load data
-load data local inpath '../../data/files/T1.txt' overwrite into table alter_part_nodrop_table partition (year='1996', month='10');
-load data local inpath '../../data/files/T1.txt' overwrite into table alter_part_nodrop_table partition (year='1996', month='12');
-
-alter table alter_part_nodrop_table partition (year='1996') enable no_drop;
-drop table alter_part_nodrop_table;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_partition_offline.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_partition_offline.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_partition_offline.q
deleted file mode 100644
index 7376d8b..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_partition_offline.q
+++ /dev/null
@@ -1,11 +0,0 @@
--- create table
-create table if not exists alter_part_offline (key string, value string ) partitioned by (year string, month string) stored as textfile ;
-
--- Load data
-load data local inpath '../../data/files/T1.txt' overwrite into table alter_part_offline partition (year='1996', month='10');
-load data local inpath '../../data/files/T1.txt' overwrite into table alter_part_offline partition (year='1996', month='12');
-
-alter table alter_part_offline partition (year='1996') disable offline;
-select * from alter_part_offline where year = '1996';
-alter table alter_part_offline partition (year='1996') enable offline;
-select * from alter_part_offline where year = '1996';

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_partition_with_whitelist.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_partition_with_whitelist.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_partition_with_whitelist.q
deleted file mode 100644
index 6e33bc0..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_partition_with_whitelist.q
+++ /dev/null
@@ -1,9 +0,0 @@
-SET hive.metastore.partition.name.whitelist.pattern=[\\x20-\\x7E&&[^,]]* ;
--- This pattern matches all printable ASCII characters (disallow unicode) and disallows commas
-
-CREATE TABLE part_whitelist_test (key STRING, value STRING) PARTITIONED BY (ds STRING);
-SHOW PARTITIONS part_whitelist_test;
-
-ALTER TABLE part_whitelist_test ADD PARTITION (ds='1');
-
-ALTER TABLE part_whitelist_test PARTITION (ds='1') rename to partition (ds='1,2,3');

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_rename_partition_failure.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_rename_partition_failure.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_rename_partition_failure.q
deleted file mode 100644
index be971f1..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_rename_partition_failure.q
+++ /dev/null
@@ -1,6 +0,0 @@
-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 ;
-create table alter_rename_partition ( col1 string ) partitioned by (pcol1 string , pcol2 string) stored as sequencefile;
-insert overwrite table alter_rename_partition partition (pCol1='old_part1:', pcol2='old_part2:') select col1 from alter_rename_partition_src ;
-
-alter table alter_rename_partition partition (pCol1='nonexist_part1:', pcol2='nonexist_part2:') rename to partition (pCol1='new_part1:', pcol2='new_part2:');

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_rename_partition_failure2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_rename_partition_failure2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_rename_partition_failure2.q
deleted file mode 100644
index 4babdda..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_rename_partition_failure2.q
+++ /dev/null
@@ -1,6 +0,0 @@
-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 ;
-create table alter_rename_partition ( col1 string ) partitioned by (pcol1 string , pcol2 string) stored as sequencefile;
-insert overwrite table alter_rename_partition partition (pCol1='old_part1:', pcol2='old_part2:') select col1 from alter_rename_partition_src ;
-
-alter table alter_rename_partition partition (pCol1='old_part1:', pcol2='old_part2:') rename to partition (pCol1='old_part1:', pcol2='old_part2:');

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_rename_partition_failure3.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_rename_partition_failure3.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_rename_partition_failure3.q
deleted file mode 100644
index 3af807e..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_rename_partition_failure3.q
+++ /dev/null
@@ -1,6 +0,0 @@
-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 ;
-create table alter_rename_partition ( col1 string ) partitioned by (pcol1 string , pcol2 string) stored as sequencefile;
-insert overwrite table alter_rename_partition partition (pCol1='old_part1:', pcol2='old_part2:') select col1 from alter_rename_partition_src ;
-
-alter table alter_rename_partition partition (pCol1='old_part1:', pcol2='old_part2:') rename to partition (pCol1='old_part1:', pcol2='old_part2:', pcol3='old_part3:');
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_table_add_partition.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_table_add_partition.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_table_add_partition.q
deleted file mode 100644
index 2427c3b..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_table_add_partition.q
+++ /dev/null
@@ -1,5 +0,0 @@
-create table mp (a int) partitioned by (b int);
-
--- should fail
-alter table mp add partition (b='1', c='1');
-

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_table_wrong_regex.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_table_wrong_regex.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_table_wrong_regex.q
deleted file mode 100644
index fad194d..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_table_wrong_regex.q
+++ /dev/null
@@ -1,7 +0,0 @@
-drop table aa;
-create table aa ( test STRING )
-  ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.RegexSerDe'
-  WITH SERDEPROPERTIES ("input.regex" = "(.*)", "output.format.string" = "$1s");
-  
-alter table aa set serdeproperties ("input.regex" = "[^\\](.*)", "output.format.string" = "$1s");
-

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_as_select_not_exist.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_as_select_not_exist.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_as_select_not_exist.q
deleted file mode 100644
index 30fe4d9..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_as_select_not_exist.q
+++ /dev/null
@@ -1,4 +0,0 @@
-DROP VIEW testView;
-
--- Cannot ALTER VIEW AS SELECT if view currently does not exist
-ALTER VIEW testView AS SELECT * FROM srcpart;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_as_select_with_partition.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_as_select_with_partition.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_as_select_with_partition.q
deleted file mode 100644
index dca6770..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_as_select_with_partition.q
+++ /dev/null
@@ -1,12 +0,0 @@
-CREATE VIEW testViewPart PARTITIONED ON (value)
-AS
-SELECT key, value
-FROM src
-WHERE key=86;
-
-ALTER VIEW testViewPart 
-ADD PARTITION (value='val_86') PARTITION (value='val_xyz'); 
-DESCRIBE FORMATTED testViewPart;
-
--- If a view has partition, could not replace it with ALTER VIEW AS SELECT
-ALTER VIEW testViewPart as SELECT * FROM srcpart;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_failure.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_failure.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_failure.q
deleted file mode 100644
index 705b985..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_failure.q
+++ /dev/null
@@ -1,3 +0,0 @@
-DROP VIEW xxx3;
-CREATE VIEW xxx3 AS SELECT * FROM src;
-ALTER TABLE xxx3 REPLACE COLUMNS (xyz int);

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_failure2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_failure2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_failure2.q
deleted file mode 100644
index 26d2c4f..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_failure2.q
+++ /dev/null
@@ -1,8 +0,0 @@
-DROP VIEW xxx4;
-CREATE VIEW xxx4 
-PARTITIONED ON (value)
-AS 
-SELECT * FROM src;
-
--- should fail:  need to use ALTER VIEW, not ALTER TABLE
-ALTER TABLE xxx4 ADD PARTITION (value='val_86');

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_failure3.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_failure3.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_failure3.q
deleted file mode 100644
index 49c17a8..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_failure3.q
+++ /dev/null
@@ -1,2 +0,0 @@
--- should fail:  can't use ALTER VIEW on a table
-ALTER VIEW srcpart ADD PARTITION (ds='2012-12-31', hr='23');

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_failure4.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_failure4.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_failure4.q
deleted file mode 100644
index e2fad27..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_failure4.q
+++ /dev/null
@@ -1,8 +0,0 @@
-DROP VIEW xxx5;
-CREATE VIEW xxx5
-PARTITIONED ON (value)
-AS 
-SELECT * FROM src;
-
--- should fail:  LOCATION clause is illegal
-ALTER VIEW xxx5 ADD PARTITION (value='val_86') LOCATION '/foo/bar/baz';

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_failure5.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_failure5.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_failure5.q
deleted file mode 100644
index e44766e..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_failure5.q
+++ /dev/null
@@ -1,8 +0,0 @@
-DROP VIEW xxx6;
-CREATE VIEW xxx6
-PARTITIONED ON (value)
-AS 
-SELECT * FROM src;
-
--- should fail:  partition column name does not match
-ALTER VIEW xxx6 ADD PARTITION (v='val_86');

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_failure6.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_failure6.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_failure6.q
deleted file mode 100644
index dab7b14..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_failure6.q
+++ /dev/null
@@ -1,11 +0,0 @@
-DROP VIEW xxx7;
-CREATE VIEW xxx7
-PARTITIONED ON (key)
-AS 
-SELECT hr,key FROM srcpart;
-
-SET hive.mapred.mode=strict;
-
--- strict mode should cause this to fail since view partition
--- predicate does not correspond to an underlying table partition predicate
-ALTER VIEW xxx7 ADD PARTITION (key=10);

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_failure7.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_failure7.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_failure7.q
deleted file mode 100644
index eff04c5..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_failure7.q
+++ /dev/null
@@ -1,8 +0,0 @@
-DROP VIEW xxx8;
-CREATE VIEW xxx8
-PARTITIONED ON (ds,hr)
-AS 
-SELECT key,ds,hr FROM srcpart;
-
--- should fail:  need to fill in all partition columns
-ALTER VIEW xxx8 ADD PARTITION (ds='2011-01-01');

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_failure8.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_failure8.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_failure8.q
deleted file mode 100644
index 9dff784..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_failure8.q
+++ /dev/null
@@ -1,3 +0,0 @@
--- should fail:  can't use ALTER VIEW on a table
-CREATE TABLE invites (foo INT, bar STRING) PARTITIONED BY (ds STRING);
-ALTER VIEW invites RENAME TO invites2;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_failure9.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_failure9.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_failure9.q
deleted file mode 100644
index 0f40fad..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/alter_view_failure9.q
+++ /dev/null
@@ -1,7 +0,0 @@
-DROP VIEW xxx4;
-CREATE VIEW xxx4 
-AS 
-SELECT * FROM src;
-
--- should fail:  need to use ALTER VIEW, not ALTER TABLE
-ALTER TABLE xxx4 RENAME TO xxx4a;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/altern1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/altern1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/altern1.q
deleted file mode 100644
index 60414c1..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/altern1.q
+++ /dev/null
@@ -1,4 +0,0 @@
-
-create table altern1(a int, b int) partitioned by (ds string);
-alter table altern1 replace columns(a int, b int, ds string);
-

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/ambiguous_col.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/ambiguous_col.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/ambiguous_col.q
deleted file mode 100644
index 866cec1..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/ambiguous_col.q
+++ /dev/null
@@ -1 +0,0 @@
-FROM (SELECT key, concat(value) AS key FROM src) a SELECT a.key;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/ambiguous_col0.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/ambiguous_col0.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/ambiguous_col0.q
deleted file mode 100644
index 46349c6..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/ambiguous_col0.q
+++ /dev/null
@@ -1,2 +0,0 @@
--- TOK_ALLCOLREF
-explain select * from (select * from (select * from src) a join (select * from src1) b on (a.key = b.key)) t;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/ambiguous_col1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/ambiguous_col1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/ambiguous_col1.q
deleted file mode 100644
index 9e8bcbd..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/ambiguous_col1.q
+++ /dev/null
@@ -1,3 +0,0 @@
-set hive.support.quoted.identifiers=none;
--- TOK_TABLE_OR_COL
-explain select * from (select `.*` from (select * from src) a join (select * from src1) b on (a.key = b.key)) t;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/ambiguous_col2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/ambiguous_col2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/ambiguous_col2.q
deleted file mode 100644
index 33d4aed..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/ambiguous_col2.q
+++ /dev/null
@@ -1,3 +0,0 @@
-set hive.support.quoted.identifiers=none;
--- DOT
-explain select * from (select a.`[kv].*`, b.`[kv].*` from (select * from src) a join (select * from src1) b on (a.key = b.key)) t;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/analyze.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/analyze.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/analyze.q
deleted file mode 100644
index 874f5bf..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/analyze.q
+++ /dev/null
@@ -1 +0,0 @@
-analyze table srcpart compute statistics;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/analyze1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/analyze1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/analyze1.q
deleted file mode 100644
index 057a1a0..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/analyze1.q
+++ /dev/null
@@ -1 +0,0 @@
-analyze table srcpart partition (key) compute statistics;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/analyze_non_existent_tbl.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/analyze_non_existent_tbl.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/analyze_non_existent_tbl.q
deleted file mode 100644
index 78a9701..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/analyze_non_existent_tbl.q
+++ /dev/null
@@ -1 +0,0 @@
-analyze table nonexistent compute statistics;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/analyze_view.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/analyze_view.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/analyze_view.q
deleted file mode 100644
index af4970f..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/analyze_view.q
+++ /dev/null
@@ -1,6 +0,0 @@
-DROP VIEW av;
-
-CREATE VIEW av AS SELECT * FROM src;
-
--- should fail:  can't analyze a view...yet
-ANALYZE TABLE av COMPUTE STATISTICS;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive1.q
deleted file mode 100644
index a4b50f5..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive1.q
+++ /dev/null
@@ -1,11 +0,0 @@
-set hive.archive.enabled = true;
--- Tests trying to archive a partition twice.
--- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.17, 0.18, 0.19)
-
-CREATE TABLE srcpart_archived LIKE srcpart;
-
-INSERT OVERWRITE TABLE srcpart_archived PARTITION (ds='2008-04-08', hr='12')
-SELECT key, value FROM srcpart WHERE ds='2008-04-08' AND hr='12';
-
-ALTER TABLE srcpart_archived ARCHIVE PARTITION (ds='2008-04-08', hr='12');
-ALTER TABLE srcpart_archived ARCHIVE PARTITION (ds='2008-04-08', hr='12');

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive2.q
deleted file mode 100644
index ff8dcb2..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive2.q
+++ /dev/null
@@ -1,10 +0,0 @@
-set hive.archive.enabled = true;
--- Tests trying to unarchive a non-archived partition
--- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.17, 0.18, 0.19)
-
-drop table tstsrcpart;
-create table tstsrcpart like srcpart;
-insert overwrite table tstsrcpart partition (ds='2008-04-08', hr='12')
-select key, value from srcpart where ds='2008-04-08' and hr='12';
-
-ALTER TABLE tstsrcpart UNARCHIVE PARTITION (ds='2008-04-08', hr='12');

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive3.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive3.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive3.q
deleted file mode 100644
index 53057da..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive3.q
+++ /dev/null
@@ -1,5 +0,0 @@
-set hive.archive.enabled = true;
--- Tests archiving a table
--- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.17, 0.18, 0.19)
-
-ALTER TABLE srcpart ARCHIVE;

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive4.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive4.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive4.q
deleted file mode 100644
index 56d6f17..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive4.q
+++ /dev/null
@@ -1,5 +0,0 @@
-set hive.archive.enabled = true;
--- Tests archiving multiple partitions
--- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.17, 0.18, 0.19)
-
-ALTER TABLE srcpart ARCHIVE PARTITION (ds='2008-04-08', hr='12') PARTITION (ds='2008-04-08', hr='11');

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive5.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive5.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive5.q
deleted file mode 100644
index 4f6dc8d..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive5.q
+++ /dev/null
@@ -1,5 +0,0 @@
-set hive.archive.enabled = true;
--- Tests creating a partition where the partition value will collide with the
--- a intermediate directory
-
-ALTER TABLE srcpart ADD PARTITION (ds='2008-04-08', hr='14_INTERMEDIATE_ORIGINAL')

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_corrupt.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_corrupt.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_corrupt.q
deleted file mode 100644
index 130b37b..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_corrupt.q
+++ /dev/null
@@ -1,18 +0,0 @@
-USE default;
-
-set hive.archive.enabled = true;
-set hive.enforce.bucketing = true;
-
-drop table tstsrcpart;
-
-create table tstsrcpart like srcpart;
-
--- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.20)
--- The version of GzipCodec that is provided in Hadoop 0.20 silently ignores
--- file format errors. However, versions of Hadoop that include
--- HADOOP-6835 (e.g. 0.23 and 1.x) cause a Wrong File Format exception
--- to be thrown during the LOAD step. This former behavior is tested
--- in clientpositive/archive_corrupt.q
-
-load data local inpath '../../data/files/archive_corrupt.rc' overwrite into table tstsrcpart partition (ds='2008-04-08', hr='11');
-

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_insert1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_insert1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_insert1.q
deleted file mode 100644
index deaff63..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_insert1.q
+++ /dev/null
@@ -1,13 +0,0 @@
-set hive.archive.enabled = true;
--- Tests trying to insert into archived partition.
--- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.17, 0.18, 0.19)
-
-CREATE TABLE tstsrcpart LIKE srcpart;
-
-INSERT OVERWRITE TABLE tstsrcpart PARTITION (ds='2008-04-08', hr='12')
-SELECT key, value FROM srcpart WHERE ds='2008-04-08' AND hr='12';
-
-ALTER TABLE tstsrcpart ARCHIVE PARTITION (ds='2008-04-08', hr='12');
-
-INSERT OVERWRITE TABLE tstsrcpart PARTITION (ds='2008-04-08', hr='12')
-SELECT key, value FROM srcpart WHERE ds='2008-04-08' AND hr='12';

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_insert2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_insert2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_insert2.q
deleted file mode 100644
index d744f24..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_insert2.q
+++ /dev/null
@@ -1,13 +0,0 @@
-set hive.archive.enabled = true;
--- Tests trying to insert into archived partition.
--- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.17, 0.18, 0.19)
-
-CREATE TABLE tstsrcpart LIKE srcpart;
-
-INSERT OVERWRITE TABLE tstsrcpart PARTITION (ds='2008-04-08', hr='12')
-SELECT key, value FROM srcpart WHERE ds='2008-04-08' AND hr='12';
-
-ALTER TABLE tstsrcpart ARCHIVE PARTITION (ds='2008-04-08');
-
-INSERT OVERWRITE TABLE tstsrcpart PARTITION (ds='2008-04-08', hr='12')
-SELECT key, value FROM srcpart WHERE ds='2008-04-08' AND hr='12';

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_insert3.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_insert3.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_insert3.q
deleted file mode 100644
index c6cb142..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_insert3.q
+++ /dev/null
@@ -1,13 +0,0 @@
-set hive.archive.enabled = true;
--- Tests trying to create partition inside of archived directory.
--- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.17, 0.18, 0.19)
-
-CREATE TABLE tstsrcpart LIKE srcpart;
-
-INSERT OVERWRITE TABLE tstsrcpart PARTITION (ds='2008-04-08', hr='12')
-SELECT key, value FROM srcpart WHERE ds='2008-04-08' AND hr='12';
-
-ALTER TABLE tstsrcpart ARCHIVE PARTITION (ds='2008-04-08');
-
-INSERT OVERWRITE TABLE tstsrcpart PARTITION (ds='2008-04-08', hr='11')
-SELECT key, value FROM srcpart WHERE ds='2008-04-08' AND hr='11';

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_insert4.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_insert4.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_insert4.q
deleted file mode 100644
index c36f3ef..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_insert4.q
+++ /dev/null
@@ -1,15 +0,0 @@
-set hive.archive.enabled = true;
--- Tests trying to (possible) dynamic insert into archived partition.
--- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.17, 0.18, 0.19)
-
-CREATE TABLE tstsrcpart LIKE srcpart;
-
-INSERT OVERWRITE TABLE tstsrcpart PARTITION (ds='2008-04-08', hr='12')
-SELECT key, value FROM srcpart WHERE ds='2008-04-08' AND hr='12';
-
-ALTER TABLE tstsrcpart ARCHIVE PARTITION (ds='2008-04-08', hr='12');
-
-SET hive.exec.dynamic.partition=true;
-
-INSERT OVERWRITE TABLE tstsrcpart PARTITION (ds='2008-04-08', hr)
-SELECT key, value, hr FROM srcpart WHERE ds='2008-04-08' AND hr='12';

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_multi1.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_multi1.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_multi1.q
deleted file mode 100644
index 8c702ed..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_multi1.q
+++ /dev/null
@@ -1,13 +0,0 @@
-set hive.archive.enabled = true;
--- Tests trying to archive a partition twice.
--- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.17, 0.18, 0.19)
-
-CREATE TABLE tstsrcpart LIKE srcpart;
-
-INSERT OVERWRITE TABLE tstsrcpart PARTITION (ds='2008-04-08', hr='11')
-SELECT key, value FROM srcpart WHERE ds='2008-04-08' AND hr='11';
-INSERT OVERWRITE TABLE tstsrcpart PARTITION (ds='2008-04-08', hr='12')
-SELECT key, value FROM srcpart WHERE ds='2008-04-08' AND hr='12';
-
-ALTER TABLE tstsrcpart ARCHIVE PARTITION (ds='2008-04-08');
-ALTER TABLE tstsrcpart ARCHIVE PARTITION (ds='2008-04-08');

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_multi2.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_multi2.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_multi2.q
deleted file mode 100644
index d3cfb89..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_multi2.q
+++ /dev/null
@@ -1,12 +0,0 @@
-set hive.archive.enabled = true;
--- Tests trying to unarchive a non-archived partition group
--- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.17, 0.18, 0.19)
-
-drop table tstsrcpart;
-create table tstsrcpart like srcpart;
-INSERT OVERWRITE TABLE tstsrcpart PARTITION (ds='2008-04-08', hr='11')
-SELECT key, value FROM srcpart WHERE ds='2008-04-08' AND hr='11';
-insert overwrite table tstsrcpart partition (ds='2008-04-08', hr='12')
-select key, value from srcpart where ds='2008-04-08' and hr='12';
-
-ALTER TABLE tstsrcpart UNARCHIVE PARTITION (ds='2008-04-08', hr='12');

http://git-wip-us.apache.org/repos/asf/spark/blob/b28fe448/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_multi3.q
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_multi3.q b/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_multi3.q
deleted file mode 100644
index 75f5dfa..0000000
--- a/sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_multi3.q
+++ /dev/null
@@ -1,13 +0,0 @@
-set hive.archive.enabled = true;
--- Tests trying to archive outer partition group containing other partition inside.
--- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.17, 0.18, 0.19)
-
-CREATE TABLE tstsrcpart LIKE srcpart;
-
-INSERT OVERWRITE TABLE tstsrcpart PARTITION (ds='2008-04-08', hr='11')
-SELECT key, value FROM srcpart WHERE ds='2008-04-08' AND hr='11';
-INSERT OVERWRITE TABLE tstsrcpart PARTITION (ds='2008-04-08', hr='12')
-SELECT key, value FROM srcpart WHERE ds='2008-04-08' AND hr='12';
-
-ALTER TABLE tstsrcpart ARCHIVE PARTITION (ds='2008-04-08', hr='12');
-ALTER TABLE tstsrcpart ARCHIVE PARTITION (ds='2008-04-08');


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@spark.apache.org
For additional commands, e-mail: commits-help@spark.apache.org


Mime
View raw message