Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Works for Me
-
Impala 1.1.1
-
None
-
None
-
None
-
Centos 6.5 running CDH 4.4
Description
We are seeing one of our nodes crash with the attached log repeatedly. Not positive as to the query causing it but believe its the one below.
SELECT *
FROM vpc_bidder_history_test_20140710_2
WHERE year = '2014' AND month = '07' AND day = '09'
AND placement_details_app_id > 0
ORDER BY placement_logging_logging_time, placement_details_app_id, placement_details_placement_id
LIMIT 200
Table definition:
Table(tableName:vpc_bidder_history_test_20140710_2, dbName:default, owner:mchalson, createTime:1405026518, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:placement_details_placement_id, type:bigint, comment:null), FieldSchema(name:placement_details_set_id, type:bigint, comment:null), FieldSchema(name:placement_details_structure_id, type:bigint, comment:null), FieldSchema(name:placement_details_allocation_id, type:int, comment:null), FieldSchema(name:placement_details_campaign_id, type:int, comment:null), FieldSchema(name:placement_details_destination_id, type:bigint, comment:null), FieldSchema(name:placement_details_app_id, type:int, comment:null), FieldSchema(name:placement_details_pricing_bucket_id, type:bigint, comment:null), FieldSchema(name:placement_details_ad_plan_id, type:int, comment:null), FieldSchema(name:placement_details_credential_id, type:int, comment:null), FieldSchema(name:placement_details_demographic_set_id, type:int, comment:null), FieldSchema(name:placement_details_age_min, type:int, comment:null), FieldSchema(name:placement_details_age_max, type:int, comment:null), FieldSchema(name:placement_details_countries, type:string, comment:null), FieldSchema(name:placement_details_genders, type:string, comment:null), FieldSchema(name:placement_details_user_adclusters, type:string, comment:null), FieldSchema(name:placement_details_creative_set_id, type:int, comment:null), FieldSchema(name:placement_details_title, type:string, comment:null), FieldSchema(name:placement_details_body, type:string, comment:null), FieldSchema(name:placement_details_image_id, type:int, comment:null), FieldSchema(name:placement_details_type, type:int, comment:null), FieldSchema(name:placement_details_rtb_flag, type:tinyint, comment:null), FieldSchema(name:placement_details_ad_type, type:string, comment:null), FieldSchema(name:placement_details_page_types, type:string, comment:null), FieldSchema(name:placement_details_keyword_set_id, type:bigint, comment:null), FieldSchema(name:placement_details_network_config_set_id, type:bigint, comment:null), FieldSchema(name:placement_details_connections, type:string, comment:null), FieldSchema(name:placement_details_excluded_connections, type:string, comment:null), FieldSchema(name:placement_details_dark_page_post_id, type:bigint, comment:null), FieldSchema(name:placement_details_interest_behavior_hash, type:string, comment:null), FieldSchema(name:placement_details_demographic_hash, type:string, comment:null), FieldSchema(name:placement_logging_logging_time, type:bigint, comment:null), FieldSchema(name:placement_logging_invoker, type:string, comment:null), FieldSchema(name:placement_logging_experiment_tag, type:string, comment:null), FieldSchema(name:placement_bidder_final_vpx, type:float, comment:null), FieldSchema(name:placement_bidder_bid_basis, type:string, comment:null), FieldSchema(name:placement_bidder_ltv_scale, type:float, comment:null), FieldSchema(name:placement_bidder_bidder_last_bid, type:float, comment:null), FieldSchema(name:placement_bidder_placement_previous_bid, type:float, comment:null), FieldSchema(name:placement_bidder_new_bid, type:float, comment:null), FieldSchema(name:placement_bidder_initial_vpx, type:float, comment:null), FieldSchema(name:placement_bidder_click_boost, type:float, comment:null), FieldSchema(name:placement_bidder_pacing_adjust, type:float, comment:null), FieldSchema(name:placement_bidder_frequency_limiter, type:float, comment:null), FieldSchema(name:placement_bidder_gap_cap, type:float, comment:null), FieldSchema(name:placement_bidder_max_bid, type:float, comment:null), FieldSchema(name:placement_bidder_max_cost_bid, type:float, comment:null), FieldSchema(name:placement_bidder_max_cpa_bid, type:float, comment:null), FieldSchema(name:placement_bidder_min_bid, type:float, comment:null), FieldSchema(name:placement_bidder_click_boost_multiplier, type:float, comment:null), FieldSchema(name:placement_bidder_adjusted_gap_cap_bid, type:float, comment:null), FieldSchema(name:placement_bidder_gap_cap_bid, type:float, comment:null), FieldSchema(name:placement_bidder_hard_max_bid, type:string, comment:null), FieldSchema(name:placement_bidder_hard_min_bid, type:string, comment:null), FieldSchema(name:placement_bidder_frequency_bid_limit, type:float, comment:null), FieldSchema(name:asset_logging_placement_planning_key, type:string, comment:null), FieldSchema(name:asset_logging_placement_asset_key, type:string, comment:null), FieldSchema(name:asset_logging_placement_asset_state, type:string, comment:null), FieldSchema(name:asset_logging_placement_minimum_margin_percent, type:float, comment:null), FieldSchema(name:asset_logging_placement_target_margin_percent, type:float, comment:null), FieldSchema(name:asset_logging_placement_margin_adjust_decay, type:float, comment:null), FieldSchema(name:asset_logging_placement_change_frequency, type:float, comment:null), FieldSchema(name:asset_logging_placement_projected_volume, type:float, comment:null), FieldSchema(name:asset_logging_placement_day_actual, type:float, comment:null), FieldSchema(name:asset_logging_placement_budget_cents, type:float, comment:null), FieldSchema(name:asset_logging_placement_volume_track, type:float, comment:null), FieldSchema(name:asset_logging_placement_previous_placement_value_bid_scale, type:float, comment:null), FieldSchema(name:asset_logging_placement_previous_placement_last_adjust, type:bigint, comment:null), FieldSchema(name:asset_logging_placement_no_old_placement_value_bid_scale, type:string, comment:null), FieldSchema(name:asset_logging_placement_raise_placement_value_bid_scale_to_min_margin, type:string, comment:null), FieldSchema(name:asset_logging_placement_reduce_placement_value_bid_scale_to_target_margin, type:string, comment:null), FieldSchema(name:asset_logging_placement_longer_than_change_frequency_time, type:string, comment:null), FieldSchema(name:asset_logging_placement_asset_track_data_found, type:string, comment:null), FieldSchema(name:asset_logging_placement_decayed_value_bid_scale, type:float, comment:null), FieldSchema(name:asset_logging_placement_scale_factor, type:float, comment:null), FieldSchema(name:asset_logging_placement_placement_value_bid_scale, type:float, comment:null), FieldSchema(name:asset_logging_placement_default_value_bid_scale, type:float, comment:null), FieldSchema(name:asset_logging_placement_placement_last_adjust, type:bigint, comment:null), FieldSchema(name:asset_logging_placement_asset_volume_track_adjustment_algorithm, type:string, comment:null), FieldSchema(name:asset_logging_placement_asset_volume_track_unadjusted_volume_track, type:float, comment:null), FieldSchema(name:asset_logging_placement_asset_volume_track_global_volume_track, type:float, comment:null), FieldSchema(name:asset_logging_placement_asset_volume_track_weighted_average_pace, type:float, comment:null), FieldSchema(name:asset_logging_placement_asset_volume_track_final, type:float, comment:null), FieldSchema(name:asset_logging_placement_asset_volume_track_global_weight_algorithm, type:string, comment:null), FieldSchema(name:asset_logging_placement_asset_volume_track_global_weight_sum_global_wt, type:float, comment:null), FieldSchema(name:asset_logging_placement_cost_bid_pacing_bid_input_cost, type:string, comment:null), FieldSchema(name:asset_logging_placement_cost_bid_pacing_bid_result_bid, type:string, comment:null), FieldSchema(name:asset_logging_placement_cost_bid_pacing_bid_model_id, type:string, comment:null), FieldSchema(name:asset_logging_placement_cost_bid_pacing_bid_intercept, type:string, comment:null), FieldSchema(name:asset_logging_placement_cost_bid_pacing_bid_coeff_set, type:string, comment:null), FieldSchema(name:asset_logging_placement_cost_bid_min_margin_input_cost, type:string, comment:null), FieldSchema(name:asset_logging_placement_cost_bid_min_margin_result_bid, type:string, comment:null), FieldSchema(name:asset_logging_placement_cost_bid_min_margin_model_id, type:string, comment:null), FieldSchema(name:asset_logging_placement_cost_bid_min_margin_intercept, type:string, comment:null), FieldSchema(name:asset_logging_placement_cost_bid_min_margin_coeff_set, type:string, comment:null), FieldSchema(name:asset_logging_placement_cost_bid_target_margin_input_cost, type:string, comment:null), FieldSchema(name:asset_logging_placement_cost_bid_target_margin_result_bid, type:string, comment:null), FieldSchema(name:asset_logging_placement_cost_bid_target_margin_model_id, type:string, comment:null), FieldSchema(name:asset_logging_placement_cost_bid_target_margin_intercept, type:string, comment:null), FieldSchema(name:asset_logging_placement_cost_bid_target_margin_coeff_set, type:string, comment:null), FieldSchema(name:asset_logging_placement_cost_bid_cpa_limit_input_cost, type:string, comment:null), FieldSchema(name:asset_logging_placement_cost_bid_cpa_limit_result_bid, type:string, comment:null), FieldSchema(name:asset_logging_placement_cost_bid_cpa_limit_model_id, type:string, comment:null), FieldSchema(name:asset_logging_placement_cost_bid_cpa_limit_intercept, type:string, comment:null), FieldSchema(name:asset_logging_placement_cost_bid_cpa_limit_coeff_set, type:string, comment:null), FieldSchema(name:asset_logging_placement_cost_bid_cpc_limit_input_cost, type:string, comment:null), FieldSchema(name:asset_logging_placement_cost_bid_cpc_limit_result_bid, type:string, comment:null), FieldSchema(name:asset_logging_placement_cost_bid_cpc_limit_model_id, type:string, comment:null), FieldSchema(name:asset_logging_placement_cost_bid_cpc_limit_intercept, type:string, comment:null), FieldSchema(name:asset_logging_placement_cost_bid_cpc_limit_coeff_set, type:string, comment:null), FieldSchema(name:asset_logging_placement_cost_bid_cpm_limit_input_cost, type:string, comment:null), FieldSchema(name:asset_logging_placement_cost_bid_cpm_limit_result_bid, type:string, comment:null), FieldSchema(name:asset_logging_placement_cost_bid_cpm_limit_model_id, type:string, comment:null), FieldSchema(name:asset_logging_placement_cost_bid_cpm_limit_intercept, type:string, comment:null), FieldSchema(name:asset_logging_placement_cost_bid_cpm_limit_coeff_set, type:string, comment:null), FieldSchema(name:asset_logging_placement_ucb_boost_avg_maturity, type:string, comment:null), FieldSchema(name:asset_logging_placement_ucb_boost_bid_scale, type:string, comment:null), FieldSchema(name:asset_logging_placement_ucb_boost_applied_before_bid_limits, type:string, comment:null), FieldSchema(name:asset_logging_placement_vpx_stdev, type:string, comment:null), FieldSchema(name:asset_logging_placement_bid_boost_num_stdevs, type:string, comment:null), FieldSchema(name:asset_logging_placement_main_action_maturity, type:string, comment:null), FieldSchema(name:asset_logging_placement_ucb_x_count, type:string, comment:null), FieldSchema(name:asset_logging_placement_info_x_multiplier, type:string, comment:null), FieldSchema(name:asset_logging_placement_initial_explore_x_count, type:string, comment:null), FieldSchema(name:asset_logging_placement_explore_action_rate, type:string, comment:null), FieldSchema(name:asset_logging_pool_last_volume_track_finish_time, type:bigint, comment:null), FieldSchema(name:asset_logging_pool_current_volume_track_start_time, type:bigint, comment:null), FieldSchema(name:asset_logging_pool_current_volume_track_finish_time, type:bigint, comment:null), FieldSchema(name:asset_logging_pool_total_assets_found, type:int, comment:null), FieldSchema(name:asset_logging_pool_total_assets_on_or_ahead, type:int, comment:null), FieldSchema(name:asset_logging_pool_total_assets_behind, type:int, comment:null), FieldSchema(name:asset_logging_pool_total_actual_asset_spend_usd, type:float, comment:null), FieldSchema(name:asset_logging_pool_total_projected_asset_spend_usd, type:float, comment:null), FieldSchema(name:asset_logging_pool_total_planned_budget_usd, type:float, comment:null), FieldSchema(name:asset_logging_pool_total_placements_with_value_bid_scale_recentered, type:int, comment:null), FieldSchema(name:asset_logging_pool_total_placements_with_value_bid_scale_raised_to_min_margin, type:int, comment:null), FieldSchema(name:asset_logging_pool_total_placements_with_value_bid_scale_reduced_to_target_margin, type:int, comment:null), FieldSchema(name:asset_logging_pool_total_placements_on_or_ahead, type:int, comment:null), FieldSchema(name:asset_logging_pool_total_placements_behind, type:int, comment:null), FieldSchema(name:asset_logging_pool_total_placements_in_unprocessed_assets, type:int, comment:null), FieldSchema(name:asset_logging_pool_planning_pool_pacing_last_update, type:bigint, comment:null), FieldSchema(name:asset_logging_pool_planning_pool_spend_goal_cents, type:float, comment:null), FieldSchema(name:asset_logging_pool_planning_pool_actual_spend_cents, type:float, comment:null), FieldSchema(name:asset_logging_pool_planning_pool_projected_spend_cents, type:float, comment:null), FieldSchema(name:asset_logging_pool_planning_pool_pacing_timezone, type:string, comment:null), FieldSchema(name:asset_logging_pool_planning_pool_total_spend_cents_from_planner, type:string, comment:null), FieldSchema(name:asset_logging_pool_planning_pool_projected_spend_cents_from_planner, type:string, comment:null), FieldSchema(name:asset_logging_pool_planning_pool_total_spend_cents_from_allocations, type:string, comment:null), FieldSchema(name:asset_logging_pool_planning_pool_projected_spend_cents_from_allocations, type:string, comment:null), FieldSchema(name:asset_logging_pool_planning_pool_pacing_min_weight, type:float, comment:null), FieldSchema(name:asset_logging_pool_planning_pool_pacing_max_weight, type:float, comment:null), FieldSchema(name:asset_logging_pool_planning_pool_pacing_error_scale, type:float, comment:null), FieldSchema(name:asset_logging_pool_planning_pool_pacing_unclipped_weight, type:float, comment:null), FieldSchema(name:asset_logging_pool_group_pacing_allocation_daily_spend_pacing_warning, type:string, comment:null), FieldSchema(name:asset_logging_pool_group_pacing_campaign_daily_spend_pacing_warning, type:string, comment:null), FieldSchema(name:asset_logging_pool_group_pacing_allocation_raw_volume_track, type:string, comment:null), FieldSchema(name:asset_logging_pool_group_pacing_allocation_grace_volume_track, type:string, comment:null), FieldSchema(name:asset_logging_pool_group_pacing_campaign_raw_volume_track, type:string, comment:null), FieldSchema(name:asset_logging_pool_group_pacing_campaign_grace_volume_track, type:string, comment:null), FieldSchema(name:asset_logging_pool_group_pacing_allocation_actual_spend, type:string, comment:null), FieldSchema(name:asset_logging_pool_group_pacing_campaign_actual_spend, type:string, comment:null), FieldSchema(name:asset_logging_pool_group_pacing_allocation_client_spend_target, type:string, comment:null), FieldSchema(name:asset_logging_pool_group_pacing_campaign_client_spend_target, type:string, comment:null), FieldSchema(name:asset_logging_pool_group_pacing_campaign_residual_client_spend_target, type:string, comment:null), FieldSchema(name:asset_logging_pool_group_pacing_allocation_estimated_spend, type:string, comment:null), FieldSchema(name:asset_logging_pool_group_pacing_campaign_estimated_spend, type:string, comment:null), FieldSchema(name:asset_logging_pool_group_pacing_campaign_residual_estimated_spend, type:string, comment:null), FieldSchema(name:asset_logging_pool_group_pacing_minimum_margin_percent, type:string, comment:null), FieldSchema(name:asset_logging_pool_group_pacing_target_margin_percent, type:string, comment:null), FieldSchema(name:asset_logging_pool_group_pacing_default_margin_offset_for_cpa, type:string, comment:null), FieldSchema(name:asset_logging_pool_group_pacing_default_margin_offset_for_yield, type:string, comment:null), FieldSchema(name:asset_logging_pool_group_pacing_default_change_frequency, type:string, comment:null), FieldSchema(name:asset_logging_pool_group_pacing_scaled_change_frequency, type:string, comment:null), FieldSchema(name:asset_logging_pool_group_pacing_previous_expected_margin, type:string, comment:null), FieldSchema(name:asset_logging_pool_group_pacing_previous_margin_adjust_time, type:string, comment:null), FieldSchema(name:asset_logging_pool_group_pacing_longer_than_change_frequency_time, type:string, comment:null), FieldSchema(name:asset_logging_pool_group_pacing_raw_expected_margin, type:string, comment:null), FieldSchema(name:asset_logging_pool_group_pacing_clipped_expected_margin, type:string, comment:null), FieldSchema(name:asset_logging_pool_group_pacing_time_scale_factor, type:string, comment:null), FieldSchema(name:asset_logging_pool_group_pacing_pacing_timezone, type:string, comment:null), FieldSchema(name:asset_logging_placement_layered_data_selection_val, type:string, comment:null), FieldSchema(name:asset_logging_placement_layered_data_selection_a1, type:string, comment:null), FieldSchema(name:asset_logging_placement_layered_data_selection_a2, type:string, comment:null), FieldSchema(name:asset_logging_placement_layered_data_selection_a3, type:string, comment:null), FieldSchema(name:asset_logging_placement_layered_data_selection_a4, type:string, comment:null), FieldSchema(name:asset_logging_placement_layered_data_selection_a5, type:string, comment:null), FieldSchema(name:asset_logging_placement_layered_data_selection_a6, type:string, comment:null), FieldSchema(name:asset_logging_placement_layered_data_selection_a7, type:string, comment:null), FieldSchema(name:asset_logging_placement_margin_change_do_adjust, type:int, comment:null), FieldSchema(name:asset_logging_placement_margin_change_timer_expired, type:int, comment:null), FieldSchema(name:asset_logging_placement_margin_change_valid_asset_data, type:int, comment:null), FieldSchema(name:asset_logging_placement_margin_change_valid_global_data, type:int, comment:null), FieldSchema(name:asset_logging_pool_global_asset_margin_old, type:float, comment:null), FieldSchema(name:asset_logging_pool_global_asset_margin_reset, type:int, comment:null), FieldSchema(name:asset_logging_pool_global_pacing_timer_too_soon, type:int, comment:null), FieldSchema(name:asset_logging_pool_planning_data_is_valid, type:int, comment:null), FieldSchema(name:asset_logging_pool_planning_data_valid_spend_target, type:int, comment:null), FieldSchema(name:asset_logging_pool_planning_data_valid_timestamp, type:int, comment:null), FieldSchema(name:asset_logging_pool_pool_spend_target_changed, type:int, comment:null), FieldSchema(name:asset_logging_placement_scaled_change_frequency, type:string, comment:null), FieldSchema(name:year, type:string, comment:null), FieldSchema(name:month, type:string, comment:null), FieldSchema(name:day, type:string, comment:null)], location:hdfs://nameservice1/ai/vpc_bidder_history, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:
{colelction.delim=, mapkey.delim=, serialization.format=, field.delim=}), bucketCols:[], sortCols:[], parameters:{}, skewedInfo:SkewedInfo(skewedColNames:[], skewedColValues:[], skewedColValueLocationMaps:{}), storedAsSubDirectories:false), partitionKeys:[FieldSchema(name:year, type:string, comment:null), FieldSchema(name:month, type:string, comment:null), FieldSchema(name:day, type:string, comment:null)], parameters:
{EXTERNAL=TRUE, transient_lastDdlTime=1405026518}, viewOriginalText:null, viewExpandedText:null, tableType:EXTERNAL_TABLE)