Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
5.5.1
-
None
Description
Here is what customer tried.
Its a cross engine insert. stg_sh_fact_click_denorm is MyISAM table and sh_fact_click_denorm is columnstore. Selecting from myisam and inserting into CS.
|
|
* MyISAm has 0 rows... |
MariaDB [dwhs]> select count(*) from stg_sh_fact_click_denorm;
|
+----------+
|
| count(*) |
|
+----------+
|
| 0 | |
+----------+
|
1 row in set (0.000 sec) |
|
* CS has 36m rows
|
MariaDB [dwhs]> select count(*) from sh_fact_click_denorm;
|
+----------+
|
| count(*) |
|
+----------+
|
| 36026721 | |
+----------+
|
1 row in set (0.275 sec) |
|
INSERT INTO dwhs.sh_fact_click_denorm SELECT stg.click_id, stg.clickid, stg.impression_id, stg.impressionid, stg.search_id, stg.search_date, stg.status_id, stg.click_date, stg.source_id, stg.buyer_id, stg.ip_address, stg.user_agent, stg.physical_device_type_name, stg.physical_device_type_id, stg.browser_name, stg.os_name, stg.click_key, stg.click_url, stg.product_id, stg.investment_term_months, stg.advertiser_cost, stg.premargin_supplier_earnings, stg.supplier_earnings, stg.clickcapturekey, stg.quad_clk, stg.web_server, stg.data_pass_attempted, stg.data_pass_success, stg.geo_country, stg.geo_country_cf, stg.geo_region, stg.geo_state, stg.geo_state_cf, stg.geo_city, stg.geo_city_cf, stg.geo_zip, stg.geo_dma, stg.ip_routing_type, stg.lp_click_session_id, stg.reconciliation_updated_date, stg.date_updated_date, stg.encrypted_affiliate_key, stg.physical_device_type_name_imp, stg.matching_device_type_name, stg.state_code, stg.state_name, stg.var1, stg.var2, stg.var3, stg.search_status_id, stg.service_code, stg.age, stg.gender, stg.married, stg.home_owner, stg.currently_insured, stg.insured_time_frame, stg.insurance_carrier, stg.credit_rating, stg.recent_incident_count, stg.sr22, stg.average_credit_score, stg.fico_score, stg.mortgage_ltv, stg.mortgage_term, stg.mortgage_term_name, stg.mortgage_loan_amount, stg.current_banks, stg.savings_goal, stg.investment_amount, stg.deposit_frequency, stg.yearly_gross_income, stg.investment_term_months_imp, stg.personal_loan_purpose, stg.personal_loan_amount, stg.type_of_insurance, stg.coverage_amount, stg.rank, stg.bid, stg.phone_call_bid, stg.credit_card_id, stg.qmp_creative_key, stg.qmp_click_portal_vendor_key, stg.qmp_click_campaign_key, stg.qmp_click_vendor_key, stg.qmp_click_parent_vendor_key, stg.qmp_phone_campaign_key, stg.qmp_phone_parent_vendor_key, stg.qmp_phone_portal_vendor_key, stg.qmp_phone_vendor_key, stg.category_id, stg.military_affiliation, stg.age_bucket, stg.search_date_key, stg.click_date_key, stg.transaction_id, stg.click_type, stg.click_ref_url, stg.click_hour, stg.publisher_click_trn_id, stg.anura_result, stg.has_media_cost, stg.zip_code, stg.any_recent_incidents, stg.vehicle_count, stg.occupation, stg.education, stg.license_status, stg.driver_count, stg.data_pass_available, stg.click_date_clk, stg.search_date_clk, stg.browser_version, stg.browser_vendor, stg.device_manufacturer, stg.device_model, stg.device_atlas_device_id, stg.display_width, stg.display_height, stg.browser_rendering_engine, stg.inapp_browser, stg.interstitial_used, stg.original_click_key, stg.publisher_key, stg.profile_key, stg.media_group_key, stg.bid_to_position_honored, stg.date_added, stg.pex_advertiser_cost, stg.pex_quinstreet_commission, stg.data_pass_debug_info, stg.searchid, stg.qmp_publisher_exchange_key, stg.pet_type, stg.pet_count, stg.pet_breed, stg.qmp_clk_ab_test_variant_key, stg.pet_age, stg.pet_gender, stg.external_click_id, stg.display_strategy_name, stg.qmp_aff_inventory_type_key, stg.qmp_parent_aff_invtry_type_key, stg.inventory_type, stg.dui, stg.standard_industry_code, stg.tobacco_use, stg.body_mass_index, stg.life_event, stg.medical_condition, stg.hazardous_occupation, stg.is_cellular_network, stg.household_income, stg.publisher_account_name, stg.publisher_customer_id, stg.publisher_company, stg.service_key, stg.service_name, stg.vendor_service_key, stg.vendor_service_description, stg.advertiser_account_name, stg.advertiser_customer_id, stg.advertiser_company, stg.credit_card_type_name, stg.credit_card_name, stg.blurb_title, stg.product_key, stg.product_name, stg.dms_client_key, stg.vendor_name, stg.publisher, stg.publisher_company_name, stg.hash_id, stg.profile_name, stg.media_group_name, stg.ab_test_variant_name, stg.exchange_name, stg.affiliate_key, stg.publisher_display_name, stg.advertiser_display_name, stg.client_name, stg.vertical, stg.client_model, stg.business_unit, stg.isqmpclient, stg.category_code_key, stg.category_code_name, stg.country_code, stg.country, stg.entered_dtm, stg.dms_publisher_key, stg.trx_hour, stg.trx_week, stg.trx_month, stg.trx_date FROM dwhs.stg_sh_fact_click_denorm stg where update_flag = 'I'; |
ERROR 1815 (HY000): Internal error: load failed. The detailed error information is listed in err.log. |