\n| ZSTD<\/td>\n | \u9ad8<\/td>\n | \u2b50\u2b50\u2b50<\/td>\n | \u2b50\u2b50\u2b50\u2b50<\/td>\n | \u65b0\u63a8\u8350\u65b9\u6848，\u5e73\u8861\u6027\u597d<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n \u901a\u4fd7\u89e3\u91ca： \u5c31\u50cf\u6253\u5305\u884c\u674e：<\/p>\n \n- \n
Snappy：\u5feb\u901f\u6253\u5305，\u867d\u7136\u7bb1\u5b50\u6709\u70b9\u5927，\u4f46\u53d6\u4e1c\u897f\u5feb<\/p>\n<\/li>\n - \n
Gzip：\u4ed4\u7ec6\u6253\u5305，\u7bb1\u5b50\u6700\u5c0f，\u4f46\u6253\u5305\u548c\u62c6\u5305\u90fd\u6162<\/p>\n<\/li>\n - \n
ZSTD：\u65b0\u578b\u667a\u80fd\u6253\u5305，\u7bb1\u5b50\u5c0f\u4e14\u901f\u5ea6\u4e0d\u6162<\/p>\n<\/li>\n<\/ul>\n \u538b\u7f29\u8bbe\u7f6e\u793a\u4f8b：<\/p>\n — Hive\u4e2d\u8bbe\u7f6e\u538b\u7f29
\nSET hive.exec.compress.output=true;
\nSET mapred.output.compression.codec=org.apache.hadoop.io.compress.SnappyCodec;<\/p>\n — \u5efa\u8868\u65f6\u6307\u5b9a\u538b\u7f29
\nCREATE TABLE dwd.fact_order_detail
\nSTORED AS PARQUET
\nTBLPROPERTIES ('parquet.compression'='SNAPPY'); <\/p>\n 4. \u6570\u636e\u57df\u5212\u5206<\/h4>\n\u4e13\u4e1a\u7684\u6570\u636e\u57df\u8bbe\u8ba1：<\/p>\n — \u7535\u5546\u5e73\u53f0\u5178\u578b\u6570\u636e\u57df\u5212\u5206
\ndwd.trade_order_detail — \u4ea4\u6613\u57df：\u8ba2\u5355\u660e\u7ec6
\ndwd.trade_payment_detail — \u4ea4\u6613\u57df：\u652f\u4ed8\u660e\u7ec6
\ndwd.trade_refund_detail — \u4ea4\u6613\u57df：\u9000\u6b3e\u660e\u7ec6
\ndwd.user_behavior_log — \u7528\u6237\u57df：\u884c\u4e3a\u65e5\u5fd7
\ndwd.product_sku_daily — \u5546\u54c1\u57df：SKU\u65e5\u7c92\u5ea6
\ndwd.marketing_coupon_use — \u8425\u9500\u57df：\u4f18\u60e0\u5238\u4f7f\u7528
\ndwd.logistics_delivery_trace — \u7269\u6d41\u57df：\u914d\u9001\u8f68\u8ff9 <\/p>\n \u901a\u4fd7\u89e3\u91ca： \u5c31\u50cf\u516c\u53f8\u7684\u90e8\u95e8\u5212\u5206：<\/p>\n \n- \n
\u4ea4\u6613\u57df：\u9500\u552e\u90e8\u95e8，\u8d1f\u8d23\u8ba2\u5355\u3001\u652f\u4ed8<\/p>\n<\/li>\n - \n
\u7528\u6237\u57df：\u5ba2\u670d\u90e8\u95e8，\u7ba1\u7406\u7528\u6237\u4fe1\u606f\u884c\u4e3a<\/p>\n<\/li>\n - \n
\u5546\u54c1\u57df：\u91c7\u8d2d\u90e8\u95e8，\u7ba1\u7406\u5546\u54c1\u5e93\u5b58<\/p>\n<\/li>\n - \n
\u8425\u9500\u57df：\u5e02\u573a\u90e8\u95e8，\u7ba1\u7406\u6d3b\u52a8\u4f18\u60e0<\/p>\n<\/li>\n - \n
\u7269\u6d41\u57df：\u7269\u6d41\u90e8\u95e8，\u7ba1\u7406\u914d\u9001<\/p>\n<\/li>\n<\/ul>\n \u4e09\u3001\u4e8b\u52a1\u8868\u5206\u7c7b\u8be6\u89e3<\/h3>\n1. \u4e8b\u52a1\u4e8b\u5b9e\u8868（Transaction Fact Table）<\/h4>\n\u4e13\u4e1a\u89e3\u91ca： \u8bb0\u5f55\u4e1a\u52a1\u8fc7\u7a0b\u53d1\u751f\u7684\u4e8b\u4ef6，\u6bcf\u884c\u5bf9\u5e94\u4e00\u4e2a\u4e1a\u52a1\u4e8b\u4ef6\u3002\u7279\u70b9\u662f：<\/p>\n \n- \n
\u6570\u636e\u4e00\u65e6\u4ea7\u751f\u4e0d\u518d\u53d8\u5316<\/p>\n<\/li>\n - \n
\u7c92\u5ea6\u6700\u7ec6，\u8bb0\u5f55\u539f\u59cb\u4e1a\u52a1\u4e8b\u4ef6<\/p>\n<\/li>\n - \n
\u4e3b\u8981\u7528\u4e8e\u5206\u6790\u4e8b\u4ef6\u53d1\u751f\u60c5\u51b5<\/p>\n<\/li>\n<\/ul>\n \u901a\u4fd7\u89e3\u91ca： \u5c31\u50cf\u94f6\u884c\u7684\u6d41\u6c34\u8d26，\u8bb0\u5f55\u6bcf\u4e00\u7b14\u5b58\u53d6\u6b3e：<\/p>\n \n- \n
\u5b58100\u5143 \u2192 \u8bb0\u4e00\u6761<\/p>\n<\/li>\n - \n
\u53d650\u5143 \u2192 \u8bb0\u4e00\u6761<\/p>\n<\/li>\n - \n
\u6c38\u4e0d\u4fee\u6539，\u53ea\u8ffd\u52a0\u65b0\u8bb0\u5f55<\/p>\n<\/li>\n<\/ul>\n \u521b\u5efa\u6b65\u9aa4：<\/p>\n — \u6b65\u9aa41：\u521b\u5efa\u8868\u7ed3\u6784
\nCREATE TABLE dwd.fact_order_transaction (
\n — \u4ee3\u7406\u952e\u548c\u7ef4\u5ea6\u952e
\n order_detail_key BIGINT COMMENT '\u8ba2\u5355\u660e\u7ec6\u4ee3\u7406\u952e',
\n order_id STRING COMMENT '\u8ba2\u5355\u4e1a\u52a1ID',
\n user_key INT COMMENT '\u7528\u6237\u7ef4\u5ea6\u4ee3\u7406\u952e',
\n product_key INT COMMENT '\u5546\u54c1\u7ef4\u5ea6\u4ee3\u7406\u952e',
\n date_key INT COMMENT '\u65e5\u671f\u7ef4\u5ea6\u4ee3\u7406\u952e',
\n time_key INT COMMENT '\u65f6\u95f4\u7ef4\u5ea6\u4ee3\u7406\u952e(\u5c0f\u65f6\u5206\u949f)',<\/p>\n — \u9000\u5316\u7ef4\u5ea6
\n user_level STRING COMMENT '\u7528\u6237\u7b49\u7ea7',
\n product_category STRING COMMENT '\u5546\u54c1\u5206\u7c7b',<\/p>\n — \u5ea6\u91cf\u503c
\n order_amount DECIMAL(10,2) COMMENT '\u8ba2\u5355\u91d1\u989d',
\n product_quantity INT COMMENT '\u5546\u54c1\u6570\u91cf',
\n discount_amount DECIMAL(10,2) COMMENT '\u4f18\u60e0\u91d1\u989d',<\/p>\n — \u5206\u533a\u5b57\u6bb5
\n dt STRING COMMENT '\u5206\u533a\u65e5\u671f'
\n)
\nPARTITIONED BY (dt)
\nSTORED AS PARQUET;<\/p>\n — \u6b65\u9aa42：ETL\u5904\u7406\u903b\u8f91（\u4f2a\u4ee3\u7801）
\n1. \u4eceODS\u5c42\u62bd\u53d6\u8ba2\u5355\u539f\u59cb\u6570\u636e
\n2. \u6e05\u6d17：\u53bb\u91cd\u3001\u53bb\u7a7a\u503c\u3001\u683c\u5f0f\u5316\u91d1\u989d
\n3. \u5173\u8054\u7ef4\u5ea6：\u7528\u6237\u7ef4\u5ea6\u83b7\u53d6user_key，\u5546\u54c1\u7ef4\u5ea6\u83b7\u53d6product_key
\n4. \u751f\u6210\u4ee3\u7406\u952e：order_detail_key = \u65f6\u95f4\u6233 + \u5e8f\u5217\u53f7
\n5. \u6570\u636e\u8f6c\u6362：\u91d1\u989d\u5355\u4f4d\u7edf\u4e00\u3001\u65f6\u95f4\u683c\u5f0f\u6807\u51c6\u5316
\n6. \u5199\u5165\u5206\u533a：\u6309dt=YYYY-MM-DD\u5206\u533a\u5b58\u50a8 <\/p>\n 2. \u5468\u671f\u5feb\u7167\u4e8b\u5b9e\u8868（Periodic Snapshot Fact Table）<\/h4>\n\u4e13\u4e1a\u89e3\u91ca： \u6309\u56fa\u5b9a\u65f6\u95f4\u95f4\u9694\u8bb0\u5f55\u4e1a\u52a1\u72b6\u6001，\u5982\u6bcf\u65e5\u3001\u6bcf\u5468\u3001\u6bcf\u6708\u5feb\u7167\u3002\u7279\u70b9\u662f：<\/p>\n \n- \n
\u5b9a\u671f\u8bb0\u5f55\u72b6\u6001，\u65e0\u8bba\u662f\u5426\u6709\u53d8\u5316<\/p>\n<\/li>\n - \n
\u7528\u4e8e\u5206\u6790\u8d8b\u52bf\u548c\u72b6\u6001\u53d8\u5316<\/p>\n<\/li>\n - \n
\u5e38\u89c1\u4e8e\u4f59\u989d\u3001\u5e93\u5b58\u7b49\u573a\u666f<\/p>\n<\/li>\n<\/ul>\n \u901a\u4fd7\u89e3\u91ca： \u5c31\u50cf\u6bcf\u5929\u4e0b\u73ed\u524d\u62cd\u4e00\u5f20\u4ed3\u5e93\u5e93\u5b58\u7167\u7247：<\/p>\n \n- \n
\u5468\u4e00：\u5e93\u5b58100\u4ef6 \u2192 \u8bb0\u5f55<\/p>\n<\/li>\n - \n
\u5468\u4e8c：\u5e93\u5b5895\u4ef6 \u2192 \u8bb0\u5f55<\/p>\n<\/li>\n - \n
\u5468\u4e09：\u5e93\u5b5898\u4ef6 \u2192 \u8bb0\u5f55<\/p>\n<\/li>\n - \n
\u65e0\u8bba\u662f\u5426\u53d8\u5316，\u6bcf\u5929\u90fd\u8981\u8bb0\u5f55<\/p>\n<\/li>\n<\/ul>\n \u521b\u5efa\u6b65\u9aa4：<\/p>\n — \u6b65\u9aa41：\u521b\u5efa\u5546\u54c1\u5e93\u5b58\u65e5\u5feb\u7167\u8868
\nCREATE TABLE dwd.fact_inventory_daily_snapshot (
\n inventory_snapshot_key BIGINT COMMENT '\u5e93\u5b58\u5feb\u7167\u4ee3\u7406\u952e',
\n product_key INT COMMENT '\u5546\u54c1\u7ef4\u5ea6\u952e',
\n warehouse_key INT COMMENT '\u4ed3\u5e93\u7ef4\u5ea6\u952e',
\n date_key INT COMMENT '\u65e5\u671f\u952e',<\/p>\n — \u5ea6\u91cf\u503c（\u5f53\u5929\u7684\u72b6\u6001）
\n opening_quantity INT COMMENT '\u671f\u521d\u5e93\u5b58',
\n closing_quantity INT COMMENT '\u671f\u672b\u5e93\u5b58',
\n incoming_quantity INT COMMENT '\u5165\u5e93\u6570\u91cf',
\n outgoing_quantity INT COMMENT '\u51fa\u5e93\u6570\u91cf',<\/p>\n — \u5206\u533a
\n dt STRING COMMENT '\u5feb\u7167\u65e5\u671f'
\n)
\nPARTITIONED BY (dt)
\nSTORED AS PARQUET;<\/p>\n — \u6b65\u9aa42：ETL\u5904\u7406\u6d41\u7a0b
\n1. \u786e\u5b9a\u5feb\u7167\u65f6\u95f4\u70b9：\u6bcf\u592923:59:59
\n2. \u83b7\u53d6\u671f\u521d\u5e93\u5b58：\u6628\u5929\u7684\u671f\u672b\u5e93\u5b58
\n3. \u8ba1\u7b97\u5f53\u65e5\u53d8\u52a8：\u6c47\u603b\u5f53\u5929\u7684\u51fa\u5165\u5e93\u8bb0\u5f55
\n4. \u8ba1\u7b97\u671f\u672b\u5e93\u5b58：\u671f\u521d + \u5165\u5e93 – \u51fa\u5e93
\n5. \u751f\u6210\u5feb\u7167\u8bb0\u5f55：\u6bcf\u4e2a\u5546\u54c1\u5728\u6bcf\u4e2a\u4ed3\u5e93\u751f\u6210\u4e00\u6761\u8bb0\u5f55
\n6. \u5f02\u5e38\u5904\u7406：\u5904\u7406\u8d1f\u5e93\u5b58\u3001\u6570\u636e\u5ef6\u8fdf\u7b49\u60c5\u51b5 <\/p>\n 3. \u7d2f\u79ef\u5feb\u7167\u4e8b\u5b9e\u8868（Accumulating Snapshot Fact Table）<\/h4>\n\u4e13\u4e1a\u89e3\u91ca： \u8bb0\u5f55\u6709\u751f\u547d\u5468\u671f\u7684\u4e1a\u52a1\u8fc7\u7a0b，\u4ece\u5f00\u59cb\u5230\u7ed3\u675f\u4e0d\u65ad\u66f4\u65b0\u3002\u7279\u70b9\u662f：<\/p>\n \n- \n
\u4e00\u884c\u8bb0\u5f55\u4ee3\u8868\u4e00\u4e2a\u5b8c\u6574\u4e1a\u52a1\u8fc7\u7a0b<\/p>\n<\/li>\n - \n
\u968f\u7740\u6d41\u7a0b\u63a8\u8fdb\u4e0d\u65ad\u66f4\u65b0<\/p>\n<\/li>\n - \n
\u8bb0\u5f55\u5404\u5173\u952e\u8282\u70b9\u7684\u65f6\u95f4\u6233<\/p>\n<\/li>\n<\/ul>\n \u901a\u4fd7\u89e3\u91ca： \u5c31\u50cf\u5feb\u9012\u8ffd\u8e2a\u5355：<\/p>\n \n- \n
\u4e0b\u5355：\u8bb0\u5f55\u4e0b\u5355\u65f6\u95f4<\/p>\n<\/li>\n - \n
\u53d1\u8d27：\u66f4\u65b0\u53d1\u8d27\u65f6\u95f4<\/p>\n<\/li>\n - \n
\u8fd0\u8f93：\u66f4\u65b0\u5f53\u524d\u4f4d\u7f6e<\/p>\n<\/li>\n - \n
\u7b7e\u6536：\u66f4\u65b0\u7b7e\u6536\u65f6\u95f4<\/p>\n<\/li>\n - \n
\u540c\u4e00\u5f20\u5355\u5b50，\u4e0d\u540c\u65f6\u95f4\u66f4\u65b0\u4e0d\u540c\u5b57\u6bb5<\/p>\n<\/li>\n<\/ul>\n \u521b\u5efa\u6b65\u9aa4：<\/p>\n — \u6b65\u9aa41：\u521b\u5efa\u8ba2\u5355\u7d2f\u79ef\u5feb\u7167\u8868
\nCREATE TABLE dwd.fact_order_accumulating (
\n order_key BIGINT COMMENT '\u8ba2\u5355\u4ee3\u7406\u952e',
\n order_id STRING COMMENT '\u8ba2\u5355\u4e1a\u52a1ID',
\n user_key INT COMMENT '\u7528\u6237\u952e',<\/p>\n — \u5173\u952e\u65f6\u95f4\u70b9
\n order_date_key INT COMMENT '\u4e0b\u5355\u65e5\u671f',
\n order_time STRING COMMENT '\u4e0b\u5355\u65f6\u95f4',<\/p>\n pay_date_key INT COMMENT '\u652f\u4ed8\u65e5\u671f',
\n pay_time STRING COMMENT '\u652f\u4ed8\u65f6\u95f4',
\n pay_amount DECIMAL(10,2) COMMENT '\u652f\u4ed8\u91d1\u989d',<\/p>\n ship_date_key INT COMMENT '\u53d1\u8d27\u65e5\u671f',
\n ship_time STRING COMMENT '\u53d1\u8d27\u65f6\u95f4',
\n logistics_company STRING COMMENT '\u7269\u6d41\u516c\u53f8',<\/p>\n receive_date_key INT COMMENT '\u7b7e\u6536\u65e5\u671f',
\n receive_time STRING COMMENT '\u7b7e\u6536\u65f6\u95f4',
\n receiver_name STRING COMMENT '\u6536\u8d27\u4eba',<\/p>\n — \u72b6\u6001\u8ddf\u8e2a
\n current_status STRING COMMENT '\u5f53\u524d\u72b6\u6001',
\n status_update_time TIMESTAMP COMMENT '\u72b6\u6001\u66f4\u65b0\u65f6\u95f4',<\/p>\n — \u5ea6\u91cf\u503c
\n total_amount DECIMAL(10,2) COMMENT '\u8ba2\u5355\u603b\u989d',
\n discount_amount DECIMAL(10,2) COMMENT '\u4f18\u60e0\u91d1\u989d',
\n actual_amount DECIMAL(10,2) COMMENT '\u5b9e\u4ed8\u91d1\u989d',<\/p>\n — \u5206\u533a（\u6309\u4e0b\u5355\u65e5\u671f\u5206\u533a）
\n dt STRING COMMENT '\u4e0b\u5355\u65e5\u671f\u5206\u533a'
\n)
\nPARTITIONED BY (dt)
\nSTORED AS PARQUET;<\/p>\n — \u6b65\u9aa42：ETL\u5904\u7406\u6d41\u7a0b（\u589e\u91cf\u66f4\u65b0）
\n1. \u521d\u59cb\u63d2\u5165：\u65b0\u8ba2\u5355\u521b\u5efa\u65f6\u63d2\u5165\u8bb0\u5f55，\u586b\u5145\u4e0b\u5355\u4fe1\u606f
\n2. \u652f\u4ed8\u66f4\u65b0：\u652f\u4ed8\u53d1\u751f\u65f6，\u66f4\u65b0pay_\u76f8\u5173\u5b57\u6bb5
\n3. \u53d1\u8d27\u66f4\u65b0：\u53d1\u8d27\u65f6\u66f4\u65b0ship_\u76f8\u5173\u5b57\u6bb5
\n4. \u7b7e\u6536\u66f4\u65b0：\u7b7e\u6536\u65f6\u66f4\u65b0receive_\u76f8\u5173\u5b57\u6bb5
\n5. \u72b6\u6001\u66f4\u65b0：\u6bcf\u6b21\u66f4\u65b0\u540c\u6b65\u66f4\u65b0current_status\u548c\u66f4\u65b0\u65f6\u95f4
\n6. \u5ef6\u8fdf\u6570\u636e：\u5904\u7406\u4e71\u5e8f\u5230\u8fbe\u7684\u6570\u636e，\u4fdd\u8bc1\u6700\u7ec8\u4e00\u81f4\u6027 <\/p>\n \u56db\u3001\u4e09\u7c7b\u4e8b\u5b9e\u8868\u5bf9\u6bd4\u603b\u7ed3<\/h3>\n\n\u7279\u5f81\u4e8b\u52a1\u4e8b\u5b9e\u8868\u5468\u671f\u5feb\u7167\u4e8b\u5b9e\u8868\u7d2f\u79ef\u5feb\u7167\u4e8b\u5b9e\u8868<\/tr>\n \n\n| \u6570\u636e\u7279\u70b9<\/td>\n | \u8ffd\u52a0，\u4e0d\u66f4\u65b0<\/td>\n | \u5b9a\u671f\u63d2\u5165\u65b0\u8bb0\u5f55<\/td>\n | \u63d2\u5165\u540e\u591a\u6b21\u66f4\u65b0<\/td>\n<\/tr>\n | \n| \u65f6\u95f4\u7ef4\u5ea6<\/td>\n | \u5355\u4e00\u4e8b\u4ef6\u65f6\u95f4<\/td>\n | \u5feb\u7167\u65f6\u95f4\u70b9<\/td>\n | \u591a\u4e2a\u5173\u952e\u65f6\u95f4\u70b9<\/td>\n<\/tr>\n | \n| \u6570\u636e\u91cf<\/td>\n | \u6700\u5927（\u6bcf\u4e8b\u4ef6\u4e00\u884c）<\/td>\n | \u4e2d\u7b49（\u6bcf\u5468\u671f\u6bcf\u4e3b\u4f53\u4e00\u884c）<\/td>\n | \u6700\u5c0f（\u6bcf\u6d41\u7a0b\u4e00\u884c）<\/td>\n<\/tr>\n | \n| \u9002\u7528\u573a\u666f<\/td>\n | \u4e8b\u4ef6\u5206\u6790<\/td>\n | \u72b6\u6001\u8d8b\u52bf\u5206\u6790<\/td>\n | \u6d41\u7a0b\u65f6\u957f\u5206\u6790<\/td>\n<\/tr>\n | \n| \u66f4\u65b0\u9891\u7387<\/td>\n | \u4f4e\u9891\u8ffd\u52a0<\/td>\n | \u5b9a\u671f\u6279\u91cf\u63d2\u5165<\/td>\n | \u9ad8\u9891\u66f4\u65b0<\/td>\n<\/tr>\n | \n| \u67e5\u8be2\u590d\u6742\u5ea6<\/td>\n | \u7b80\u5355<\/td>\n | \u4e2d\u7b49<\/td>\n | \u590d\u6742<\/td>\n<\/tr>\n | \n| \u5b58\u50a8\u6210\u672c<\/td>\n | \u9ad8<\/td>\n | \u4e2d<\/td>\n | \u4f4e<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\u4e94\u3001\u5b9e\u9645\u4e1a\u52a1\u6848\u4f8b：\u7535\u5546\u8ba2\u5355\u5168\u6d41\u7a0b<\/h3>\n— 1. \u4e8b\u52a1\u4e8b\u5b9e\u8868：\u8bb0\u5f55\u6bcf\u6b21\u652f\u4ed8\u4e8b\u4ef6
\nCREATE TABLE dwd.fact_payment_transaction (
\n payment_id BIGINT,
\n order_id BIGINT,
\n user_key INT,
\n payment_date_key INT,
\n payment_time STRING,
\n payment_method STRING, — \u652f\u4ed8\u65b9\u5f0f
\n payment_amount DECIMAL(10,2),
\n payment_status STRING,
\n dt STRING
\n);<\/p>\n — 2. \u5468\u671f\u5feb\u7167\u8868：\u6bcf\u65e5\u7528\u6237\u4f59\u989d\u5feb\u7167
\nCREATE TABLE dwd.fact_user_balance_daily (
\n user_key INT,
\n date_key INT,
\n opening_balance DECIMAL(15,2), — \u671f\u521d\u4f59\u989d
\n closing_balance DECIMAL(15,2), — \u671f\u672b\u4f59\u989d
\n total_income DECIMAL(15,2), — \u5f53\u65e5\u6536\u5165
\n total_expense DECIMAL(15,2), — \u5f53\u65e5\u652f\u51fa
\n dt STRING
\n);<\/p>\n — 3. \u7d2f\u79ef\u5feb\u7167\u8868：\u8ba2\u5355\u5168\u751f\u547d\u5468\u671f
\nCREATE TABLE dwd.fact_order_lifecycle (
\n order_key BIGINT,
\n user_key INT,
\n — \u65f6\u95f4\u8282\u70b9
\n create_time TIMESTAMP,
\n pay_time TIMESTAMP,
\n ship_time TIMESTAMP,
\n confirm_time TIMESTAMP,
\n refund_time TIMESTAMP,
\n — \u65f6\u957f\u8ba1\u7b97
\n pay_duration_seconds INT, — \u4e0b\u5355\u5230\u652f\u4ed8\u65f6\u957f
\n ship_duration_seconds INT, — \u652f\u4ed8\u5230\u53d1\u8d27\u65f6\u957f
\n delivery_duration_seconds INT, — \u53d1\u8d27\u5230\u786e\u8ba4\u65f6\u957f
\n — \u5f53\u524d\u72b6\u6001
\n current_status STRING,
\n last_update_time TIMESTAMP,
\n dt STRING
\n); <\/p>\n \u516d\u3001\u6700\u4f73\u5b9e\u8df5\u5efa\u8bae<\/h3>\n1.\u00a0\u8bbe\u8ba1\u539f\u5219<\/h4>\n\n- \n
\u4e00\u81f4\u6027：\u540c\u4e00\u4e1a\u52a1\u8fc7\u7a0b\u5728\u4e0d\u540c\u8868\u4e2d\u5b9a\u4e49\u4e00\u81f4<\/p>\n<\/li>\n - \n
\u5b8c\u6574\u6027：\u786e\u4fdd\u5173\u952e\u4e1a\u52a1\u8fc7\u7a0b\u90fd\u6709\u5bf9\u5e94\u4e8b\u5b9e\u8868<\/p>\n<\/li>\n - \n
\u53ef\u8ffd\u6eaf：\u4fdd\u7559\u6570\u636e\u8840\u7f18，\u4fbf\u4e8e\u95ee\u9898\u6392\u67e5<\/p>\n<\/li>\n<\/ul>\n 2.\u00a0\u6027\u80fd\u4f18\u5316<\/h4>\n— \u5206\u533a\u7b56\u7565\u4f18\u5316
\nPARTITIONED BY (dt STRING, hour STRING) — \u53cc\u7ea7\u5206\u533a<\/p>\n — \u7d22\u5f15\u4f18\u5316
\nCREATE INDEX idx_user_date ON dwd.fact_order (user_key, date_key);<\/p>\n — \u6570\u636e\u751f\u547d\u5468\u671f\u7ba1\u7406
\nALTER TABLE dwd.fact_order_detail
\nDROP PARTITION (dt < '2023-01-01'); — \u5b9a\u671f\u6e05\u7406\u5386\u53f2\u6570\u636e <\/p>\n 3.\u00a0\u6570\u636e\u8d28\u91cf\u4fdd\u969c<\/h4>\n— \u589e\u52a0\u6570\u636e\u8d28\u91cf\u68c0\u67e5\u5b57\u6bb5
\nALTER TABLE dwd.fact_order_detail ADD COLUMNS (
\n data_source STRING COMMENT '\u6570\u636e\u6765\u6e90',
\n etl_batch_id STRING COMMENT 'ETL\u6279\u6b21ID',
\n checksum_value STRING COMMENT '\u6570\u636e\u6821\u9a8c\u503c',
\n quality_score DECIMAL(3,2) COMMENT '\u6570\u636e\u8d28\u91cf\u8bc4\u5206'
\n); <\/p>\n \u901a\u8fc7\u8fd9\u6837\u7684\u5206\u5c42\u8bbe\u8ba1，DWD\u5c42\u4e3a\u4e0a\u5c42\u5e94\u7528\u63d0\u4f9b\u4e86\u5e72\u51c0\u3001\u4e00\u81f4\u3001\u6613\u7528\u7684\u6570\u636e\u57fa\u7840，\u662f\u6570\u636e\u4ed3\u5e93\u5efa\u8bbe\u7684\u6838\u5fc3\u73af\u8282\u3002<\/p>\n","protected":false},"excerpt":{"rendered":" \u76ee\u5f55 \u4e00\u3001DWD\u5c42\u4ecb\u7ecd
\n\u4e13\u4e1a\u89e3\u91ca：
\n\u901a\u4fd7\u89e3\u91ca：
\n\u4e3e\u4f8b：\u7535\u5546\u8ba2\u5355\u5904\u7406
\n\u4e8c\u3001DWD\u5c42\u4e8b\u52a1\u8868\u8be6\u89e3
\n1. \u7ef4\u5ea6\u4e0e\u5ea6\u91cf\u503c
\n2. \u5b58\u50a8\u65b9\u5f0f
\n3. \u538b\u7f29\u65b9\u5f0f
\n4. \u6570\u636e\u57df\u5212\u5206
\n\u4e09\u3001\u4e8b\u52a1\u8868\u5206\u7c7b\u8be6\u89e3
\n1. \u4e8b\u52a1\u4e8b\u5b9e\u8868（Transaction Fact Table）
\n2. \u5468\u671f\u5feb\u7167\u4e8b\u5b9e\u8868（Periodic Snapshot Fact Table）
\n3. \u7d2f\u79ef\u5feb\u7167\u4e8b\u5b9e\u8868<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[323,371,2330,305],"topic":[],"class_list":["post-69641","post","type-post","status-publish","format-standard","hentry","category-server","tag-323","tag-371","tag-2330","tag-305"],"yoast_head":"\n 27-\u5b66\u4e60\u7b14\u8bb0\u5c1a\u7845\u8c37\u6570\u4ed3\u642d\u5efa-\u6570\u636e\u4ed3\u5e93DWD\u5c42\u4ecb\u7ecd\u53ca\u5176\u4e8b\u52a1\u8868\uff08\u884c\u4e3a\uff09\u76f8\u5173\u6982\u5ff5 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wsisp.com\/helps\/69641.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"27-\u5b66\u4e60\u7b14\u8bb0\u5c1a\u7845\u8c37\u6570\u4ed3\u642d\u5efa-\u6570\u636e\u4ed3\u5e93DWD\u5c42\u4ecb\u7ecd\u53ca\u5176\u4e8b\u52a1\u8868\uff08\u884c\u4e3a\uff09\u76f8\u5173\u6982\u5ff5 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"\u76ee\u5f55 \u4e00\u3001DWD\u5c42\u4ecb\u7ecd \u4e13\u4e1a\u89e3\u91ca： \u901a\u4fd7\u89e3\u91ca： \u4e3e\u4f8b：\u7535\u5546\u8ba2\u5355\u5904\u7406 \u4e8c\u3001DWD\u5c42\u4e8b\u52a1\u8868\u8be6\u89e3 1. \u7ef4\u5ea6\u4e0e\u5ea6\u91cf\u503c 2. \u5b58\u50a8\u65b9\u5f0f 3. \u538b\u7f29\u65b9\u5f0f 4. \u6570\u636e\u57df\u5212\u5206 \u4e09\u3001\u4e8b\u52a1\u8868\u5206\u7c7b\u8be6\u89e3 1. \u4e8b\u52a1\u4e8b\u5b9e\u8868（Transaction Fact Table） 2. \u5468\u671f\u5feb\u7167\u4e8b\u5b9e\u8868（Periodic Snapshot Fact Table） 3. \u7d2f\u79ef\u5feb\u7167\u4e8b\u5b9e\u8868\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/69641.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2026-01-31T15:32:45+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/69641.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/69641.html\",\"name\":\"27-\u5b66\u4e60\u7b14\u8bb0\u5c1a\u7845\u8c37\u6570\u4ed3\u642d\u5efa-\u6570\u636e\u4ed3\u5e93DWD\u5c42\u4ecb\u7ecd\u53ca\u5176\u4e8b\u52a1\u8868\uff08\u884c\u4e3a\uff09\u76f8\u5173\u6982\u5ff5 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2026-01-31T15:32:45+00:00\",\"dateModified\":\"2026-01-31T15:32:45+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/69641.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/69641.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/69641.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"27-\u5b66\u4e60\u7b14\u8bb0\u5c1a\u7845\u8c37\u6570\u4ed3\u642d\u5efa-\u6570\u636e\u4ed3\u5e93DWD\u5c42\u4ecb\u7ecd\u53ca\u5176\u4e8b\u52a1\u8868\uff08\u884c\u4e3a\uff09\u76f8\u5173\u6982\u5ff5\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"27-\u5b66\u4e60\u7b14\u8bb0\u5c1a\u7845\u8c37\u6570\u4ed3\u642d\u5efa-\u6570\u636e\u4ed3\u5e93DWD\u5c42\u4ecb\u7ecd\u53ca\u5176\u4e8b\u52a1\u8868\uff08\u884c\u4e3a\uff09\u76f8\u5173\u6982\u5ff5 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wsisp.com\/helps\/69641.html","og_locale":"zh_CN","og_type":"article","og_title":"27-\u5b66\u4e60\u7b14\u8bb0\u5c1a\u7845\u8c37\u6570\u4ed3\u642d\u5efa-\u6570\u636e\u4ed3\u5e93DWD\u5c42\u4ecb\u7ecd\u53ca\u5176\u4e8b\u52a1\u8868\uff08\u884c\u4e3a\uff09\u76f8\u5173\u6982\u5ff5 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"\u76ee\u5f55 \u4e00\u3001DWD\u5c42\u4ecb\u7ecd \u4e13\u4e1a\u89e3\u91ca： \u901a\u4fd7\u89e3\u91ca： \u4e3e\u4f8b：\u7535\u5546\u8ba2\u5355\u5904\u7406 \u4e8c\u3001DWD\u5c42\u4e8b\u52a1\u8868\u8be6\u89e3 1. \u7ef4\u5ea6\u4e0e\u5ea6\u91cf\u503c 2. \u5b58\u50a8\u65b9\u5f0f 3. \u538b\u7f29\u65b9\u5f0f 4. \u6570\u636e\u57df\u5212\u5206 \u4e09\u3001\u4e8b\u52a1\u8868\u5206\u7c7b\u8be6\u89e3 1. \u4e8b\u52a1\u4e8b\u5b9e\u8868（Transaction Fact Table） 2. \u5468\u671f\u5feb\u7167\u4e8b\u5b9e\u8868（Periodic Snapshot Fact Table） 3. \u7d2f\u79ef\u5feb\u7167\u4e8b\u5b9e\u8868","og_url":"https:\/\/www.wsisp.com\/helps\/69641.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2026-01-31T15:32:45+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"5 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/69641.html","url":"https:\/\/www.wsisp.com\/helps\/69641.html","name":"27-\u5b66\u4e60\u7b14\u8bb0\u5c1a\u7845\u8c37\u6570\u4ed3\u642d\u5efa-\u6570\u636e\u4ed3\u5e93DWD\u5c42\u4ecb\u7ecd\u53ca\u5176\u4e8b\u52a1\u8868\uff08\u884c\u4e3a\uff09\u76f8\u5173\u6982\u5ff5 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2026-01-31T15:32:45+00:00","dateModified":"2026-01-31T15:32:45+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/69641.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/69641.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/69641.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"27-\u5b66\u4e60\u7b14\u8bb0\u5c1a\u7845\u8c37\u6570\u4ed3\u642d\u5efa-\u6570\u636e\u4ed3\u5e93DWD\u5c42\u4ecb\u7ecd\u53ca\u5176\u4e8b\u52a1\u8868\uff08\u884c\u4e3a\uff09\u76f8\u5173\u6982\u5ff5"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/69641","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=69641"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/69641\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=69641"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=69641"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=69641"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=69641"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}} | |