135 lines
5.2 KiB
Plaintext
135 lines
5.2 KiB
Plaintext
============================================================
|
|
步骤 1: 创建物化视图
|
|
============================================================
|
|
mv_dws_assistant_daily_detail_l1: 已存在，跳过
|
|
mv_dws_assistant_daily_detail_l2: 已存在，跳过
|
|
mv_dws_assistant_daily_detail_l3: 已存在，跳过
|
|
mv_dws_assistant_daily_detail_l4: 已存在，跳过
|
|
mv_dws_finance_daily_summary_l1: 已存在，跳过
|
|
mv_dws_finance_daily_summary_l2: 已存在，跳过
|
|
mv_dws_finance_daily_summary_l3: 已存在，跳过
|
|
mv_dws_finance_daily_summary_l4: 已存在，跳过
|
|
物化视图: 8/8 成功
|
|
|
|
============================================================
|
|
步骤 2: 创建物化视图索引
|
|
============================================================
|
|
idx_mv_assistant_daily_l1: OK
|
|
idx_mv_assistant_daily_l2: OK
|
|
idx_mv_assistant_daily_l3: OK
|
|
idx_mv_assistant_daily_l4: OK
|
|
idx_mv_finance_daily_l1: OK
|
|
idx_mv_finance_daily_l2: OK
|
|
idx_mv_finance_daily_l3: OK
|
|
idx_mv_finance_daily_l4: OK
|
|
索引: 8/8 成功
|
|
|
|
============================================================
|
|
步骤 3: ANALYZE
|
|
============================================================
|
|
ods: 23 个对象已 ANALYZE
|
|
dwd: 40 个对象已 ANALYZE
|
|
dws: 37 个对象已 ANALYZE
|
|
meta: 3 个对象已 ANALYZE
|
|
core: 7 个对象已 ANALYZE
|
|
app: 0 个对象已 ANALYZE
|
|
ANALYZE 完成
|
|
|
|
============================================================
|
|
步骤 4: 最终验证
|
|
============================================================
|
|
OK ods.assistant_accounts_master: 223 行
|
|
OK ods.assistant_cancellation_records: 100 行
|
|
OK ods.assistant_service_records: 10203 行
|
|
OK ods.goods_stock_movements: 35005 行
|
|
OK ods.goods_stock_summary: 867 行
|
|
OK ods.group_buy_packages: 52 行
|
|
OK ods.group_buy_redemption_records: 19532 行
|
|
OK ods.member_balance_changes: 7366 行
|
|
OK ods.member_profiles: 1202 行
|
|
OK ods.member_stored_value_cards: 2008 行
|
|
OK ods.payment_transactions: 24674 行
|
|
OK ods.platform_coupon_redemption_records: 18125 行
|
|
OK ods.recharge_settlements: 3333 行
|
|
OK ods.refund_transactions: 50 行
|
|
OK ods.settlement_records: 55137 行
|
|
OK ods.settlement_ticket_details: 193 行
|
|
OK ods.site_tables_master: 949 行
|
|
OK ods.stock_goods_category_tree: 9 行
|
|
OK ods.store_goods_master: 1398 行
|
|
OK ods.store_goods_sales_records: 17563 行
|
|
OK ods.table_fee_discount_records: 3100 行
|
|
OK ods.table_fee_transactions: 28881 行
|
|
OK ods.tenant_goods_master: 176 行
|
|
OK dwd.dim_assistant: 1208 行
|
|
OK dwd.dim_assistant_ex: 1251 行
|
|
OK dwd.dim_goods_category: 125 行
|
|
OK dwd.dim_groupbuy_package: 373 行
|
|
OK dwd.dim_groupbuy_package_ex: 373 行
|
|
OK dwd.dim_member: 10801 行
|
|
OK dwd.dim_member_card_account: 18370 行
|
|
OK dwd.dim_member_card_account_ex: 18172 行
|
|
OK dwd.dim_member_ex: 10770 行
|
|
OK dwd.dim_site: 52 行
|
|
OK dwd.dim_site_ex: 52 行
|
|
OK dwd.dim_store_goods: 5444 行
|
|
OK dwd.dim_store_goods_ex: 5402 行
|
|
OK dwd.dim_table: 2749 行
|
|
OK dwd.dim_table_ex: 2903 行
|
|
OK dwd.dim_tenant_goods: 2018 行
|
|
OK dwd.dim_tenant_goods_ex: 2016 行
|
|
OK dwd.dwd_assistant_service_log: 5281 行
|
|
OK dwd.dwd_assistant_service_log_ex: 5281 行
|
|
OK dwd.dwd_assistant_trash_event: 100 行
|
|
OK dwd.dwd_assistant_trash_event_ex: 100 行
|
|
OK dwd.dwd_groupbuy_redemption: 12526 行
|
|
OK dwd.dwd_groupbuy_redemption_ex: 12526 行
|
|
OK dwd.dwd_member_balance_change: 5042 行
|
|
OK dwd.dwd_member_balance_change_ex: 5042 行
|
|
OK dwd.dwd_payment: 24597 行
|
|
OK dwd.dwd_platform_coupon_redemption: 18069 行
|
|
OK dwd.dwd_platform_coupon_redemption_ex: 18069 行
|
|
OK dwd.dwd_recharge_order: 485 行
|
|
OK dwd.dwd_recharge_order_ex: 485 行
|
|
OK dwd.dwd_refund: 50 行
|
|
OK dwd.dwd_refund_ex: 50 行
|
|
OK dwd.dwd_settlement_head: 26115 行
|
|
OK dwd.dwd_settlement_head_ex: 26115 行
|
|
OK dwd.dwd_store_goods_sale: 17563 行
|
|
OK dwd.dwd_store_goods_sale_ex: 17563 行
|
|
OK dwd.dwd_table_fee_adjust: 3085 行
|
|
OK dwd.dwd_table_fee_adjust_ex: 3085 行
|
|
OK dwd.dwd_table_fee_log: 19847 行
|
|
OK dwd.dwd_table_fee_log_ex: 19847 行
|
|
OK dws.cfg_index_parameters: 127 行
|
|
OK dws.dws_assistant_daily_detail: 5276 行
|
|
OK dws.dws_finance_daily_summary: 210 行
|
|
OK dws.dws_index_percentile_history: 80 行
|
|
OK dws.dws_member_assistant_intimacy: 219 行
|
|
OK dws.dws_member_newconv_index: 49 行
|
|
OK dws.dws_member_visit_detail: 4398 行
|
|
OK dws.dws_member_winback_index: 122 行
|
|
OK meta.etl_cursor: 44 行
|
|
OK meta.etl_run: 8726 行
|
|
OK meta.etl_task: 49 行
|
|
|
|
物化视图检查:
|
|
OK dws.mv_dws_assistant_daily_detail_l1: 0 行
|
|
OK dws.mv_dws_assistant_daily_detail_l2: 584 行
|
|
OK dws.mv_dws_assistant_daily_detail_l3: 2400 行
|
|
OK dws.mv_dws_assistant_daily_detail_l4: 4794 行
|
|
OK dws.mv_dws_finance_daily_summary_l1: 0 行
|
|
OK dws.mv_dws_finance_daily_summary_l2: 26 行
|
|
OK dws.mv_dws_finance_daily_summary_l3: 86 行
|
|
OK dws.mv_dws_finance_daily_summary_l4: 184 行
|
|
|
|
索引统计:
|
|
ods: 69 个索引
|
|
dwd: 135 个索引
|
|
dws: 123 个索引
|
|
meta: 5 个索引
|
|
|
|
============================================================
|
|
验证通过: 74 表, 572448 行全部一致
|
|
============================================================
|