Skip to content

Instantly share code, notes, and snippets.

@edsolovey
Last active June 1, 2017 15:40
Show Gist options
  • Save edsolovey/001d1a5353dd9d3c14cccf6678312ecb to your computer and use it in GitHub Desktop.
Save edsolovey/001d1a5353dd9d3c14cccf6678312ecb to your computer and use it in GitHub Desktop.
drop predefined tables from answers-speed-cassandra
DROP TABLE pe_metric_time_series_history;
DROP TABLE pe_metric_time_series_now;
DROP TABLE pe_metric_time_series_bootstrap;
DROP TABLE pe_event_count_metadata;
DROP TABLE pe_attribute_metadata;
DROP TABLE pe_count_history;
DROP TABLE pe_cardinality_history;
DROP TABLE pe_cardinality_hll;
# want to keep this table for a few more weeks
#DROP TABLE pe_with_dimension_count;
DROP TABLE pe_with_dimension_count_history;
DROP TABLE pe_with_dimension_cardinality;
DROP TABLE pe_with_dimension_hll;
DROP TABLE pe_predefined_attribute_counts;
DROP TABLE pe_purchase_item_id_now;
DROP TABLE pe_purchase_item_id_history;
DROP TABLE pe_purchase_item_type_now;
DROP TABLE pe_purchase_item_type_history;
DROP TABLE pe_purchase_item_name_now;
DROP TABLE pe_purchase_item_name_history;
DROP TABLE pe_purchase_currency_now;
DROP TABLE pe_purchase_currency_history;
DROP TABLE pe_purchase_success_now;
DROP TABLE pe_purchase_success_history;
DROP TABLE pe_purchase_price_now;
DROP TABLE pe_purchase_price_history;
DROP TABLE pe_purchase_price_bootstrap;
DROP TABLE pe_purchase_converted_price_now;
DROP TABLE pe_purchase_converted_price_history;
DROP TABLE pe_purchase_converted_price_bootstrap;
DROP TABLE pe_purchase_price_now_by_currency;
DROP TABLE pe_purchase_price_history_by_currency;
DROP TABLE pe_login_method_now;
DROP TABLE pe_login_method_history;
DROP TABLE pe_login_success_now;
DROP TABLE pe_login_success_history;
DROP TABLE pe_share_method_now;
DROP TABLE pe_share_method_history;
DROP TABLE pe_share_content_id_now;
DROP TABLE pe_share_content_id_history;
DROP TABLE pe_share_content_name_now;
DROP TABLE pe_share_content_name_history;
DROP TABLE pe_share_content_type_now;
DROP TABLE pe_share_content_type_history;
DROP TABLE pe_sign_up_method_now;
DROP TABLE pe_sign_up_method_history;
DROP TABLE pe_sign_up_success_now;
DROP TABLE pe_sign_up_success_history;
DROP TABLE pe_invite_method_now;
DROP TABLE pe_invite_method_history;
DROP TABLE pe_level_start_level_name_now;
DROP TABLE pe_level_start_level_name_history;
DROP TABLE pe_level_end_level_name_now;
DROP TABLE pe_level_end_level_name_history;
DROP TABLE pe_level_end_success_now;
DROP TABLE pe_level_end_success_history;
DROP TABLE pe_level_end_score_now;
DROP TABLE pe_level_end_score_history;
DROP TABLE pe_level_end_score_bootstrap;
DROP TABLE pe_add_to_cart_currency_now;
DROP TABLE pe_add_to_cart_currency_history;
DROP TABLE pe_add_to_cart_item_name_now;
DROP TABLE pe_add_to_cart_item_name_history;
DROP TABLE pe_add_to_cart_item_type_now;
DROP TABLE pe_add_to_cart_item_type_history;
DROP TABLE pe_add_to_cart_item_id_now;
DROP TABLE pe_add_to_cart_item_id_history;
DROP TABLE pe_add_to_cart_item_price_now;
DROP TABLE pe_add_to_cart_item_price_history;
DROP TABLE pe_add_to_cart_item_price_bootstrap;
DROP TABLE pe_add_to_cart_converted_item_price_now;
DROP TABLE pe_add_to_cart_converted_item_price_history;
DROP TABLE pe_add_to_cart_converted_item_price_bootstrap;
DROP TABLE pe_add_to_cart_item_price_now_by_currency;
DROP TABLE pe_add_to_cart_item_price_history_by_currency;
DROP TABLE pe_start_checkout_currency_now;
DROP TABLE pe_start_checkout_currency_history;
DROP TABLE pe_start_checkout_total_price_now;
DROP TABLE pe_start_checkout_total_price_history;
DROP TABLE pe_start_checkout_total_price_bootstrap;
DROP TABLE pe_start_checkout_total_price_now_by_currency;
DROP TABLE pe_start_checkout_total_price_history_currency;
DROP TABLE pe_start_checkout_item_count_now;
DROP TABLE pe_start_checkout_item_count_history;
DROP TABLE pe_start_checkout_item_count_bootstrap;
DROP TABLE pe_start_checkout_cnvtd_total_price_now;
DROP TABLE pe_start_checkout_cnvtd_total_price_history;
DROP TABLE pe_start_checkout_cnvtd_total_price_bootstrap;
DROP TABLE pe_rating_content_name_now;
DROP TABLE pe_rating_content_name_history;
DROP TABLE pe_rating_content_type_now;
DROP TABLE pe_rating_content_type_history;
DROP TABLE pe_rating_content_id_now;
DROP TABLE pe_rating_content_id_history;
DROP TABLE pe_rating_rating_now;
DROP TABLE pe_rating_rating_history;
DROP TABLE pe_rating_rating_bootstrap;
DROP TABLE pe_content_view_content_name_now;
DROP TABLE pe_content_view_content_name_history;
DROP TABLE pe_content_view_content_id_now;
DROP TABLE pe_content_view_content_id_history;
DROP TABLE pe_content_view_content_type_now;
DROP TABLE pe_content_view_content_type_history;
DROP TABLE pe_search_query_now;
DROP TABLE pe_search_query_history;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment