hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hive QA (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-15072) Schematool should recognize missing tables in metastore
Date Fri, 18 Nov 2016 21:21:58 GMT

    [ https://issues.apache.org/jira/browse/HIVE-15072?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15677785#comment-15677785
] 

Hive QA commented on HIVE-15072:
--------------------------------



Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12839609/HIVE-15072.patch

{color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified.

{color:red}ERROR:{color} -1 due to 10 failed/errored test(s), 10579 tests executed
*Failed tests:*
{noformat}
TestCliDriver - did not produce a TEST-*.xml file (likely timed out) (batchId=1)
	[udf_upper.q,ctas_date.q,schema_evol_orc_acidvec_table_update.q,groupby_grouping_sets3.q,vector_decimal_5.q,bucket_map_join_spark4.q,select_unquote_and.q,timestamp_2.q,date_join1.q,constprog_type.q,timestamp_ints_casts.q,udf_negative.q,orc_merge_diff_fs.q,udf_substring_index.q,newline.q,diff_part_input_formats.q,auto_join_without_localtask.q,tez_bmj_schema_evolution.q,bucketmapjoin4.q,udf_date_sub.q,udf_context_aware.q,groupby2_noskew.q,authorization_non_id.q,sample_islocalmode_hook_hadoop20.q,auto_sortmerge_join_3.q,mapjoin_test_outer.q,vectorization_9.q,input15.q,groupby6_noskew.q,udf_PI.q]
TestCliDriver - did not produce a TEST-*.xml file (likely timed out) (batchId=13)
	[avro_joins.q,authorization_create_temp_table.q,exim_00_nonpart_empty.q,annotate_stats_join_pkfk.q,describe_comment_nonascii.q,orc_analyze.q,subquery_views.q,partition_date.q,tez_join_result_complex.q,input36.q,alter_numbuckets_partitioned_table2_h23.q,transform_ppr1.q,spark_vectorized_dynamic_partition_pruning.q,load_orc_part.q,compute_stats_double.q,authorization_index.q,auto_join14.q,vectorization_14.q,authorization_1.q,windowing_udaf2.q,fold_case.q,stats1.q,list_bucket_dml_3.q,alter_table_partition_drop.q,cbo_stats.q,parquet_types_vectorization.q,union_view.q,insert_dir_distcp.q,smb_mapjoin_22.q,autoColumnStats_8.q]
TestCliDriver - did not produce a TEST-*.xml file (likely timed out) (batchId=17)
	[encryption_move_tbl.q,ppd_join3.q,auto_join23.q,list_bucket_dml_11.q,join10.q,cbo_rp_udf_percentile2.q,udf_lower.q,constprog_dp.q,create_struct_table.q,groupby_multi_single_reducer2.q,skewjoin_mapjoin9.q,offset_limit_global_optimizer.q,hook_context_cs.q,exim_22_import_exist_authsuccess.q,create_func1.q,create_skewed_table1.q,partition_wise_fileformat.q,authorization_view_1.q,show_tables.q,orc_empty_files.q,union_ppr.q,stats_partial_size.q,join32.q,list_bucket_dml_14.q,exim_24_import_nonexist_authsuccess.q,udf_parse_url.q,ansi_sql_arithmetic.q,join26.q,schema_evol_text_nonvec_part.q,ctas_char.q]
TestCliDriver - did not produce a TEST-*.xml file (likely timed out) (batchId=3)
	[join_cond_pushdown_unqual4.q,join13.q,list_bucket_query_oneskew_2.q,explainanalyze_1.q,ppr_pushdown2.q,sample3.q,druid_topn.q,tablename_with_select.q,smb_mapjoin_19.q,subquery_in_explain_rewrite.q,union23.q,subquery_exists_having.q,partition_wise_fileformat5.q,udf_trunc.q,llapdecider.q,avro_partitioned.q,orc_null_check.q,view_inputs.q,union31.q,ptf_decimal.q,extract.q,dynpart_sort_optimization2.q,cbo_rp_auto_join1.q,display_colstats_tbllvl.q,macro.q,split.q,authorization_explain.q,hook_order.q,pointlookup.q,bucketmapjoin2.q]
TestCliDriver - did not produce a TEST-*.xml file (likely timed out) (batchId=5)
	[ptf_general_queries.q,correlationoptimizer9.q,auto_join_reordering_values.q,sample2.q,decimal_join.q,mapjoin_subquery2.q,join43.q,bucket_if_with_path_filter.q,udf_month.q,mapjoin1.q,avro_partitioned_native.q,join25.q,nullformatdir.q,authorization_admin_almighty1.q,udf_avg.q,cte_mat_4.q,groupby3.q,cbo_rp_union.q,udaf_covar_samp.q,exim_03_nonpart_over_compat.q,udf_logged_in_user.q,index_stale.q,union12.q,skewjoinopt2.q,skewjoinopt18.q,colstats_all_nulls.q,bucketsortoptimize_insert_2.q,quote2.q,udf_classloader.q,authorization_owner_actions.q]
org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[transform_ppr2] (batchId=133)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[join_acid_non_acid] (batchId=150)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[union_fast_stats] (batchId=145)
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[explainanalyze_3] (batchId=90)
org.apache.hadoop.hive.thrift.TestHadoopAuthBridge23.testSaslWithHiveMetaStore (batchId=216)
{noformat}

Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/2199/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/2199/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-2199/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
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: 10 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12839609 - PreCommit-HIVE-Build

> Schematool should recognize missing tables in metastore
> -------------------------------------------------------
>
>                 Key: HIVE-15072
>                 URL: https://issues.apache.org/jira/browse/HIVE-15072
>             Project: Hive
>          Issue Type: Sub-task
>          Components: Metastore
>            Reporter: Yongzhi Chen
>            Assignee: Naveen Gangam
>         Attachments: HIVE-15072.patch
>
>
> When Install a new database failed half way(for some other reasons), not all of the metastore
tables are installed. This caused HMS server failed to start up due to missing tables. Re-run
the Schematool, It ran successfully, and in the stdout log said: "Database already has tables.
Skipping table creation".
> However, restarting HMS getting the same error reporting missing tables.
> Schematool should detect missing tables and provide options to go ahead and recreate
missing tables in the case of new installation



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message