[
https://issues.apache.org/jira/browse/HIVE-9119?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14256192#comment-14256192
]
Hive QA commented on HIVE-9119:
-------------------------------
{color:red}Overall{color}: -1 at least one tests failed
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12688616/HIVE-9119.1.patch
{color:red}ERROR:{color} -1 due to 155 failed/errored test(s), 4134 tests
executed
*Failed tests:*
{noformat}
TestCliDriver-alter_char2.q-insert_compressed.q-load_dyn_part15.q-and-12-more -
did not produce a TEST-*.xml file
TestCliDriver-alter_table_not_sorted.q-authorization_update.q-dynamic_partition_pruning.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-authorization_1_sql_std.q-drop_index_removes_partition_dirs.q-udf_date_sub.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-authorization_cli_createtab.q-groupby_ppr.q-limit_pushdown_negative.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-authorization_cli_nonsql.q-rcfile_merge1.q-stats2.q-and-12-more -
did not produce a TEST-*.xml file
TestCliDriver-authorization_cli_stdconfigauth.q-drop_partitions_filter2.q-bucketmapjoin1.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-authorization_create_table_owner_privs.q-create_func1.q-partition_wise_fileformat.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-auto_join18_multi_distinct.q-udf_repeat.q-list_bucket_query_multiskew_2.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-auto_join30.q-join_reorder3.q-lock1.q-and-12-more - did not
produce a TEST-*.xml file
TestCliDriver-auto_join4.q-mapjoin_decimal.q-input_dynamicserde.q-and-12-more -
did not produce a TEST-*.xml file
TestCliDriver-auto_join9.q-acid_vectorization.q-udf_floor.q-and-12-more - did
not produce a TEST-*.xml file
TestCliDriver-auto_sortmerge_join_13.q-alter_partition_clusterby_sortby.q-rcfile_merge2.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-autogen_colalias.q-tez_joins_explain.q-unicode_notation.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-avro_add_column.q-orc_wide_table.q-query_with_semi.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-avro_joins.q-disallow_incompatible_type_change_off.q-udf_max.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-bool_literal.q-udf_hash.q-groupby4_map.q-and-12-more - did not
produce a TEST-*.xml file
TestCliDriver-bucketcontext_5.q-udf_to_float.q-udf_locate.q-and-12-more - did
not produce a TEST-*.xml file
TestCliDriver-bucketmapjoin3.q-udf_round_3.q-udf_between.q-and-12-more - did
not produce a TEST-*.xml file
TestCliDriver-columnstats_partlvl_dp.q-smb_mapjoin_21.q-insert_overwrite_local_directory_1.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-columnstats_tbllvl.q-limit0.q-udf_exp.q-and-12-more - did not
produce a TEST-*.xml file
TestCliDriver-compute_stats_string.q-nullgroup4_multi_distinct.q-udf_concat_ws.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-cp_mj_rc.q-skewjoin_union_remove_2.q-udf_stddev_pop.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-create_genericudf.q-join13.q-notable_alias3.q-and-12-more - did
not produce a TEST-*.xml file
TestCliDriver-create_or_replace_view.q-skewjoinopt8.q-join_cond_pushdown_3.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-date_udf.q-transform_ppr2.q-udf_from_unixtime.q-and-12-more - did
not produce a TEST-*.xml file
TestCliDriver-decimal_6.q-vectorization_limit.q-authorization_index.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-describe_xpath.q-parquet_types.q-partcols1.q-and-12-more - did
not produce a TEST-*.xml file
TestCliDriver-dynpart_sort_optimization2.q-skewjoin_mapjoin4.q-list_bucket_dml_6.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-enforce_order.q-bucketcontext_4.q-stats_publisher_error_1.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-escape_distributeby1.q-create_view_partitioned.q-groupby_sort_7.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-gby_star.q-protectmode.q-udf_regexp_replace.q-and-12-more - did
not produce a TEST-*.xml file
TestCliDriver-groupby10.q-timestamp_comparison.q-tez_union.q-and-12-more - did
not produce a TEST-*.xml file
TestCliDriver-groupby12.q-udf2.q-udf_bigint.q-and-12-more - did not produce a
TEST-*.xml file
TestCliDriver-groupby3_map.q-plan_json.q-correlationoptimizer10.q-and-12-more -
did not produce a TEST-*.xml file
TestCliDriver-groupby4.q-reducesink_dedup.q-update_all_partitioned.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-groupby_complex_types.q-varchar_serde.q-groupby7_map_skew.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-groupby_grouping_sets5.q-desc_tbl_part_cols.q-decimal_2.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-groupby_map_ppr_multi_distinct.q-udf_regexp.q-groupby4_noskew.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-index_bitmap_rc.q-fileformat_sequencefile.q-repair.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-index_compact_2.q-lateral_view_cp.q-vectorized_bucketmapjoin1.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-infer_bucket_sort_grouping_operators.q-authorization_set_show_current_role.q-union21.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-infer_bucket_sort_list_bucket.q-bucketmapjoin4.q-show_tables.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-input11_limit.q-vector_non_string_partition.q-groupby_mutli_insert_common_distinct.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-input19.q-union_remove_7.q-cluster.q-and-12-more - did not
produce a TEST-*.xml file
TestCliDriver-input_part1.q-truncate_column_merge.q-auto_join13.q-and-12-more -
did not produce a TEST-*.xml file
TestCliDriver-join18.q-union11.q-dbtxnmgr_query5.q-and-12-more - did not
produce a TEST-*.xml file
TestCliDriver-join2.q-authorization_grant_public_role.q-ppd_gby2.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-join36.q-udf_bitwise_or.q-add_part_exist.q-and-12-more - did not
produce a TEST-*.xml file
TestCliDriver-join39.q-stats12.q-udf_upper.q-and-12-more - did not produce a
TEST-*.xml file
TestCliDriver-join_cond_pushdown_unqual4.q-vectorization_16.q-truncate_column_list_bucket.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-join_filters.q-bucketmapjoin12.q-alter_view_as_select.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-join_vc.q-select_unquote_not.q-archive_excludeHadoop20.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-lateral_view_noalias.q-cast1.q-vector_decimal_aggregate.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-list_bucket_dml_9.q-udf_E.q-cast_to_int.q-and-12-more - did not
produce a TEST-*.xml file
TestCliDriver-list_bucket_query_multiskew_1.q-date_comparison.q-union27.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-load_dyn_part12.q-groupby_grouping_sets3.q-exim_18_part_external.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-load_dyn_part5.q-ppd_constant_where.q-alter_view_rename.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-load_fs.q-partition_char.q-auto_join19.q-and-12-more - did not
produce a TEST-*.xml file
TestCliDriver-mapjoin_mapjoin.q-udf_to_unix_timestamp.q-join20.q-and-12-more -
did not produce a TEST-*.xml file
TestCliDriver-mapreduce5.q-udf_elt.q-groupby_ppd.q-and-12-more - did not
produce a TEST-*.xml file
TestCliDriver-nonblock_op_deduplicate.q-cbo_windowing.q-avro_decimal_native.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-nullinput.q-bucketcontext_3.q-udf_inline.q-and-12-more - did not
produce a TEST-*.xml file
TestCliDriver-nullscript.q-filter_join_breaktask.q-input43.q-and-12-more - did
not produce a TEST-*.xml file
TestCliDriver-optional_outer.q-union12.q-skewjoinopt5.q-and-12-more - did not
produce a TEST-*.xml file
TestCliDriver-orc_createas1.q-nestedvirtual.q-udf_when.q-and-12-more - did not
produce a TEST-*.xml file
TestCliDriver-orc_merge6.q-input44.q-smb_mapjoin_4.q-and-12-more - did not
produce a TEST-*.xml file
TestCliDriver-orc_ppd_decimal.q-orc_ends_with_nulls.q-tez_schema_evolution.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-parquet_avro_array_of_primitives.q-decimal_3.q-mapreduce2.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-part_inherit_tbl_props_with_star.q-truncate_table.q-auto_join25.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-partition_timestamp.q-bucketsortoptimize_insert_7.q-load_exist_part_authsuccess.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-ppd_gby_join.q-fileformat_text.q-authorization_5.q-and-12-more -
did not produce a TEST-*.xml file
TestCliDriver-ppd_join4.q-udf_xpath_string.q-escape2.q-and-12-more - did not
produce a TEST-*.xml file
TestCliDriver-ppd_outer_join2.q-groupby3_map_skew.q-merge_dynamic_partition2.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-ppd_transform.q-ptf_seqfile.q-list_bucket_dml_1.q-and-12-more -
did not produce a TEST-*.xml file
TestCliDriver-ppd_union.q-udf_var_samp.q-custom_input_output_format.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-protectmode2.q-bucketmapjoin10.q-skewjoinopt19.q-and-12-more -
did not produce a TEST-*.xml file
TestCliDriver-ptf_general_queries.q-ba_table1.q-exim_04_evolved_parts.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-rename_column.q-union2.q-acid_join.q-and-12-more - did not
produce a TEST-*.xml file
TestCliDriver-script_pipe.q-orc_split_elimination.q-udf_tan.q-and-12-more - did
not produce a TEST-*.xml file
TestCliDriver-show_columns.q-input31.q-udf_ceiling.q-and-12-more - did not
produce a TEST-*.xml file
TestCliDriver-show_conf.q-groupby2_noskew_multi_distinct.q-ptf_rcfile.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-skewjoin_mapjoin11.q-vectorization_10.q-join4.q-and-12-more - did
not produce a TEST-*.xml file
TestCliDriver-skewjoin_noskew.q-merge_dynamic_partition5.q-index_skewtable.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-skewjoinopt15.q-udf_percentile.q-join35.q-and-12-more - did not
produce a TEST-*.xml file
TestCliDriver-skewjoinopt16.q-udf_in_file.q-mapjoin_filter_on_outerjoin.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-skewjoinopt3.q-parquet_array_of_unannotated_primitives.q-input_part0.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-smb_mapjoin_15.q-groupby_grouping_id2.q-exim_07_all_part_over_nonoverlap.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-sort_merge_join_desc_1.q-join16.q-reduce_deduplicate_exclude_gby.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-sort_merge_join_desc_3.q-literal_double.q-tez_fsstat.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-str_to_map.q-binarysortable_1.q-orc_merge5.q-and-12-more - did
not produce a TEST-*.xml file
TestCliDriver-table_access_keys_stats.q-show_tblproperties.q-annotate_stats_groupby2.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-temp_table_display_colstats_tbllvl.q-union32.q-temp_table_gb1.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-timestamp_lazy.q-bucketsortoptimize_insert_4.q-input41.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-timestamp_literal.q-input17.q-bucket_map_join_tez1.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-timestamp_null.q-udf_min.q-udf6.q-and-12-more - did not produce a
TEST-*.xml file
TestCliDriver-touch.q-infer_bucket_sort_multi_insert.q-udf_subtract.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-udaf_number_format.q-insert_update_delete.q-no_hooks.q-and-9-more
- did not produce a TEST-*.xml file
TestCliDriver-udf_bitmap_empty.q-multigroupby_singlemr.q-index_auto_update.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-udf_bitwise_and.q-authorization_role_grant2.q-auto_join18.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-udf_degrees.q-exchange_partition.q-bucketmapjoin_negative3.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-udf_double.q-orc_vectorization_ppd.q-udf_case_thrift.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-udf_lessthanorequal.q-auto_join23.q-partition_wise_fileformat10.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-udf_log2.q-avro_add_column3.q-join11.q-and-12-more - did not
produce a TEST-*.xml file
TestCliDriver-udf_notequal.q-vector_data_types.q-input10.q-and-12-more - did
not produce a TEST-*.xml file
TestCliDriver-udf_rpad.q-list_bucket_dml_2.q-authorization_cli_createtab_noauthzapi.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-udf_second.q-leadlag_queries.q-bucketmapjoin11.q-and-12-more -
did not produce a TEST-*.xml file
TestCliDriver-udf_testlength2.q-vector_decimal_10_0.q-type_conversions_1.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-udtf_explode.q-leadlag.q-udf_xpath_long.q-and-12-more - did not
produce a TEST-*.xml file
TestCliDriver-union_top_level.q-udf_size.q-union_remove_1.q-and-12-more - did
not produce a TEST-*.xml file
TestCliDriver-update_orig_table.q-udf_stddev.q-ppd_udf_case.q-and-12-more - did
not produce a TEST-*.xml file
TestCliDriver-varchar_join1.q-num_op_type_conv.q-auto_join0.q-and-12-more - did
not produce a TEST-*.xml file
TestCliDriver-varchar_nested_types.q-push_or.q-ctas_date.q-and-12-more - did
not produce a TEST-*.xml file
TestCliDriver-vector_coalesce.q-auto_join_reordering_values.q-auto_sortmerge_join_7.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-vector_decimal_round.q-metadata_export_drop.q-stats13.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-vector_distinct_2.q-groupby_sort_test_1.q-udf_array.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-vector_partition_diff_num_cols.q-inputddl8.q-auto_join24.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-vectorization_13.q-udf_explode.q-groupby_grouping_sets4.q-and-12-more
- did not produce a TEST-*.xml file
TestCliDriver-vectorized_parquet.q-ba_table_union.q-input2.q-and-12-more - did
not produce a TEST-*.xml file
TestCliDriver-view.q-join9.q-index_auth.q-and-12-more - did not produce a
TEST-*.xml file
TestCompareCliDriver - did not produce a TEST-*.xml file
TestContribCliDriver - did not produce a TEST-*.xml file
TestContribNegativeCliDriver - did not produce a TEST-*.xml file
TestHBaseCliDriver-hbase_binary_external_table_queries.q - did not produce a
TEST-*.xml file
TestHBaseCliDriver-hbase_binary_map_queries.q - did not produce a TEST-*.xml
file
TestHBaseCliDriver-hbase_binary_map_queries_prefix.q-hbase_stats.q-ppd_key_ranges.q
- did not produce a TEST-*.xml file
TestHBaseCliDriver-hbase_binary_storage_queries.q - did not produce a
TEST-*.xml file
TestHBaseCliDriver-hbase_handler_bulk.q-hbase_scan_params.q-hbase_single_sourced_multi_insert.q
- did not produce a TEST-*.xml file
TestHBaseCliDriver-hbase_handler_snapshot.q-hbase_stats3.q-hbase_custom_key3.q
- did not produce a TEST-*.xml file
TestHBaseCliDriver-hbase_joins.q - did not produce a TEST-*.xml file
TestHBaseCliDriver-hbase_ppd_key_range.q-hbase_custom_key.q-hbase_pushdown.q -
did not produce a TEST-*.xml file
TestHBaseCliDriver-hbase_queries.q - did not produce a TEST-*.xml file
TestHBaseCliDriver-hbase_stats2.q-hbase_custom_key2.q-hbase_timestamp.q - did
not produce a TEST-*.xml file
TestHBaseCliDriver-hbase_stats_empty_partition.q-external_table_ppd.q-hbase_ppd_join.q
- did not produce a TEST-*.xml file
TestHBaseMinimrCliDriver - did not produce a TEST-*.xml file
TestHBaseNegativeCliDriver - did not produce a TEST-*.xml file
TestLocationQueries - did not produce a TEST-*.xml file
TestMTQueries - did not produce a TEST-*.xml file
TestMiniTezCliDriver-script_pipe.q-mapjoin_decimal.q-transform_ppr2.q-and-12-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-bucketmapjoin6.q-constprog_partitioner.q-infer_bucket_sort_dyn_part.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-external_table_with_space_in_location_path.q-infer_bucket_sort_merge.q-auto_sortmerge_join_16.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-groupby2.q-import_exported_table.q-bucketizedhiveinputformat.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-index_bitmap3.q-stats_counter_partitioned.q-temp_table_external.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-infer_bucket_sort_map_operators.q-join1.q-bucketmapjoin7.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-infer_bucket_sort_num_buckets.q-disable_merge_for_bucketing.q-uber_reduce.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-infer_bucket_sort_reducers_power_two.q-scriptfile1.q-scriptfile1_win.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-leftsemijoin_mr.q-bucket5.q-root_dir_external_table.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-list_bucket_dml_10.q-bucket_num_reducers.q-bucket6.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-load_fs2.q-file_with_header_footer.q-ql_rewrite_gbtoidx_cbo_1.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-ql_rewrite_gbtoidx.q-parallel_orderby.q-reduce_deduplicate.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-schemeAuthority2.q-infer_bucket_sort_bucketed_table.q-bucket4.q-and-1-more
- did not produce a TEST-*.xml file
TestMinimrCliDriver-smb_mapjoin_8.q - did not produce a TEST-*.xml file
TestNegativeCliDriver-udf_invalid.q-nopart_insert.q-join_nonexistent_part.q-and-655-more
- did not produce a TEST-*.xml file
TestNegativeMinimrCliDriver-mapreduce_stack_trace_hadoop20.q - did not produce
a TEST-*.xml file
TestNegativeMinimrCliDriver-udf_local_resource.q-mapreduce_stack_trace_turnoff_hadoop20.q-mapreduce_stack_trace.q-and-5-more
- did not produce a TEST-*.xml file
TestParseNegative - did not produce a TEST-*.xml file
{noformat}
Test results:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/2163/testReport
Console output:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/2163/console
Test logs:
http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-2163/
Messages:
{noformat}
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 155 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12688616 - PreCommit-HIVE-TRUNK-Build
> ZooKeeperHiveLockManager does not use zookeeper in the proper way
> -----------------------------------------------------------------
>
> Key: HIVE-9119
> URL: https://issues.apache.org/jira/browse/HIVE-9119
> Project: Hive
> Issue Type: Improvement
> Components: Locking
> Affects Versions: 0.13.0, 0.14.0, 0.13.1
> Reporter: Na Yang
> Assignee: Na Yang
> Attachments: HIVE-9119.1.patch
>
>
> ZooKeeperHiveLockManager does not use zookeeper in the proper way.
> Currently a new zookeeper client instance is created for each
> getlock/releaselock query which sometimes causes the number of open
> connections between
> HiveServer2 and ZooKeeper exceed the max connection number that zookeeper
> server allows.
> To use zookeeper as a distributed lock, there is no need to create a new
> zookeeper instance for every getlock try. A single zookeeper instance could
> be reused and shared by ZooKeeperHiveLockManagers.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
