You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2013/04/10 02:07:09 UTC
svn commit: r1466300 [1/13] - in /hive/trunk:
cli/src/java/org/apache/hadoop/hive/cli/
ql/src/test/queries/clientpositive/ ql/src/test/results/clientpositive/
Author: hashutosh
Date: Wed Apr 10 00:06:55 2013
New Revision: 1466300
URL: http://svn.apache.org/r1466300
Log:
HIVE-4319 : Revert changes checked-in as part of 1953 (Vikram Dixit via Ashutosh Chauhan)
Removed:
hive/trunk/ql/src/test/queries/clientpositive/comments.q
hive/trunk/ql/src/test/results/clientpositive/comments.q.out
Modified:
hive/trunk/cli/src/java/org/apache/hadoop/hive/cli/CliDriver.java
hive/trunk/ql/src/test/queries/clientpositive/alter_table_serde.q
hive/trunk/ql/src/test/results/clientpositive/add_part_exist.q.out
hive/trunk/ql/src/test/results/clientpositive/add_partition_no_whitelist.q.out
hive/trunk/ql/src/test/results/clientpositive/add_partition_with_whitelist.q.out
hive/trunk/ql/src/test/results/clientpositive/alias_casted_column.q.out
hive/trunk/ql/src/test/results/clientpositive/allcolref_in_udf.q.out
hive/trunk/ql/src/test/results/clientpositive/alter1.q.out
hive/trunk/ql/src/test/results/clientpositive/alter2.q.out
hive/trunk/ql/src/test/results/clientpositive/alter3.q.out
hive/trunk/ql/src/test/results/clientpositive/alter4.q.out
hive/trunk/ql/src/test/results/clientpositive/alter5.q.out
hive/trunk/ql/src/test/results/clientpositive/alter_numbuckets_partitioned_table.q.out
hive/trunk/ql/src/test/results/clientpositive/alter_numbuckets_partitioned_table2.q.out
hive/trunk/ql/src/test/results/clientpositive/alter_partition_clusterby_sortby.q.out
hive/trunk/ql/src/test/results/clientpositive/alter_partition_coltype.q.out
hive/trunk/ql/src/test/results/clientpositive/alter_partition_protect_mode.q.out
hive/trunk/ql/src/test/results/clientpositive/alter_partition_with_whitelist.q.out
hive/trunk/ql/src/test/results/clientpositive/alter_rename_partition.q.out
hive/trunk/ql/src/test/results/clientpositive/alter_rename_partition_authorization.q.out
hive/trunk/ql/src/test/results/clientpositive/alter_table_serde.q.out
hive/trunk/ql/src/test/results/clientpositive/alter_table_serde2.q.out
hive/trunk/ql/src/test/results/clientpositive/ambiguous_col.q.out
hive/trunk/ql/src/test/results/clientpositive/archive_multi.q.out
hive/trunk/ql/src/test/results/clientpositive/authorization_1.q.out
hive/trunk/ql/src/test/results/clientpositive/authorization_2.q.out
hive/trunk/ql/src/test/results/clientpositive/authorization_3.q.out
hive/trunk/ql/src/test/results/clientpositive/authorization_4.q.out
hive/trunk/ql/src/test/results/clientpositive/authorization_5.q.out
hive/trunk/ql/src/test/results/clientpositive/authorization_6.q.out
hive/trunk/ql/src/test/results/clientpositive/auto_join14_hadoop20.q.out
hive/trunk/ql/src/test/results/clientpositive/auto_join25.q.out
hive/trunk/ql/src/test/results/clientpositive/auto_smb_mapjoin_14.q.out
hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_1.q.out
hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_10.q.out
hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_2.q.out
hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_3.q.out
hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_4.q.out
hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_5.q.out
hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_6.q.out
hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_7.q.out
hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_8.q.out
hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_9.q.out
hive/trunk/ql/src/test/results/clientpositive/autogen_colalias.q.out
hive/trunk/ql/src/test/results/clientpositive/avro_change_schema.q.out
hive/trunk/ql/src/test/results/clientpositive/avro_compression_enabled.q.out
hive/trunk/ql/src/test/results/clientpositive/avro_evolved_schemas.q.out
hive/trunk/ql/src/test/results/clientpositive/avro_joins.q.out
hive/trunk/ql/src/test/results/clientpositive/avro_nullable_fields.q.out
hive/trunk/ql/src/test/results/clientpositive/avro_sanity_test.q.out
hive/trunk/ql/src/test/results/clientpositive/avro_schema_error_message.q.out
hive/trunk/ql/src/test/results/clientpositive/ba_table1.q.out
hive/trunk/ql/src/test/results/clientpositive/ba_table2.q.out
hive/trunk/ql/src/test/results/clientpositive/ba_table3.q.out
hive/trunk/ql/src/test/results/clientpositive/ba_table_udfs.q.out
hive/trunk/ql/src/test/results/clientpositive/ba_table_union.q.out
hive/trunk/ql/src/test/results/clientpositive/binary_output_format.q.out
hive/trunk/ql/src/test/results/clientpositive/binary_table_bincolserde.q.out
hive/trunk/ql/src/test/results/clientpositive/binary_table_colserde.q.out
hive/trunk/ql/src/test/results/clientpositive/bucket_groupby.q.out
hive/trunk/ql/src/test/results/clientpositive/bucket_map_join_1.q.out
hive/trunk/ql/src/test/results/clientpositive/bucket_map_join_2.q.out
hive/trunk/ql/src/test/results/clientpositive/bucketcontext_1.q.out
hive/trunk/ql/src/test/results/clientpositive/bucketcontext_2.q.out
hive/trunk/ql/src/test/results/clientpositive/bucketcontext_3.q.out
hive/trunk/ql/src/test/results/clientpositive/bucketcontext_4.q.out
hive/trunk/ql/src/test/results/clientpositive/bucketcontext_5.q.out
hive/trunk/ql/src/test/results/clientpositive/bucketcontext_6.q.out
hive/trunk/ql/src/test/results/clientpositive/bucketcontext_7.q.out
hive/trunk/ql/src/test/results/clientpositive/bucketcontext_8.q.out
hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin1.q.out
hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin10.q.out
hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin11.q.out
hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin12.q.out
hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin13.q.out
hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin2.q.out
hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin8.q.out
hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin9.q.out
hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin_negative3.q.out
hive/trunk/ql/src/test/results/clientpositive/column_access_stats.q.out
hive/trunk/ql/src/test/results/clientpositive/combine2_hadoop20.q.out
hive/trunk/ql/src/test/results/clientpositive/compute_stats_binary.q.out
hive/trunk/ql/src/test/results/clientpositive/compute_stats_boolean.q.out
hive/trunk/ql/src/test/results/clientpositive/compute_stats_double.q.out
hive/trunk/ql/src/test/results/clientpositive/compute_stats_empty_table.q.out
hive/trunk/ql/src/test/results/clientpositive/compute_stats_long.q.out
hive/trunk/ql/src/test/results/clientpositive/compute_stats_string.q.out
hive/trunk/ql/src/test/results/clientpositive/convert_enum_to_string.q.out
hive/trunk/ql/src/test/results/clientpositive/create_alter_list_bucketing_table1.q.out
hive/trunk/ql/src/test/results/clientpositive/create_big_view.q.out
hive/trunk/ql/src/test/results/clientpositive/create_like2.q.out
hive/trunk/ql/src/test/results/clientpositive/create_like_tbl_props.q.out
hive/trunk/ql/src/test/results/clientpositive/create_like_view.q.out
hive/trunk/ql/src/test/results/clientpositive/create_or_replace_view.q.out
hive/trunk/ql/src/test/results/clientpositive/create_view.q.out
hive/trunk/ql/src/test/results/clientpositive/create_view_partitioned.q.out
hive/trunk/ql/src/test/results/clientpositive/cross_join.q.out
hive/trunk/ql/src/test/results/clientpositive/ctas_hadoop20.q.out
hive/trunk/ql/src/test/results/clientpositive/ctas_uses_database_location.q.out
hive/trunk/ql/src/test/results/clientpositive/database.q.out
hive/trunk/ql/src/test/results/clientpositive/database_drop.q.out
hive/trunk/ql/src/test/results/clientpositive/decimal_udf.q.out
hive/trunk/ql/src/test/results/clientpositive/describe_comment_indent.q.out
hive/trunk/ql/src/test/results/clientpositive/describe_pretty.q.out
hive/trunk/ql/src/test/results/clientpositive/describe_syntax.q.out
hive/trunk/ql/src/test/results/clientpositive/describe_xpath.q.out
hive/trunk/ql/src/test/results/clientpositive/diff_part_input_formats.q.out
hive/trunk/ql/src/test/results/clientpositive/driverhook.q.out
hive/trunk/ql/src/test/results/clientpositive/drop_database_removes_partition_dirs.q.out
hive/trunk/ql/src/test/results/clientpositive/drop_index_removes_partition_dirs.q.out
hive/trunk/ql/src/test/results/clientpositive/drop_partitions_ignore_protection.q.out
hive/trunk/ql/src/test/results/clientpositive/drop_table_removes_partition_dirs.q.out
hive/trunk/ql/src/test/results/clientpositive/escape_clusterby1.q.out
hive/trunk/ql/src/test/results/clientpositive/escape_distributeby1.q.out
hive/trunk/ql/src/test/results/clientpositive/escape_orderby1.q.out
hive/trunk/ql/src/test/results/clientpositive/escape_sortby1.q.out
hive/trunk/ql/src/test/results/clientpositive/explain_dependency.q.out
hive/trunk/ql/src/test/results/clientpositive/explain_dependency2.q.out
hive/trunk/ql/src/test/results/clientpositive/global_limit.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby10.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby_distinct_samekey.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby_grouping_sets2.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby_grouping_sets3.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby_grouping_sets4.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby_grouping_sets5.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby_multi_insert_common_distinct.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby_multi_single_reducer3.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby_position.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby_ppd.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby_sort_1.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby_sort_10.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby_sort_2.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby_sort_3.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby_sort_4.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby_sort_5.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby_sort_6.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby_sort_7.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby_sort_8.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby_sort_9.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby_sort_skew_1.q.out
hive/trunk/ql/src/test/results/clientpositive/groupby_sort_test_1.q.out
hive/trunk/ql/src/test/results/clientpositive/hiveprofiler_script0.q.out
hive/trunk/ql/src/test/results/clientpositive/hiveprofiler_union0.q.out
hive/trunk/ql/src/test/results/clientpositive/index_auto.q.out
hive/trunk/ql/src/test/results/clientpositive/index_auto_empty.q.out
hive/trunk/ql/src/test/results/clientpositive/index_auto_file_format.q.out
hive/trunk/ql/src/test/results/clientpositive/index_auto_mult_tables.q.out
hive/trunk/ql/src/test/results/clientpositive/index_auto_mult_tables_compact.q.out
hive/trunk/ql/src/test/results/clientpositive/index_auto_multiple.q.out
hive/trunk/ql/src/test/results/clientpositive/index_auto_partitioned.q.out
hive/trunk/ql/src/test/results/clientpositive/index_auto_self_join.q.out
hive/trunk/ql/src/test/results/clientpositive/index_auto_unused.q.out
hive/trunk/ql/src/test/results/clientpositive/index_auto_update.q.out
hive/trunk/ql/src/test/results/clientpositive/index_bitmap_auto.q.out
hive/trunk/ql/src/test/results/clientpositive/index_bitmap_auto_partitioned.q.out
hive/trunk/ql/src/test/results/clientpositive/index_bitmap_compression.q.out
hive/trunk/ql/src/test/results/clientpositive/index_compression.q.out
hive/trunk/ql/src/test/results/clientpositive/index_stale.q.out
hive/trunk/ql/src/test/results/clientpositive/index_stale_partitioned.q.out
hive/trunk/ql/src/test/results/clientpositive/infer_bucket_sort.q.out
hive/trunk/ql/src/test/results/clientpositive/infer_bucket_sort_convert_join.q.out
hive/trunk/ql/src/test/results/clientpositive/infer_bucket_sort_grouping_operators.q.out
hive/trunk/ql/src/test/results/clientpositive/infer_bucket_sort_multi_insert.q.out
hive/trunk/ql/src/test/results/clientpositive/infer_const_type.q.out
hive/trunk/ql/src/test/results/clientpositive/init_file.q.out
hive/trunk/ql/src/test/results/clientpositive/innerjoin.q.out
hive/trunk/ql/src/test/results/clientpositive/input12_hadoop20.q.out
hive/trunk/ql/src/test/results/clientpositive/input16.q.out
hive/trunk/ql/src/test/results/clientpositive/input39_hadoop20.q.out
hive/trunk/ql/src/test/results/clientpositive/input_part10.q.out
hive/trunk/ql/src/test/results/clientpositive/inputddl4.q.out
hive/trunk/ql/src/test/results/clientpositive/inputddl5.q.out
hive/trunk/ql/src/test/results/clientpositive/inputddl6.q.out
hive/trunk/ql/src/test/results/clientpositive/inputddl7.q.out
hive/trunk/ql/src/test/results/clientpositive/insert1.q.out
hive/trunk/ql/src/test/results/clientpositive/join14_hadoop20.q.out
hive/trunk/ql/src/test/results/clientpositive/join28.q.out
hive/trunk/ql/src/test/results/clientpositive/join29.q.out
hive/trunk/ql/src/test/results/clientpositive/join31.q.out
hive/trunk/ql/src/test/results/clientpositive/join32.q.out
hive/trunk/ql/src/test/results/clientpositive/join33.q.out
hive/trunk/ql/src/test/results/clientpositive/join34.q.out
hive/trunk/ql/src/test/results/clientpositive/join35.q.out
hive/trunk/ql/src/test/results/clientpositive/join41.q.out
hive/trunk/ql/src/test/results/clientpositive/join_filters_overlap.q.out
hive/trunk/ql/src/test/results/clientpositive/join_nullsafe.q.out
hive/trunk/ql/src/test/results/clientpositive/join_vc.q.out
hive/trunk/ql/src/test/results/clientpositive/join_view.q.out
hive/trunk/ql/src/test/results/clientpositive/keyword_1.q.out
hive/trunk/ql/src/test/results/clientpositive/lateral_view.q.out
hive/trunk/ql/src/test/results/clientpositive/lateral_view_cp.q.out
hive/trunk/ql/src/test/results/clientpositive/leadlag.q.out
hive/trunk/ql/src/test/results/clientpositive/leadlag_queries.q.out
hive/trunk/ql/src/test/results/clientpositive/load_dyn_part14.q.out
hive/trunk/ql/src/test/results/clientpositive/mapjoin1.q.out
hive/trunk/ql/src/test/results/clientpositive/mapjoin_mapjoin.q.out
hive/trunk/ql/src/test/results/clientpositive/mapjoin_subquery.q.out
hive/trunk/ql/src/test/results/clientpositive/mapjoin_subquery2.q.out
hive/trunk/ql/src/test/results/clientpositive/merge_dynamic_partition4.q.out
hive/trunk/ql/src/test/results/clientpositive/merge_dynamic_partition5.q.out
hive/trunk/ql/src/test/results/clientpositive/mergejoins_mixed.q.out
hive/trunk/ql/src/test/results/clientpositive/metadataonly1.q.out
hive/trunk/ql/src/test/results/clientpositive/multiMapJoin1.q.out
hive/trunk/ql/src/test/results/clientpositive/nomore_ambiguous_table_col.q.out
hive/trunk/ql/src/test/results/clientpositive/nonblock_op_deduplicate.q.out
hive/trunk/ql/src/test/results/clientpositive/nonmr_fetch.q.out
hive/trunk/ql/src/test/results/clientpositive/orc_empty_strings.q.out
hive/trunk/ql/src/test/results/clientpositive/part_inherit_tbl_props.q.out
hive/trunk/ql/src/test/results/clientpositive/part_inherit_tbl_props_with_star.q.out
hive/trunk/ql/src/test/results/clientpositive/partition_wise_fileformat10.q.out
hive/trunk/ql/src/test/results/clientpositive/partition_wise_fileformat11.q.out
hive/trunk/ql/src/test/results/clientpositive/partition_wise_fileformat12.q.out
hive/trunk/ql/src/test/results/clientpositive/partition_wise_fileformat13.q.out
hive/trunk/ql/src/test/results/clientpositive/partition_wise_fileformat14.q.out
hive/trunk/ql/src/test/results/clientpositive/partition_wise_fileformat15.q.out
hive/trunk/ql/src/test/results/clientpositive/partition_wise_fileformat16.q.out
hive/trunk/ql/src/test/results/clientpositive/partition_wise_fileformat8.q.out
hive/trunk/ql/src/test/results/clientpositive/partition_wise_fileformat9.q.out
hive/trunk/ql/src/test/results/clientpositive/plan_json.q.out
hive/trunk/ql/src/test/results/clientpositive/ppd_constant_where.q.out
hive/trunk/ql/src/test/results/clientpositive/ppd_repeated_alias.q.out
hive/trunk/ql/src/test/results/clientpositive/ppd_union_view.q.out
hive/trunk/ql/src/test/results/clientpositive/protectmode.q.out
hive/trunk/ql/src/test/results/clientpositive/ptf.q.out
hive/trunk/ql/src/test/results/clientpositive/ptf_decimal.q.out
hive/trunk/ql/src/test/results/clientpositive/ptf_general_queries.q.out
hive/trunk/ql/src/test/results/clientpositive/ptf_npath.q.out
hive/trunk/ql/src/test/results/clientpositive/ptf_rcfile.q.out
hive/trunk/ql/src/test/results/clientpositive/ptf_seqfile.q.out
hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner1.q.out
hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner2.q.out
hive/trunk/ql/src/test/results/clientpositive/rand_partitionpruner3.q.out
hive/trunk/ql/src/test/results/clientpositive/rcfile_merge1.q.out
hive/trunk/ql/src/test/results/clientpositive/reducesink_dedup.q.out
hive/trunk/ql/src/test/results/clientpositive/rename_column.q.out
hive/trunk/ql/src/test/results/clientpositive/rename_partition_location.q.out
hive/trunk/ql/src/test/results/clientpositive/rename_table_location.q.out
hive/trunk/ql/src/test/results/clientpositive/sample1.q.out
hive/trunk/ql/src/test/results/clientpositive/sample10.q.out
hive/trunk/ql/src/test/results/clientpositive/sample2.q.out
hive/trunk/ql/src/test/results/clientpositive/sample3.q.out
hive/trunk/ql/src/test/results/clientpositive/sample4.q.out
hive/trunk/ql/src/test/results/clientpositive/sample5.q.out
hive/trunk/ql/src/test/results/clientpositive/sample6.q.out
hive/trunk/ql/src/test/results/clientpositive/sample7.q.out
hive/trunk/ql/src/test/results/clientpositive/sample8.q.out
hive/trunk/ql/src/test/results/clientpositive/sample_islocalmode_hook_hadoop20.q.out
hive/trunk/ql/src/test/results/clientpositive/script_env_var1.q.out
hive/trunk/ql/src/test/results/clientpositive/script_env_var2.q.out
hive/trunk/ql/src/test/results/clientpositive/script_pipe.q.out
hive/trunk/ql/src/test/results/clientpositive/semicolon.q.out
hive/trunk/ql/src/test/results/clientpositive/show_columns.q.out
hive/trunk/ql/src/test/results/clientpositive/show_create_table_alter.q.out
hive/trunk/ql/src/test/results/clientpositive/show_create_table_db_table.q.out
hive/trunk/ql/src/test/results/clientpositive/show_create_table_delimited.q.out
hive/trunk/ql/src/test/results/clientpositive/show_create_table_partitioned.q.out
hive/trunk/ql/src/test/results/clientpositive/show_create_table_serde.q.out
hive/trunk/ql/src/test/results/clientpositive/show_create_table_view.q.out
hive/trunk/ql/src/test/results/clientpositive/show_tables.q.out
hive/trunk/ql/src/test/results/clientpositive/skewjoinopt1.q.out
hive/trunk/ql/src/test/results/clientpositive/skewjoinopt10.q.out
hive/trunk/ql/src/test/results/clientpositive/skewjoinopt11.q.out
hive/trunk/ql/src/test/results/clientpositive/skewjoinopt12.q.out
hive/trunk/ql/src/test/results/clientpositive/skewjoinopt13.q.out
hive/trunk/ql/src/test/results/clientpositive/skewjoinopt14.q.out
hive/trunk/ql/src/test/results/clientpositive/skewjoinopt15.q.out
hive/trunk/ql/src/test/results/clientpositive/skewjoinopt16.q.out
hive/trunk/ql/src/test/results/clientpositive/skewjoinopt17.q.out
hive/trunk/ql/src/test/results/clientpositive/skewjoinopt18.q.out
hive/trunk/ql/src/test/results/clientpositive/skewjoinopt19.q.out
hive/trunk/ql/src/test/results/clientpositive/skewjoinopt2.q.out
hive/trunk/ql/src/test/results/clientpositive/skewjoinopt20.q.out
hive/trunk/ql/src/test/results/clientpositive/skewjoinopt3.q.out
hive/trunk/ql/src/test/results/clientpositive/skewjoinopt4.q.out
hive/trunk/ql/src/test/results/clientpositive/skewjoinopt5.q.out
hive/trunk/ql/src/test/results/clientpositive/skewjoinopt6.q.out
hive/trunk/ql/src/test/results/clientpositive/skewjoinopt7.q.out
hive/trunk/ql/src/test/results/clientpositive/skewjoinopt8.q.out
hive/trunk/ql/src/test/results/clientpositive/skewjoinopt9.q.out
hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin9.q.out
hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_10.q.out
hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_11.q.out
hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_12.q.out
hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_13.q.out
hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_14.q.out
hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_15.q.out
hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_16.q.out
hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_17.q.out
hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_18.q.out
hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_19.q.out
hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_20.q.out
hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_21.q.out
hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_22.q.out
hive/trunk/ql/src/test/results/clientpositive/sort_merge_join_desc_1.q.out
hive/trunk/ql/src/test/results/clientpositive/sort_merge_join_desc_2.q.out
hive/trunk/ql/src/test/results/clientpositive/sort_merge_join_desc_3.q.out
hive/trunk/ql/src/test/results/clientpositive/sort_merge_join_desc_4.q.out
hive/trunk/ql/src/test/results/clientpositive/sort_merge_join_desc_5.q.out
hive/trunk/ql/src/test/results/clientpositive/sort_merge_join_desc_6.q.out
hive/trunk/ql/src/test/results/clientpositive/sort_merge_join_desc_7.q.out
hive/trunk/ql/src/test/results/clientpositive/stats1.q.out
hive/trunk/ql/src/test/results/clientpositive/stats18.q.out
hive/trunk/ql/src/test/results/clientpositive/stats19.q.out
hive/trunk/ql/src/test/results/clientpositive/stats20.q.out
hive/trunk/ql/src/test/results/clientpositive/stats_aggregator_error_1.q.out
hive/trunk/ql/src/test/results/clientpositive/stats_empty_dyn_part.q.out
hive/trunk/ql/src/test/results/clientpositive/stats_empty_partition.q.out
hive/trunk/ql/src/test/results/clientpositive/stats_noscan_1.q.out
hive/trunk/ql/src/test/results/clientpositive/stats_noscan_2.q.out
hive/trunk/ql/src/test/results/clientpositive/stats_partscan_1.q.out
hive/trunk/ql/src/test/results/clientpositive/stats_publisher_error_1.q.out
hive/trunk/ql/src/test/results/clientpositive/table_access_keys_stats.q.out
hive/trunk/ql/src/test/results/clientpositive/timestamp_udf.q.out
hive/trunk/ql/src/test/results/clientpositive/transform2.q.out
hive/trunk/ql/src/test/results/clientpositive/truncate_table.q.out
hive/trunk/ql/src/test/results/clientpositive/type_widening.q.out
hive/trunk/ql/src/test/results/clientpositive/udaf_percentile_approx.q.out
hive/trunk/ql/src/test/results/clientpositive/udf_array_contains.q.out
hive/trunk/ql/src/test/results/clientpositive/udf_bin.q.out
hive/trunk/ql/src/test/results/clientpositive/udf_case.q.out
hive/trunk/ql/src/test/results/clientpositive/udf_concat_ws.q.out
hive/trunk/ql/src/test/results/clientpositive/udf_conv.q.out
hive/trunk/ql/src/test/results/clientpositive/udf_format_number.q.out
hive/trunk/ql/src/test/results/clientpositive/udf_get_json_object.q.out
hive/trunk/ql/src/test/results/clientpositive/udf_hex.q.out
hive/trunk/ql/src/test/results/clientpositive/udf_if.q.out
hive/trunk/ql/src/test/results/clientpositive/udf_java_method.q.out
hive/trunk/ql/src/test/results/clientpositive/udf_length.q.out
hive/trunk/ql/src/test/results/clientpositive/udf_map_keys.q.out
hive/trunk/ql/src/test/results/clientpositive/udf_map_values.q.out
hive/trunk/ql/src/test/results/clientpositive/udf_negative.q.out
hive/trunk/ql/src/test/results/clientpositive/udf_not.q.out
hive/trunk/ql/src/test/results/clientpositive/udf_percentile.q.out
hive/trunk/ql/src/test/results/clientpositive/udf_positive.q.out
hive/trunk/ql/src/test/results/clientpositive/udf_printf.q.out
hive/trunk/ql/src/test/results/clientpositive/udf_reverse.q.out
hive/trunk/ql/src/test/results/clientpositive/udf_round_2.q.out
hive/trunk/ql/src/test/results/clientpositive/udf_round_3.q.out
hive/trunk/ql/src/test/results/clientpositive/udf_sort_array.q.out
hive/trunk/ql/src/test/results/clientpositive/udf_substr.q.out
hive/trunk/ql/src/test/results/clientpositive/udf_substring.q.out
hive/trunk/ql/src/test/results/clientpositive/udf_to_unix_timestamp.q.out
hive/trunk/ql/src/test/results/clientpositive/udf_translate.q.out
hive/trunk/ql/src/test/results/clientpositive/udf_unhex.q.out
hive/trunk/ql/src/test/results/clientpositive/udtf_json_tuple.q.out
hive/trunk/ql/src/test/results/clientpositive/udtf_parse_url_tuple.q.out
hive/trunk/ql/src/test/results/clientpositive/union.q.out
hive/trunk/ql/src/test/results/clientpositive/union10.q.out
hive/trunk/ql/src/test/results/clientpositive/union11.q.out
hive/trunk/ql/src/test/results/clientpositive/union12.q.out
hive/trunk/ql/src/test/results/clientpositive/union13.q.out
hive/trunk/ql/src/test/results/clientpositive/union14.q.out
hive/trunk/ql/src/test/results/clientpositive/union15.q.out
hive/trunk/ql/src/test/results/clientpositive/union17.q.out
hive/trunk/ql/src/test/results/clientpositive/union18.q.out
hive/trunk/ql/src/test/results/clientpositive/union19.q.out
hive/trunk/ql/src/test/results/clientpositive/union2.q.out
hive/trunk/ql/src/test/results/clientpositive/union20.q.out
hive/trunk/ql/src/test/results/clientpositive/union21.q.out
hive/trunk/ql/src/test/results/clientpositive/union22.q.out
hive/trunk/ql/src/test/results/clientpositive/union32.q.out
hive/trunk/ql/src/test/results/clientpositive/union33.q.out
hive/trunk/ql/src/test/results/clientpositive/union4.q.out
hive/trunk/ql/src/test/results/clientpositive/union5.q.out
hive/trunk/ql/src/test/results/clientpositive/union6.q.out
hive/trunk/ql/src/test/results/clientpositive/union7.q.out
hive/trunk/ql/src/test/results/clientpositive/union8.q.out
hive/trunk/ql/src/test/results/clientpositive/union9.q.out
hive/trunk/ql/src/test/results/clientpositive/union_null.q.out
hive/trunk/ql/src/test/results/clientpositive/union_remove_6.q.out
hive/trunk/ql/src/test/results/clientpositive/unset_table_view_property.q.out
hive/trunk/ql/src/test/results/clientpositive/view.q.out
hive/trunk/ql/src/test/results/clientpositive/windowing.q.out
hive/trunk/ql/src/test/results/clientpositive/windowing_columnPruning.q.out
hive/trunk/ql/src/test/results/clientpositive/windowing_expressions.q.out
hive/trunk/ql/src/test/results/clientpositive/windowing_rank.q.out
Modified: hive/trunk/cli/src/java/org/apache/hadoop/hive/cli/CliDriver.java
URL: http://svn.apache.org/viewvc/hive/trunk/cli/src/java/org/apache/hadoop/hive/cli/CliDriver.java?rev=1466300&r1=1466299&r2=1466300&view=diff
==============================================================================
--- hive/trunk/cli/src/java/org/apache/hadoop/hive/cli/CliDriver.java (original)
+++ hive/trunk/cli/src/java/org/apache/hadoop/hive/cli/CliDriver.java Wed Apr 10 00:06:55 2013
@@ -32,12 +32,12 @@ import java.util.Map;
import java.util.Set;
import jline.ArgumentCompletor;
-import jline.ArgumentCompletor.AbstractArgumentDelimiter;
-import jline.ArgumentCompletor.ArgumentDelimiter;
import jline.Completor;
import jline.ConsoleReader;
import jline.History;
import jline.SimpleCompletor;
+import jline.ArgumentCompletor.AbstractArgumentDelimiter;
+import jline.ArgumentCompletor.ArgumentDelimiter;
import org.apache.commons.lang.StringUtils;
import org.apache.commons.logging.Log;
@@ -398,18 +398,6 @@ public class CliDriver {
int lastRet = 0, ret = 0;
String command = "";
- String cmdLine = "";
- for (String cmd : line.split("\n")) {
- String[] cmdArr = cmd.split("-- ");
- if (cmdArr.length > 2) {
- console.printInfo("Cannot have nested comments");
- return -2;
- }
-
- cmdLine += cmdArr[0] + "\n";
- }
-
- line = cmdLine;
for (String oneCmd : line.split(";")) {
if (StringUtils.endsWith(oneCmd, "\\")) {
@@ -763,9 +751,6 @@ public class CliDriver {
if (!prefix.equals("")) {
prefix += '\n';
}
- if (prefix.equals("") && line.startsWith("--")) {
- continue;
- }
if (line.trim().endsWith(";") && !line.trim().endsWith("\\;")) {
line = prefix + line;
ret = cli.processLine(line, true);
Modified: hive/trunk/ql/src/test/queries/clientpositive/alter_table_serde.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/alter_table_serde.q?rev=1466300&r1=1466299&r2=1466300&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/alter_table_serde.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/alter_table_serde.q Wed Apr 10 00:06:55 2013
@@ -10,7 +10,7 @@ describe extended test_table;
drop table test_table;
--- test partitioned table
+--- test partitioned table
create table test_table (id int, query string, name string) partitioned by (dt string);
alter table test_table add partition (dt = '2011');
Modified: hive/trunk/ql/src/test/results/clientpositive/add_part_exist.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/add_part_exist.q.out?rev=1466300&r1=1466299&r2=1466300&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/add_part_exist.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/add_part_exist.q.out Wed Apr 10 00:06:55 2013
@@ -83,9 +83,11 @@ src_thrift
srcbucket
srcbucket2
srcpart
-PREHOOK: query: CREATE DATABASE add_part_test_db
+PREHOOK: query: -- Test ALTER TABLE ADD PARTITION in non-default Database
+CREATE DATABASE add_part_test_db
PREHOOK: type: CREATEDATABASE
-POSTHOOK: query: CREATE DATABASE add_part_test_db
+POSTHOOK: query: -- Test ALTER TABLE ADD PARTITION in non-default Database
+CREATE DATABASE add_part_test_db
POSTHOOK: type: CREATEDATABASE
PREHOOK: query: USE add_part_test_db
PREHOOK: type: SWITCHDATABASE
Modified: hive/trunk/ql/src/test/results/clientpositive/add_partition_no_whitelist.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/add_partition_no_whitelist.q.out?rev=1466300&r1=1466299&r2=1466300&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/add_partition_no_whitelist.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/add_partition_no_whitelist.q.out Wed Apr 10 00:06:55 2013
@@ -1,6 +1,10 @@
-PREHOOK: query: CREATE TABLE part_nowhitelist_test (key STRING, value STRING) PARTITIONED BY (ds STRING)
+PREHOOK: query: -- Test with no partition name whitelist pattern
+
+CREATE TABLE part_nowhitelist_test (key STRING, value STRING) PARTITIONED BY (ds STRING)
PREHOOK: type: CREATETABLE
-POSTHOOK: query: CREATE TABLE part_nowhitelist_test (key STRING, value STRING) PARTITIONED BY (ds STRING)
+POSTHOOK: query: -- Test with no partition name whitelist pattern
+
+CREATE TABLE part_nowhitelist_test (key STRING, value STRING) PARTITIONED BY (ds STRING)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@part_nowhitelist_test
PREHOOK: query: SHOW PARTITIONS part_nowhitelist_test
Modified: hive/trunk/ql/src/test/results/clientpositive/add_partition_with_whitelist.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/add_partition_with_whitelist.q.out?rev=1466300&r1=1466299&r2=1466300&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/add_partition_with_whitelist.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/add_partition_with_whitelist.q.out Wed Apr 10 00:06:55 2013
@@ -1,6 +1,10 @@
-PREHOOK: query: CREATE TABLE part_whitelist_test (key STRING, value STRING) PARTITIONED BY (ds STRING)
+PREHOOK: query: -- This pattern matches only letters.
+
+CREATE TABLE part_whitelist_test (key STRING, value STRING) PARTITIONED BY (ds STRING)
PREHOOK: type: CREATETABLE
-POSTHOOK: query: CREATE TABLE part_whitelist_test (key STRING, value STRING) PARTITIONED BY (ds STRING)
+POSTHOOK: query: -- This pattern matches only letters.
+
+CREATE TABLE part_whitelist_test (key STRING, value STRING) PARTITIONED BY (ds STRING)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@part_whitelist_test
PREHOOK: query: SHOW PARTITIONS part_whitelist_test
Modified: hive/trunk/ql/src/test/results/clientpositive/alias_casted_column.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/alias_casted_column.q.out?rev=1466300&r1=1466299&r2=1466300&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/alias_casted_column.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/alias_casted_column.q.out Wed Apr 10 00:06:55 2013
@@ -1,6 +1,8 @@
-PREHOOK: query: explain select key from (select cast(key as int) from src )t
+PREHOOK: query: -- HIVE-2477 Use name of original expression for name of CAST output
+explain select key from (select cast(key as int) from src )t
PREHOOK: type: QUERY
-POSTHOOK: query: explain select key from (select cast(key as int) from src )t
+POSTHOOK: query: -- HIVE-2477 Use name of original expression for name of CAST output
+explain select key from (select cast(key as int) from src )t
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION TOK_INT (TOK_TABLE_OR_COL key)))))) t)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL key)))))
Modified: hive/trunk/ql/src/test/results/clientpositive/allcolref_in_udf.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/allcolref_in_udf.q.out?rev=1466300&r1=1466299&r2=1466300&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/allcolref_in_udf.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/allcolref_in_udf.q.out Wed Apr 10 00:06:55 2013
@@ -60,12 +60,18 @@ POSTHOOK: Input: default@src
17val_17 ["17","val_17"]
0val_0 ["0","val_0"]
57val_57 ["57","val_57"]
-PREHOOK: query: explain
+PREHOOK: query: -- The order of columns is decided by row schema of prev operator
+-- Like join which has two or more aliases, it's from left most aias to right aliases.
+
+explain
select stack(2, *) as (e1,e2,e3) from (
select concat(*), concat(a.*), concat(b.*), concat(a.*, b.key), concat(a.key, b.*)
from src a join src b on a.key+1=b.key where a.key < 100) x limit 10
PREHOOK: type: QUERY
-POSTHOOK: query: explain
+POSTHOOK: query: -- The order of columns is decided by row schema of prev operator
+-- Like join which has two or more aliases, it's from left most aias to right aliases.
+
+explain
select stack(2, *) as (e1,e2,e3) from (
select concat(*), concat(a.*), concat(b.*), concat(a.*, b.key), concat(a.key, b.*)
from src a join src b on a.key+1=b.key where a.key < 100) x limit 10
Modified: hive/trunk/ql/src/test/results/clientpositive/alter1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/alter1.q.out?rev=1466300&r1=1466299&r2=1466300&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/alter1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/alter1.q.out Wed Apr 10 00:06:55 2013
@@ -174,11 +174,13 @@ POSTHOOK: type: DESCTABLE
a int None
b int None
c string None
-PREHOOK: query: DROP TABLE alter1
+PREHOOK: query: -- Cleanup
+DROP TABLE alter1
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@alter1
PREHOOK: Output: default@alter1
-POSTHOOK: query: DROP TABLE alter1
+POSTHOOK: query: -- Cleanup
+DROP TABLE alter1
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@alter1
POSTHOOK: Output: default@alter1
@@ -194,9 +196,13 @@ src_thrift
srcbucket
srcbucket2
srcpart
-PREHOOK: query: CREATE DATABASE alter1_db
+PREHOOK: query: -- With non-default Database
+
+CREATE DATABASE alter1_db
PREHOOK: type: CREATEDATABASE
-POSTHOOK: query: CREATE DATABASE alter1_db
+POSTHOOK: query: -- With non-default Database
+
+CREATE DATABASE alter1_db
POSTHOOK: type: CREATEDATABASE
PREHOOK: query: USE alter1_db
PREHOOK: type: SWITCHDATABASE
Modified: hive/trunk/ql/src/test/results/clientpositive/alter2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/alter2.q.out?rev=1466300&r1=1466299&r2=1466300&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/alter2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/alter2.q.out Wed Apr 10 00:06:55 2013
@@ -170,11 +170,13 @@ POSTHOOK: query: show partitions alter2
POSTHOOK: type: SHOWPARTITIONS
insertdate=2008-01-01
insertdate=2008-01-02
-PREHOOK: query: DROP TABLE alter2
+PREHOOK: query: -- Cleanup
+DROP TABLE alter2
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@alter2
PREHOOK: Output: default@alter2
-POSTHOOK: query: DROP TABLE alter2
+POSTHOOK: query: -- Cleanup
+DROP TABLE alter2
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@alter2
POSTHOOK: Output: default@alter2
@@ -190,9 +192,13 @@ src_thrift
srcbucket
srcbucket2
srcpart
-PREHOOK: query: CREATE DATABASE alter2_db
+PREHOOK: query: -- Using non-default Database
+
+CREATE DATABASE alter2_db
PREHOOK: type: CREATEDATABASE
-POSTHOOK: query: CREATE DATABASE alter2_db
+POSTHOOK: query: -- Using non-default Database
+
+CREATE DATABASE alter2_db
POSTHOOK: type: CREATEDATABASE
PREHOOK: query: USE alter2_db
PREHOOK: type: SWITCHDATABASE
Modified: hive/trunk/ql/src/test/results/clientpositive/alter3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/alter3.q.out?rev=1466300&r1=1466299&r2=1466300&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/alter3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/alter3.q.out Wed Apr 10 00:06:55 2013
@@ -152,11 +152,13 @@ pcol1 string
pcol2 string None
#### A masked pattern was here ####
-PREHOOK: query: DROP TABLE alter3_src
+PREHOOK: query: -- Cleanup
+DROP TABLE alter3_src
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@alter3_src
PREHOOK: Output: default@alter3_src
-POSTHOOK: query: DROP TABLE alter3_src
+POSTHOOK: query: -- Cleanup
+DROP TABLE alter3_src
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@alter3_src
POSTHOOK: Output: default@alter3_src
@@ -196,9 +198,13 @@ src_thrift
srcbucket
srcbucket2
srcpart
-PREHOOK: query: CREATE DATABASE alter3_db
+PREHOOK: query: -- With non-default Database
+
+CREATE DATABASE alter3_db
PREHOOK: type: CREATEDATABASE
-POSTHOOK: query: CREATE DATABASE alter3_db
+POSTHOOK: query: -- With non-default Database
+
+CREATE DATABASE alter3_db
POSTHOOK: type: CREATEDATABASE
POSTHOOK: Lineage: alter3 PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
POSTHOOK: Lineage: alter3_like PARTITION(pcol1=test_part:,pcol2=test_part:).col1 SIMPLE [(alter3_src)alter3_src.FieldSchema(name:col1, type:string, comment:null), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/alter4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/alter4.q.out?rev=1466300&r1=1466299&r2=1466300&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/alter4.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/alter4.q.out Wed Apr 10 00:06:55 2013
@@ -31,11 +31,13 @@ key int
value string None
#### A masked pattern was here ####
-PREHOOK: query: DROP TABLE set_bucketing_test
+PREHOOK: query: -- Cleanup
+DROP TABLE set_bucketing_test
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@set_bucketing_test
PREHOOK: Output: default@set_bucketing_test
-POSTHOOK: query: DROP TABLE set_bucketing_test
+POSTHOOK: query: -- Cleanup
+DROP TABLE set_bucketing_test
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@set_bucketing_test
POSTHOOK: Output: default@set_bucketing_test
@@ -51,9 +53,13 @@ src_thrift
srcbucket
srcbucket2
srcpart
-PREHOOK: query: CREATE DATABASE alter4_db
+PREHOOK: query: -- with non-default Database
+
+CREATE DATABASE alter4_db
PREHOOK: type: CREATEDATABASE
-POSTHOOK: query: CREATE DATABASE alter4_db
+POSTHOOK: query: -- with non-default Database
+
+CREATE DATABASE alter4_db
POSTHOOK: type: CREATEDATABASE
PREHOOK: query: USE alter4_db
PREHOOK: type: SWITCHDATABASE
Modified: hive/trunk/ql/src/test/results/clientpositive/alter5.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/alter5.q.out?rev=1466300&r1=1466299&r2=1466300&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/alter5.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/alter5.q.out Wed Apr 10 00:06:55 2013
@@ -1,11 +1,11 @@
PREHOOK: query: --
-
+-- Added to validate the fix for HIVE-2117 - explicit partition location
--
create table alter5_src ( col1 string ) stored as textfile
PREHOOK: type: CREATETABLE
POSTHOOK: query: --
-
+-- Added to validate the fix for HIVE-2117 - explicit partition location
--
create table alter5_src ( col1 string ) stored as textfile
@@ -23,15 +23,15 @@ POSTHOOK: query: create table alter5 ( c
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@alter5
PREHOOK: query: --
-
-
+-- Here's the interesting bit for HIVE-2117 - partition subdir should be
+-- named "parta".
--
alter table alter5 add partition (dt='a') location 'parta'
PREHOOK: type: ALTERTABLE_ADDPARTS
PREHOOK: Input: default@alter5
POSTHOOK: query: --
-
-
+-- Here's the interesting bit for HIVE-2117 - partition subdir should be
+-- named "parta".
--
alter table alter5 add partition (dt='a') location 'parta'
POSTHOOK: type: ALTERTABLE_ADDPARTS
@@ -94,11 +94,13 @@ dt string
dt string None
#### A masked pattern was here ####
-PREHOOK: query: DROP TABLE alter5_src
+PREHOOK: query: -- Cleanup
+DROP TABLE alter5_src
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@alter5_src
PREHOOK: Output: default@alter5_src
-POSTHOOK: query: DROP TABLE alter5_src
+POSTHOOK: query: -- Cleanup
+DROP TABLE alter5_src
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@alter5_src
POSTHOOK: Output: default@alter5_src
@@ -125,9 +127,13 @@ src_thrift
srcbucket
srcbucket2
srcpart
-PREHOOK: query: CREATE DATABASE alter5_db
+PREHOOK: query: -- With non-default Database
+
+CREATE DATABASE alter5_db
PREHOOK: type: CREATEDATABASE
-POSTHOOK: query: CREATE DATABASE alter5_db
+POSTHOOK: query: -- With non-default Database
+
+CREATE DATABASE alter5_db
POSTHOOK: type: CREATEDATABASE
POSTHOOK: Lineage: alter5 PARTITION(dt=a).col1 SIMPLE [(alter5_src)alter5_src.FieldSchema(name:col1, type:string, comment:null), ]
PREHOOK: query: USE alter5_db
Modified: hive/trunk/ql/src/test/results/clientpositive/alter_numbuckets_partitioned_table.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/alter_numbuckets_partitioned_table.q.out?rev=1466300&r1=1466299&r2=1466300&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/alter_numbuckets_partitioned_table.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/alter_numbuckets_partitioned_table.q.out Wed Apr 10 00:06:55 2013
@@ -95,11 +95,15 @@ Bucket Columns: [key]
Sort Columns: []
Storage Desc Params:
serialization.format 1
-PREHOOK: query: alter table tst1 clustered by (key) into 12 buckets
+PREHOOK: query: -- Test changing bucket number
+
+alter table tst1 clustered by (key) into 12 buckets
PREHOOK: type: ALTERTABLE_CLUSTER_SORT
PREHOOK: Input: default@tst1
PREHOOK: Output: default@tst1
-POSTHOOK: query: alter table tst1 clustered by (key) into 12 buckets
+POSTHOOK: query: -- Test changing bucket number
+
+alter table tst1 clustered by (key) into 12 buckets
POSTHOOK: type: ALTERTABLE_CLUSTER_SORT
POSTHOOK: Input: default@tst1
POSTHOOK: Output: default@tst1
@@ -203,10 +207,14 @@ Bucket Columns: [key]
Sort Columns: []
Storage Desc Params:
serialization.format 1
-PREHOOK: query: alter table tst1 into 4 buckets
+PREHOOK: query: -- Test changing bucket number of (table/partition)
+
+alter table tst1 into 4 buckets
PREHOOK: type: ALTERTABLE_BUCKETNUM
PREHOOK: Input: default@tst1
-POSTHOOK: query: alter table tst1 into 4 buckets
+POSTHOOK: query: -- Test changing bucket number of (table/partition)
+
+alter table tst1 into 4 buckets
POSTHOOK: type: ALTERTABLE_BUCKETNUM
POSTHOOK: Input: default@tst1
POSTHOOK: Output: default@tst1
@@ -399,11 +407,15 @@ Bucket Columns: [key]
Sort Columns: []
Storage Desc Params:
serialization.format 1
-PREHOOK: query: alter table tst1 clustered by (key) sorted by (key asc) into 12 buckets
+PREHOOK: query: -- Test adding sort order
+
+alter table tst1 clustered by (key) sorted by (key asc) into 12 buckets
PREHOOK: type: ALTERTABLE_CLUSTER_SORT
PREHOOK: Input: default@tst1
PREHOOK: Output: default@tst1
-POSTHOOK: query: alter table tst1 clustered by (key) sorted by (key asc) into 12 buckets
+POSTHOOK: query: -- Test adding sort order
+
+alter table tst1 clustered by (key) sorted by (key asc) into 12 buckets
POSTHOOK: type: ALTERTABLE_CLUSTER_SORT
POSTHOOK: Input: default@tst1
POSTHOOK: Output: default@tst1
@@ -455,11 +467,15 @@ Bucket Columns: [key]
Sort Columns: [Order(col:key, order:1)]
Storage Desc Params:
serialization.format 1
-PREHOOK: query: alter table tst1 clustered by (key) sorted by (value desc) into 12 buckets
+PREHOOK: query: -- Test changing sort order
+
+alter table tst1 clustered by (key) sorted by (value desc) into 12 buckets
PREHOOK: type: ALTERTABLE_CLUSTER_SORT
PREHOOK: Input: default@tst1
PREHOOK: Output: default@tst1
-POSTHOOK: query: alter table tst1 clustered by (key) sorted by (value desc) into 12 buckets
+POSTHOOK: query: -- Test changing sort order
+
+alter table tst1 clustered by (key) sorted by (value desc) into 12 buckets
POSTHOOK: type: ALTERTABLE_CLUSTER_SORT
POSTHOOK: Input: default@tst1
POSTHOOK: Output: default@tst1
@@ -511,11 +527,15 @@ Bucket Columns: [key]
Sort Columns: [Order(col:value, order:0)]
Storage Desc Params:
serialization.format 1
-PREHOOK: query: alter table tst1 clustered by (value) into 12 buckets
+PREHOOK: query: -- Test removing test order
+
+alter table tst1 clustered by (value) into 12 buckets
PREHOOK: type: ALTERTABLE_CLUSTER_SORT
PREHOOK: Input: default@tst1
PREHOOK: Output: default@tst1
-POSTHOOK: query: alter table tst1 clustered by (value) into 12 buckets
+POSTHOOK: query: -- Test removing test order
+
+alter table tst1 clustered by (value) into 12 buckets
POSTHOOK: type: ALTERTABLE_CLUSTER_SORT
POSTHOOK: Input: default@tst1
POSTHOOK: Output: default@tst1
@@ -567,11 +587,15 @@ Bucket Columns: [value]
Sort Columns: []
Storage Desc Params:
serialization.format 1
-PREHOOK: query: alter table tst1 not clustered
+PREHOOK: query: -- Test removing buckets
+
+alter table tst1 not clustered
PREHOOK: type: ALTERTABLE_CLUSTER_SORT
PREHOOK: Input: default@tst1
PREHOOK: Output: default@tst1
-POSTHOOK: query: alter table tst1 not clustered
+POSTHOOK: query: -- Test removing buckets
+
+alter table tst1 not clustered
POSTHOOK: type: ALTERTABLE_CLUSTER_SORT
POSTHOOK: Input: default@tst1
POSTHOOK: Output: default@tst1
Modified: hive/trunk/ql/src/test/results/clientpositive/alter_numbuckets_partitioned_table2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/alter_numbuckets_partitioned_table2.q.out?rev=1466300&r1=1466299&r2=1466300&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/alter_numbuckets_partitioned_table2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/alter_numbuckets_partitioned_table2.q.out Wed Apr 10 00:06:55 2013
@@ -1,6 +1,12 @@
-PREHOOK: query: CREATE TABLE tst1(key STRING, value STRING) PARTITIONED BY (ds STRING)
+PREHOOK: query: -- Tests that when overwriting a partition in a table after altering the bucketing/sorting metadata
+-- the partition metadata is updated as well.
+
+CREATE TABLE tst1(key STRING, value STRING) PARTITIONED BY (ds STRING)
PREHOOK: type: CREATETABLE
-POSTHOOK: query: CREATE TABLE tst1(key STRING, value STRING) PARTITIONED BY (ds STRING)
+POSTHOOK: query: -- Tests that when overwriting a partition in a table after altering the bucketing/sorting metadata
+-- the partition metadata is updated as well.
+
+CREATE TABLE tst1(key STRING, value STRING) PARTITIONED BY (ds STRING)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@tst1
PREHOOK: query: DESCRIBE FORMATTED tst1
@@ -87,11 +93,13 @@ Bucket Columns: []
Sort Columns: []
Storage Desc Params:
serialization.format 1
-PREHOOK: query: ALTER TABLE tst1 CLUSTERED BY (key) INTO 8 BUCKETS
+PREHOOK: query: -- Test an unbucketed partition gets converted to bucketed
+ALTER TABLE tst1 CLUSTERED BY (key) INTO 8 BUCKETS
PREHOOK: type: ALTERTABLE_CLUSTER_SORT
PREHOOK: Input: default@tst1
PREHOOK: Output: default@tst1
-POSTHOOK: query: ALTER TABLE tst1 CLUSTERED BY (key) INTO 8 BUCKETS
+POSTHOOK: query: -- Test an unbucketed partition gets converted to bucketed
+ALTER TABLE tst1 CLUSTERED BY (key) INTO 8 BUCKETS
POSTHOOK: type: ALTERTABLE_CLUSTER_SORT
POSTHOOK: Input: default@tst1
POSTHOOK: Output: default@tst1
@@ -193,11 +201,13 @@ Bucket Columns: [key]
Sort Columns: []
Storage Desc Params:
serialization.format 1
-PREHOOK: query: ALTER TABLE tst1 CLUSTERED BY (key) SORTED BY (key DESC) INTO 8 BUCKETS
+PREHOOK: query: -- Test an unsorted partition gets converted to sorted
+ALTER TABLE tst1 CLUSTERED BY (key) SORTED BY (key DESC) INTO 8 BUCKETS
PREHOOK: type: ALTERTABLE_CLUSTER_SORT
PREHOOK: Input: default@tst1
PREHOOK: Output: default@tst1
-POSTHOOK: query: ALTER TABLE tst1 CLUSTERED BY (key) SORTED BY (key DESC) INTO 8 BUCKETS
+POSTHOOK: query: -- Test an unsorted partition gets converted to sorted
+ALTER TABLE tst1 CLUSTERED BY (key) SORTED BY (key DESC) INTO 8 BUCKETS
POSTHOOK: type: ALTERTABLE_CLUSTER_SORT
POSTHOOK: Input: default@tst1
POSTHOOK: Output: default@tst1
@@ -307,11 +317,13 @@ Bucket Columns: [key]
Sort Columns: [Order(col:key, order:0)]
Storage Desc Params:
serialization.format 1
-PREHOOK: query: ALTER TABLE tst1 CLUSTERED BY (value) SORTED BY (key DESC) INTO 8 BUCKETS
+PREHOOK: query: -- Test changing the bucket columns
+ALTER TABLE tst1 CLUSTERED BY (value) SORTED BY (key DESC) INTO 8 BUCKETS
PREHOOK: type: ALTERTABLE_CLUSTER_SORT
PREHOOK: Input: default@tst1
PREHOOK: Output: default@tst1
-POSTHOOK: query: ALTER TABLE tst1 CLUSTERED BY (value) SORTED BY (key DESC) INTO 8 BUCKETS
+POSTHOOK: query: -- Test changing the bucket columns
+ALTER TABLE tst1 CLUSTERED BY (value) SORTED BY (key DESC) INTO 8 BUCKETS
POSTHOOK: type: ALTERTABLE_CLUSTER_SORT
POSTHOOK: Input: default@tst1
POSTHOOK: Output: default@tst1
@@ -429,11 +441,13 @@ Bucket Columns: [value]
Sort Columns: [Order(col:key, order:0)]
Storage Desc Params:
serialization.format 1
-PREHOOK: query: ALTER TABLE tst1 CLUSTERED BY (value) SORTED BY (key DESC) INTO 4 BUCKETS
+PREHOOK: query: -- Test changing the number of buckets
+ALTER TABLE tst1 CLUSTERED BY (value) SORTED BY (key DESC) INTO 4 BUCKETS
PREHOOK: type: ALTERTABLE_CLUSTER_SORT
PREHOOK: Input: default@tst1
PREHOOK: Output: default@tst1
-POSTHOOK: query: ALTER TABLE tst1 CLUSTERED BY (value) SORTED BY (key DESC) INTO 4 BUCKETS
+POSTHOOK: query: -- Test changing the number of buckets
+ALTER TABLE tst1 CLUSTERED BY (value) SORTED BY (key DESC) INTO 4 BUCKETS
POSTHOOK: type: ALTERTABLE_CLUSTER_SORT
POSTHOOK: Input: default@tst1
POSTHOOK: Output: default@tst1
@@ -559,11 +573,13 @@ Bucket Columns: [value]
Sort Columns: [Order(col:key, order:0)]
Storage Desc Params:
serialization.format 1
-PREHOOK: query: ALTER TABLE tst1 CLUSTERED BY (value) SORTED BY (value DESC) INTO 4 BUCKETS
+PREHOOK: query: -- Test changing the sort columns
+ALTER TABLE tst1 CLUSTERED BY (value) SORTED BY (value DESC) INTO 4 BUCKETS
PREHOOK: type: ALTERTABLE_CLUSTER_SORT
PREHOOK: Input: default@tst1
PREHOOK: Output: default@tst1
-POSTHOOK: query: ALTER TABLE tst1 CLUSTERED BY (value) SORTED BY (value DESC) INTO 4 BUCKETS
+POSTHOOK: query: -- Test changing the sort columns
+ALTER TABLE tst1 CLUSTERED BY (value) SORTED BY (value DESC) INTO 4 BUCKETS
POSTHOOK: type: ALTERTABLE_CLUSTER_SORT
POSTHOOK: Input: default@tst1
POSTHOOK: Output: default@tst1
@@ -697,11 +713,13 @@ Bucket Columns: [value]
Sort Columns: [Order(col:value, order:0)]
Storage Desc Params:
serialization.format 1
-PREHOOK: query: ALTER TABLE tst1 CLUSTERED BY (value) SORTED BY (value ASC) INTO 4 BUCKETS
+PREHOOK: query: -- Test changing the sort order
+ALTER TABLE tst1 CLUSTERED BY (value) SORTED BY (value ASC) INTO 4 BUCKETS
PREHOOK: type: ALTERTABLE_CLUSTER_SORT
PREHOOK: Input: default@tst1
PREHOOK: Output: default@tst1
-POSTHOOK: query: ALTER TABLE tst1 CLUSTERED BY (value) SORTED BY (value ASC) INTO 4 BUCKETS
+POSTHOOK: query: -- Test changing the sort order
+ALTER TABLE tst1 CLUSTERED BY (value) SORTED BY (value ASC) INTO 4 BUCKETS
POSTHOOK: type: ALTERTABLE_CLUSTER_SORT
POSTHOOK: Input: default@tst1
POSTHOOK: Output: default@tst1
@@ -843,11 +861,13 @@ Bucket Columns: [value]
Sort Columns: [Order(col:value, order:1)]
Storage Desc Params:
serialization.format 1
-PREHOOK: query: ALTER TABLE tst1 CLUSTERED BY (value) INTO 4 BUCKETS
+PREHOOK: query: -- Test a sorted partition gets converted to unsorted
+ALTER TABLE tst1 CLUSTERED BY (value) INTO 4 BUCKETS
PREHOOK: type: ALTERTABLE_CLUSTER_SORT
PREHOOK: Input: default@tst1
PREHOOK: Output: default@tst1
-POSTHOOK: query: ALTER TABLE tst1 CLUSTERED BY (value) INTO 4 BUCKETS
+POSTHOOK: query: -- Test a sorted partition gets converted to unsorted
+ALTER TABLE tst1 CLUSTERED BY (value) INTO 4 BUCKETS
POSTHOOK: type: ALTERTABLE_CLUSTER_SORT
POSTHOOK: Input: default@tst1
POSTHOOK: Output: default@tst1
@@ -997,11 +1017,13 @@ Bucket Columns: [value]
Sort Columns: []
Storage Desc Params:
serialization.format 1
-PREHOOK: query: ALTER TABLE tst1 NOT CLUSTERED
+PREHOOK: query: -- Test a bucketed partition gets converted to unbucketed
+ALTER TABLE tst1 NOT CLUSTERED
PREHOOK: type: ALTERTABLE_CLUSTER_SORT
PREHOOK: Input: default@tst1
PREHOOK: Output: default@tst1
-POSTHOOK: query: ALTER TABLE tst1 NOT CLUSTERED
+POSTHOOK: query: -- Test a bucketed partition gets converted to unbucketed
+ALTER TABLE tst1 NOT CLUSTERED
POSTHOOK: type: ALTERTABLE_CLUSTER_SORT
POSTHOOK: Input: default@tst1
POSTHOOK: Output: default@tst1
Modified: hive/trunk/ql/src/test/results/clientpositive/alter_partition_clusterby_sortby.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/alter_partition_clusterby_sortby.q.out?rev=1466300&r1=1466299&r2=1466300&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/alter_partition_clusterby_sortby.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/alter_partition_clusterby_sortby.q.out Wed Apr 10 00:06:55 2013
@@ -10,11 +10,15 @@ POSTHOOK: query: alter table alter_table
POSTHOOK: type: ALTERTABLE_ADDPARTS
POSTHOOK: Input: default@alter_table_partition_clusterby_sortby
POSTHOOK: Output: default@alter_table_partition_clusterby_sortby@c=abc
-PREHOOK: query: alter table alter_table_partition_clusterby_sortby partition(c='abc') not sorted
+PREHOOK: query: -- Turn off sorting for a partition
+
+alter table alter_table_partition_clusterby_sortby partition(c='abc') not sorted
PREHOOK: type: ALTERTABLE_CLUSTER_SORT
PREHOOK: Input: default@alter_table_partition_clusterby_sortby
PREHOOK: Output: default@alter_table_partition_clusterby_sortby@c=abc
-POSTHOOK: query: alter table alter_table_partition_clusterby_sortby partition(c='abc') not sorted
+POSTHOOK: query: -- Turn off sorting for a partition
+
+alter table alter_table_partition_clusterby_sortby partition(c='abc') not sorted
POSTHOOK: type: ALTERTABLE_CLUSTER_SORT
POSTHOOK: Input: default@alter_table_partition_clusterby_sortby
POSTHOOK: Input: default@alter_table_partition_clusterby_sortby@c=abc
@@ -53,11 +57,15 @@ Bucket Columns: [a, b]
Sort Columns: []
Storage Desc Params:
serialization.format 1
-PREHOOK: query: alter table alter_table_partition_clusterby_sortby partition(c='abc') clustered by (b) sorted by (b desc) into 4 buckets
+PREHOOK: query: -- Modify clustering for a partition
+
+alter table alter_table_partition_clusterby_sortby partition(c='abc') clustered by (b) sorted by (b desc) into 4 buckets
PREHOOK: type: ALTERTABLE_CLUSTER_SORT
PREHOOK: Input: default@alter_table_partition_clusterby_sortby
PREHOOK: Output: default@alter_table_partition_clusterby_sortby@c=abc
-POSTHOOK: query: alter table alter_table_partition_clusterby_sortby partition(c='abc') clustered by (b) sorted by (b desc) into 4 buckets
+POSTHOOK: query: -- Modify clustering for a partition
+
+alter table alter_table_partition_clusterby_sortby partition(c='abc') clustered by (b) sorted by (b desc) into 4 buckets
POSTHOOK: type: ALTERTABLE_CLUSTER_SORT
POSTHOOK: Input: default@alter_table_partition_clusterby_sortby
POSTHOOK: Input: default@alter_table_partition_clusterby_sortby@c=abc
@@ -96,11 +104,15 @@ Bucket Columns: [b]
Sort Columns: [Order(col:b, order:0)]
Storage Desc Params:
serialization.format 1
-PREHOOK: query: alter table alter_table_partition_clusterby_sortby partition(c='abc') not clustered
+PREHOOK: query: -- Turn off clustering for a partition
+
+alter table alter_table_partition_clusterby_sortby partition(c='abc') not clustered
PREHOOK: type: ALTERTABLE_CLUSTER_SORT
PREHOOK: Input: default@alter_table_partition_clusterby_sortby
PREHOOK: Output: default@alter_table_partition_clusterby_sortby@c=abc
-POSTHOOK: query: alter table alter_table_partition_clusterby_sortby partition(c='abc') not clustered
+POSTHOOK: query: -- Turn off clustering for a partition
+
+alter table alter_table_partition_clusterby_sortby partition(c='abc') not clustered
POSTHOOK: type: ALTERTABLE_CLUSTER_SORT
POSTHOOK: Input: default@alter_table_partition_clusterby_sortby
POSTHOOK: Input: default@alter_table_partition_clusterby_sortby@c=abc
@@ -139,9 +151,13 @@ Bucket Columns: []
Sort Columns: []
Storage Desc Params:
serialization.format 1
-PREHOOK: query: desc formatted alter_table_partition_clusterby_sortby
+PREHOOK: query: -- Table properties should be unchanged
+
+desc formatted alter_table_partition_clusterby_sortby
PREHOOK: type: DESCTABLE
-POSTHOOK: query: desc formatted alter_table_partition_clusterby_sortby
+POSTHOOK: query: -- Table properties should be unchanged
+
+desc formatted alter_table_partition_clusterby_sortby
POSTHOOK: type: DESCTABLE
# col_name data_type comment
Modified: hive/trunk/ql/src/test/results/clientpositive/alter_partition_coltype.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/alter_partition_coltype.q.out?rev=1466300&r1=1466299&r2=1466300&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/alter_partition_coltype.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/alter_partition_coltype.q.out Wed Apr 10 00:06:55 2013
@@ -1,13 +1,17 @@
-PREHOOK: query: create table alter_coltype(key string, value string) partitioned by (dt string, ts string)
+PREHOOK: query: -- create testing table.
+create table alter_coltype(key string, value string) partitioned by (dt string, ts string)
PREHOOK: type: CREATETABLE
-POSTHOOK: query: create table alter_coltype(key string, value string) partitioned by (dt string, ts string)
+POSTHOOK: query: -- create testing table.
+create table alter_coltype(key string, value string) partitioned by (dt string, ts string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@alter_coltype
-PREHOOK: query: insert overwrite table alter_coltype partition(dt='100x', ts='6:30pm') select * from src1
+PREHOOK: query: -- insert and create a partition.
+insert overwrite table alter_coltype partition(dt='100x', ts='6:30pm') select * from src1
PREHOOK: type: QUERY
PREHOOK: Input: default@src1
PREHOOK: Output: default@alter_coltype@dt=100x/ts=6%3A30pm
-POSTHOOK: query: insert overwrite table alter_coltype partition(dt='100x', ts='6:30pm') select * from src1
+POSTHOOK: query: -- insert and create a partition.
+insert overwrite table alter_coltype partition(dt='100x', ts='6:30pm') select * from src1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src1
POSTHOOK: Output: default@alter_coltype@dt=100x/ts=6%3A30pm
@@ -31,12 +35,14 @@ ts string
dt string None
ts string None
-PREHOOK: query: select count(*) from alter_coltype where dt = '100x'
+PREHOOK: query: -- select with paritition predicate.
+select count(*) from alter_coltype where dt = '100x'
PREHOOK: type: QUERY
PREHOOK: Input: default@alter_coltype
PREHOOK: Input: default@alter_coltype@dt=100x/ts=6%3A30pm
#### A masked pattern was here ####
-POSTHOOK: query: select count(*) from alter_coltype where dt = '100x'
+POSTHOOK: query: -- select with paritition predicate.
+select count(*) from alter_coltype where dt = '100x'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alter_coltype
POSTHOOK: Input: default@alter_coltype@dt=100x/ts=6%3A30pm
@@ -44,20 +50,24 @@ POSTHOOK: Input: default@alter_coltype@d
POSTHOOK: Lineage: alter_coltype PARTITION(dt=100x,ts=6:30pm).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: alter_coltype PARTITION(dt=100x,ts=6:30pm).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
25
-PREHOOK: query: alter table alter_coltype partition column (dt int)
+PREHOOK: query: -- alter partition key column data type for dt column.
+alter table alter_coltype partition column (dt int)
PREHOOK: type: null
PREHOOK: Input: default@alter_coltype
-POSTHOOK: query: alter table alter_coltype partition column (dt int)
+POSTHOOK: query: -- alter partition key column data type for dt column.
+alter table alter_coltype partition column (dt int)
POSTHOOK: type: null
POSTHOOK: Input: default@alter_coltype
POSTHOOK: Output: default@alter_coltype
POSTHOOK: Lineage: alter_coltype PARTITION(dt=100x,ts=6:30pm).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: alter_coltype PARTITION(dt=100x,ts=6:30pm).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: insert overwrite table alter_coltype partition(dt=10, ts='3.0') select * from src1
+PREHOOK: query: -- load a new partition using new data type.
+insert overwrite table alter_coltype partition(dt=10, ts='3.0') select * from src1
PREHOOK: type: QUERY
PREHOOK: Input: default@src1
PREHOOK: Output: default@alter_coltype@dt=10/ts=3.0
-POSTHOOK: query: insert overwrite table alter_coltype partition(dt=10, ts='3.0') select * from src1
+POSTHOOK: query: -- load a new partition using new data type.
+insert overwrite table alter_coltype partition(dt=10, ts='3.0') select * from src1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src1
POSTHOOK: Output: default@alter_coltype@dt=10/ts=3.0
@@ -65,12 +75,14 @@ POSTHOOK: Lineage: alter_coltype PARTITI
POSTHOOK: Lineage: alter_coltype PARTITION(dt=10,ts=3.0).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: alter_coltype PARTITION(dt=100x,ts=6:30pm).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: alter_coltype PARTITION(dt=100x,ts=6:30pm).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: select count(*) from alter_coltype where dt = '100x'
+PREHOOK: query: -- make sure the partition predicate still works.
+select count(*) from alter_coltype where dt = '100x'
PREHOOK: type: QUERY
PREHOOK: Input: default@alter_coltype
PREHOOK: Input: default@alter_coltype@dt=100x/ts=6%3A30pm
#### A masked pattern was here ####
-POSTHOOK: query: select count(*) from alter_coltype where dt = '100x'
+POSTHOOK: query: -- make sure the partition predicate still works.
+select count(*) from alter_coltype where dt = '100x'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alter_coltype
POSTHOOK: Input: default@alter_coltype@dt=100x/ts=6%3A30pm
@@ -218,10 +230,12 @@ POSTHOOK: Lineage: alter_coltype PARTITI
POSTHOOK: Lineage: alter_coltype PARTITION(dt=100x,ts=6:30pm).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: alter_coltype PARTITION(dt=100x,ts=6:30pm).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
0
-PREHOOK: query: alter table alter_coltype partition column (ts double)
+PREHOOK: query: -- alter partition key column data type for ts column.
+alter table alter_coltype partition column (ts double)
PREHOOK: type: null
PREHOOK: Input: default@alter_coltype
-POSTHOOK: query: alter table alter_coltype partition column (ts double)
+POSTHOOK: query: -- alter partition key column data type for ts column.
+alter table alter_coltype partition column (ts double)
POSTHOOK: type: null
POSTHOOK: Input: default@alter_coltype
POSTHOOK: Output: default@alter_coltype
@@ -229,11 +243,13 @@ POSTHOOK: Lineage: alter_coltype PARTITI
POSTHOOK: Lineage: alter_coltype PARTITION(dt=10,ts=3.0).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: alter_coltype PARTITION(dt=100x,ts=6:30pm).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: alter_coltype PARTITION(dt=100x,ts=6:30pm).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: insert overwrite table alter_coltype partition(dt='100x', ts=3.0) select * from src1
+PREHOOK: query: -- load a new partition using new data type.
+insert overwrite table alter_coltype partition(dt='100x', ts=3.0) select * from src1
PREHOOK: type: QUERY
PREHOOK: Input: default@src1
PREHOOK: Output: default@alter_coltype@dt=100x/ts=3.0
-POSTHOOK: query: insert overwrite table alter_coltype partition(dt='100x', ts=3.0) select * from src1
+POSTHOOK: query: -- load a new partition using new data type.
+insert overwrite table alter_coltype partition(dt='100x', ts=3.0) select * from src1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src1
POSTHOOK: Output: default@alter_coltype@dt=100x/ts=3.0
@@ -243,12 +259,14 @@ POSTHOOK: Lineage: alter_coltype PARTITI
POSTHOOK: Lineage: alter_coltype PARTITION(dt=100x,ts=3.0).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: alter_coltype PARTITION(dt=100x,ts=6:30pm).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: alter_coltype PARTITION(dt=100x,ts=6:30pm).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: select count(*) from alter_coltype where ts = '6:30pm'
+PREHOOK: query: -- validate partition key column predicate can still work.
+select count(*) from alter_coltype where ts = '6:30pm'
PREHOOK: type: QUERY
PREHOOK: Input: default@alter_coltype
PREHOOK: Input: default@alter_coltype@dt=100x/ts=6%3A30pm
#### A masked pattern was here ####
-POSTHOOK: query: select count(*) from alter_coltype where ts = '6:30pm'
+POSTHOOK: query: -- validate partition key column predicate can still work.
+select count(*) from alter_coltype where ts = '6:30pm'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alter_coltype
POSTHOOK: Input: default@alter_coltype@dt=100x/ts=6%3A30pm
@@ -385,14 +403,18 @@ STAGE PLANS:
limit: -1
-PREHOOK: query: select count(*) from alter_coltype where ts = 3.0 and dt=10
+PREHOOK: query: -- validate partition key column predicate on two different partition column data type
+-- can still work.
+select count(*) from alter_coltype where ts = 3.0 and dt=10
PREHOOK: type: QUERY
PREHOOK: Input: default@alter_coltype
PREHOOK: Input: default@alter_coltype@dt=10/ts=3.0
PREHOOK: Input: default@alter_coltype@dt=100x/ts=3.0
PREHOOK: Input: default@alter_coltype@dt=100x/ts=6%3A30pm
#### A masked pattern was here ####
-POSTHOOK: query: select count(*) from alter_coltype where ts = 3.0 and dt=10
+POSTHOOK: query: -- validate partition key column predicate on two different partition column data type
+-- can still work.
+select count(*) from alter_coltype where ts = 3.0 and dt=10
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alter_coltype
POSTHOOK: Input: default@alter_coltype@dt=10/ts=3.0
@@ -630,14 +652,16 @@ STAGE PLANS:
limit: -1
-PREHOOK: query: select key, value, dt, ts from alter_coltype where dt is not null
+PREHOOK: query: -- query where multiple partition values (of different datatypes) are being selected
+select key, value, dt, ts from alter_coltype where dt is not null
PREHOOK: type: QUERY
PREHOOK: Input: default@alter_coltype
PREHOOK: Input: default@alter_coltype@dt=10/ts=3.0
PREHOOK: Input: default@alter_coltype@dt=100x/ts=3.0
PREHOOK: Input: default@alter_coltype@dt=100x/ts=6%3A30pm
#### A masked pattern was here ####
-POSTHOOK: query: select key, value, dt, ts from alter_coltype where dt is not null
+POSTHOOK: query: -- query where multiple partition values (of different datatypes) are being selected
+select key, value, dt, ts from alter_coltype where dt is not null
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alter_coltype
POSTHOOK: Input: default@alter_coltype@dt=10/ts=3.0
@@ -951,14 +975,16 @@ POSTHOOK: Lineage: alter_coltype PARTITI
POSTHOOK: Lineage: alter_coltype PARTITION(dt=100x,ts=6:30pm).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: alter_coltype PARTITION(dt=100x,ts=6:30pm).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
50
-PREHOOK: query: select count(*) from alter_coltype where dt = '100x' or dt = '10'
+PREHOOK: query: -- make sure the partition predicate still works.
+select count(*) from alter_coltype where dt = '100x' or dt = '10'
PREHOOK: type: QUERY
PREHOOK: Input: default@alter_coltype
PREHOOK: Input: default@alter_coltype@dt=10/ts=3.0
PREHOOK: Input: default@alter_coltype@dt=100x/ts=3.0
PREHOOK: Input: default@alter_coltype@dt=100x/ts=6%3A30pm
#### A masked pattern was here ####
-POSTHOOK: query: select count(*) from alter_coltype where dt = '100x' or dt = '10'
+POSTHOOK: query: -- make sure the partition predicate still works.
+select count(*) from alter_coltype where dt = '100x' or dt = '10'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alter_coltype
POSTHOOK: Input: default@alter_coltype@dt=10/ts=3.0
Modified: hive/trunk/ql/src/test/results/clientpositive/alter_partition_protect_mode.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/alter_partition_protect_mode.q.out?rev=1466300&r1=1466299&r2=1466300&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/alter_partition_protect_mode.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/alter_partition_protect_mode.q.out Wed Apr 10 00:06:55 2013
@@ -1,12 +1,16 @@
-PREHOOK: query: create table if not exists alter_part_protect_mode(key string, value string ) partitioned by (year string, month string) stored as textfile
+PREHOOK: query: -- Create table
+create table if not exists alter_part_protect_mode(key string, value string ) partitioned by (year string, month string) stored as textfile
PREHOOK: type: CREATETABLE
-POSTHOOK: query: create table if not exists alter_part_protect_mode(key string, value string ) partitioned by (year string, month string) stored as textfile
+POSTHOOK: query: -- Create table
+create table if not exists alter_part_protect_mode(key string, value string ) partitioned by (year string, month string) stored as textfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@alter_part_protect_mode
-PREHOOK: query: load data local inpath '../data/files/T1.txt' overwrite into table alter_part_protect_mode partition (year='1996', month='10')
+PREHOOK: query: -- Load data
+load data local inpath '../data/files/T1.txt' overwrite into table alter_part_protect_mode partition (year='1996', month='10')
PREHOOK: type: LOAD
PREHOOK: Output: default@alter_part_protect_mode
-POSTHOOK: query: load data local inpath '../data/files/T1.txt' overwrite into table alter_part_protect_mode partition (year='1996', month='10')
+POSTHOOK: query: -- Load data
+load data local inpath '../data/files/T1.txt' overwrite into table alter_part_protect_mode partition (year='1996', month='10')
POSTHOOK: type: LOAD
POSTHOOK: Output: default@alter_part_protect_mode
POSTHOOK: Output: default@alter_part_protect_mode@year=1996/month=10
@@ -31,12 +35,14 @@ POSTHOOK: query: load data local inpath
POSTHOOK: type: LOAD
POSTHOOK: Output: default@alter_part_protect_mode
POSTHOOK: Output: default@alter_part_protect_mode@year=1994/month=07
-PREHOOK: query: alter table alter_part_protect_mode partition (year='1996') disable offline
+PREHOOK: query: -- offline
+alter table alter_part_protect_mode partition (year='1996') disable offline
PREHOOK: type: ALTERPARTITION_PROTECTMODE
PREHOOK: Input: default@alter_part_protect_mode
PREHOOK: Output: default@alter_part_protect_mode@year=1996/month=10
PREHOOK: Output: default@alter_part_protect_mode@year=1996/month=12
-POSTHOOK: query: alter table alter_part_protect_mode partition (year='1996') disable offline
+POSTHOOK: query: -- offline
+alter table alter_part_protect_mode partition (year='1996') disable offline
POSTHOOK: type: ALTERPARTITION_PROTECTMODE
POSTHOOK: Input: default@alter_part_protect_mode
POSTHOOK: Input: default@alter_part_protect_mode@year=1996/month=10
@@ -101,12 +107,14 @@ POSTHOOK: Input: default@alter_part_prot
7 17 1995 09
8 18 1995 09
8 28 1995 09
-PREHOOK: query: alter table alter_part_protect_mode partition (year='1996') enable no_drop
+PREHOOK: query: -- no_drop
+alter table alter_part_protect_mode partition (year='1996') enable no_drop
PREHOOK: type: ALTERPARTITION_PROTECTMODE
PREHOOK: Input: default@alter_part_protect_mode
PREHOOK: Output: default@alter_part_protect_mode@year=1996/month=10
PREHOOK: Output: default@alter_part_protect_mode@year=1996/month=12
-POSTHOOK: query: alter table alter_part_protect_mode partition (year='1996') enable no_drop
+POSTHOOK: query: -- no_drop
+alter table alter_part_protect_mode partition (year='1996') enable no_drop
POSTHOOK: type: ALTERPARTITION_PROTECTMODE
POSTHOOK: Input: default@alter_part_protect_mode
POSTHOOK: Input: default@alter_part_protect_mode@year=1996/month=10
@@ -147,12 +155,14 @@ POSTHOOK: query: alter table alter_part_
POSTHOOK: type: ALTERTABLE_DROPPARTS
POSTHOOK: Input: default@alter_part_protect_mode
POSTHOOK: Output: default@alter_part_protect_mode@year=1994/month=07
-PREHOOK: query: alter table alter_part_protect_mode partition (year='1996') disable no_drop
+PREHOOK: query: -- Cleanup
+alter table alter_part_protect_mode partition (year='1996') disable no_drop
PREHOOK: type: ALTERPARTITION_PROTECTMODE
PREHOOK: Input: default@alter_part_protect_mode
PREHOOK: Output: default@alter_part_protect_mode@year=1996/month=10
PREHOOK: Output: default@alter_part_protect_mode@year=1996/month=12
-POSTHOOK: query: alter table alter_part_protect_mode partition (year='1996') disable no_drop
+POSTHOOK: query: -- Cleanup
+alter table alter_part_protect_mode partition (year='1996') disable no_drop
POSTHOOK: type: ALTERPARTITION_PROTECTMODE
POSTHOOK: Input: default@alter_part_protect_mode
POSTHOOK: Input: default@alter_part_protect_mode@year=1996/month=10
Modified: hive/trunk/ql/src/test/results/clientpositive/alter_partition_with_whitelist.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/alter_partition_with_whitelist.q.out?rev=1466300&r1=1466299&r2=1466300&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/alter_partition_with_whitelist.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/alter_partition_with_whitelist.q.out Wed Apr 10 00:06:55 2013
@@ -1,6 +1,10 @@
-PREHOOK: query: CREATE TABLE part_whitelist_test (key STRING, value STRING) PARTITIONED BY (ds STRING)
+PREHOOK: query: -- This pattern matches only letters.
+
+CREATE TABLE part_whitelist_test (key STRING, value STRING) PARTITIONED BY (ds STRING)
PREHOOK: type: CREATETABLE
-POSTHOOK: query: CREATE TABLE part_whitelist_test (key STRING, value STRING) PARTITIONED BY (ds STRING)
+POSTHOOK: query: -- This pattern matches only letters.
+
+CREATE TABLE part_whitelist_test (key STRING, value STRING) PARTITIONED BY (ds STRING)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@part_whitelist_test
PREHOOK: query: SHOW PARTITIONS part_whitelist_test
Modified: hive/trunk/ql/src/test/results/clientpositive/alter_rename_partition.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/alter_rename_partition.q.out?rev=1466300&r1=1466299&r2=1466300&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/alter_rename_partition.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/alter_rename_partition.q.out Wed Apr 10 00:06:55 2013
@@ -1,6 +1,8 @@
-PREHOOK: query: DROP TABLE alter_rename_partition_src
+PREHOOK: query: -- Cleanup
+DROP TABLE alter_rename_partition_src
PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE alter_rename_partition_src
+POSTHOOK: query: -- Cleanup
+DROP TABLE alter_rename_partition_src
POSTHOOK: type: DROPTABLE
PREHOOK: query: DROP TABLE alter_rename_partition
PREHOOK: type: DROPTABLE
@@ -103,11 +105,13 @@ POSTHOOK: Lineage: alter_rename_partitio
4 new_part1: new_part2:
5 new_part1: new_part2:
6 new_part1: new_part2:
-PREHOOK: query: DROP TABLE alter_rename_partition_src
+PREHOOK: query: -- Cleanup
+DROP TABLE alter_rename_partition_src
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@alter_rename_partition_src
PREHOOK: Output: default@alter_rename_partition_src
-POSTHOOK: query: DROP TABLE alter_rename_partition_src
+POSTHOOK: query: -- Cleanup
+DROP TABLE alter_rename_partition_src
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@alter_rename_partition_src
POSTHOOK: Output: default@alter_rename_partition_src
@@ -134,9 +138,13 @@ src_thrift
srcbucket
srcbucket2
srcpart
-PREHOOK: query: CREATE DATABASE alter_rename_partition_db
+PREHOOK: query: -- With non-default Database
+
+CREATE DATABASE alter_rename_partition_db
PREHOOK: type: CREATEDATABASE
-POSTHOOK: query: CREATE DATABASE alter_rename_partition_db
+POSTHOOK: query: -- With non-default Database
+
+CREATE DATABASE alter_rename_partition_db
POSTHOOK: type: CREATEDATABASE
POSTHOOK: Lineage: alter_rename_partition PARTITION(pcol1=old_part1:,pcol2=old_part2:).col1 SIMPLE [(alter_rename_partition_src)alter_rename_partition_src.FieldSchema(name:col1, type:string, comment:null), ]
PREHOOK: query: USE alter_rename_partition_db
Modified: hive/trunk/ql/src/test/results/clientpositive/alter_rename_partition_authorization.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/alter_rename_partition_authorization.q.out?rev=1466300&r1=1466299&r2=1466300&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/alter_rename_partition_authorization.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/alter_rename_partition_authorization.q.out Wed Apr 10 00:06:55 2013
@@ -1,7 +1,11 @@
-PREHOOK: query: create table src_auth_tmp as select * from src
+PREHOOK: query: -- SORT_BEFORE_DIFF
+
+create table src_auth_tmp as select * from src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
-POSTHOOK: query: create table src_auth_tmp as select * from src
+POSTHOOK: query: -- SORT_BEFORE_DIFF
+
+create table src_auth_tmp as select * from src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
POSTHOOK: Output: default@src_auth_tmp
@@ -24,10 +28,12 @@ PREHOOK: Output: default@src_auth_tmp
POSTHOOK: query: grant select on table src_auth_tmp to user hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
POSTHOOK: Output: default@src_auth_tmp
-PREHOOK: query: grant Create on table authorization_part to user hive_test_user
+PREHOOK: query: -- column grant to user
+grant Create on table authorization_part to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
PREHOOK: Output: default@authorization_part
-POSTHOOK: query: grant Create on table authorization_part to user hive_test_user
+POSTHOOK: query: -- column grant to user
+grant Create on table authorization_part to user hive_test_user
POSTHOOK: type: GRANT_PRIVILEGE
POSTHOOK: Output: default@authorization_part
PREHOOK: query: grant Update on table authorization_part to user hive_test_user
Modified: hive/trunk/ql/src/test/results/clientpositive/alter_table_serde.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/alter_table_serde.q.out?rev=1466300&r1=1466299&r2=1466300&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/alter_table_serde.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/alter_table_serde.q.out Wed Apr 10 00:06:55 2013
@@ -1,6 +1,8 @@
-PREHOOK: query: create table test_table (id int, query string, name string)
+PREHOOK: query: -- test table
+create table test_table (id int, query string, name string)
PREHOOK: type: CREATETABLE
-POSTHOOK: query: create table test_table (id int, query string, name string)
+POSTHOOK: query: -- test table
+create table test_table (id int, query string, name string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@test_table
PREHOOK: query: describe extended test_table
@@ -60,9 +62,11 @@ POSTHOOK: query: drop table test_table
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@test_table
POSTHOOK: Output: default@test_table
-PREHOOK: query: create table test_table (id int, query string, name string) partitioned by (dt string)
+PREHOOK: query: --- test partitioned table
+create table test_table (id int, query string, name string) partitioned by (dt string)
PREHOOK: type: CREATETABLE
-POSTHOOK: query: create table test_table (id int, query string, name string) partitioned by (dt string)
+POSTHOOK: query: --- test partitioned table
+create table test_table (id int, query string, name string) partitioned by (dt string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@test_table
PREHOOK: query: alter table test_table add partition (dt = '2011')
@@ -139,11 +143,15 @@ dt string
dt string None
#### A masked pattern was here ####
-PREHOOK: query: alter table test_table partition(dt='2011') set serde 'org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe'
+PREHOOK: query: -- test partitions
+
+alter table test_table partition(dt='2011') set serde 'org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe'
PREHOOK: type: ALTERPARTITION_SERIALIZER
PREHOOK: Input: default@test_table
PREHOOK: Output: default@test_table@dt=2011
-POSTHOOK: query: alter table test_table partition(dt='2011') set serde 'org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe'
+POSTHOOK: query: -- test partitions
+
+alter table test_table partition(dt='2011') set serde 'org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe'
POSTHOOK: type: ALTERPARTITION_SERIALIZER
POSTHOOK: Input: default@test_table
POSTHOOK: Input: default@test_table@dt=2011
Modified: hive/trunk/ql/src/test/results/clientpositive/alter_table_serde2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/alter_table_serde2.q.out?rev=1466300&r1=1466299&r2=1466300&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/alter_table_serde2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/alter_table_serde2.q.out Wed Apr 10 00:06:55 2013
@@ -1,6 +1,12 @@
-PREHOOK: query: CREATE TABLE tst1(key STRING, value STRING) PARTITIONED BY (ds STRING)
+PREHOOK: query: -- Tests that when overwriting a partition in a table after altering the serde properties
+-- the partition metadata is updated as well.
+
+CREATE TABLE tst1(key STRING, value STRING) PARTITIONED BY (ds STRING)
PREHOOK: type: CREATETABLE
-POSTHOOK: query: CREATE TABLE tst1(key STRING, value STRING) PARTITIONED BY (ds STRING)
+POSTHOOK: query: -- Tests that when overwriting a partition in a table after altering the serde properties
+-- the partition metadata is updated as well.
+
+CREATE TABLE tst1(key STRING, value STRING) PARTITIONED BY (ds STRING)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@tst1
PREHOOK: query: DESCRIBE FORMATTED tst1
@@ -87,11 +93,15 @@ Bucket Columns: []
Sort Columns: []
Storage Desc Params:
serialization.format 1
-PREHOOK: query: ALTER TABLE tst1 SET SERDEPROPERTIES ('field.delim' = ',')
+PREHOOK: query: -- Test altering the serde properties
+
+ALTER TABLE tst1 SET SERDEPROPERTIES ('field.delim' = ',')
PREHOOK: type: ALTERTABLE_SERDEPROPERTIES
PREHOOK: Input: default@tst1
PREHOOK: Output: default@tst1
-POSTHOOK: query: ALTER TABLE tst1 SET SERDEPROPERTIES ('field.delim' = ',')
+POSTHOOK: query: -- Test altering the serde properties
+
+ALTER TABLE tst1 SET SERDEPROPERTIES ('field.delim' = ',')
POSTHOOK: type: ALTERTABLE_SERDEPROPERTIES
POSTHOOK: Input: default@tst1
POSTHOOK: Output: default@tst1