"CREATE TABLE `online_base_df` (
`xma_session_id` varchar(255) NULL COMMENT ""会话编号"",
`dt` date NULL COMMENT ""分区日期"",
`xma_begin_time` datetime NULL COMMENT ""Xma会话开始时间"",
`xma_prod_name` varchar(100) NULL COMMENT ""im会话来源渠道描述"",
`unique_id` varchar(255) NULL COMMENT ""客户唯一标识"",
`dz_customer_id` varchar(255) NULL COMMENT ""会话对应用户编号"",
`app_code` varchar(50) NULL COMMENT ""appCode"",
`distribute_status` varchar(50) NULL COMMENT ""im分配类型"",
`is_flow` varchar(20) NULL COMMENT ""xma是否分流"",
`ima_session_id` varchar(255) NULL COMMENT ""会话编号"",
`ima_begin_time` datetime NULL COMMENT ""ima开始时间"",
`ima_end_time` datetime NULL COMMENT ""ima结束时间"",
`to_cust_svc` varchar(100) NULL COMMENT ""姓名"",
`first_resp_dur` double NULL COMMENT ""人工首次回复时长"",
`avg_reply_dur` double NULL COMMENT ""平均回复时长"",
`brief_sum1` varchar(255) NULL COMMENT ""第一小结"",
`brief_sum2` varchar(255) NULL COMMENT ""第二小结"",
`brief_sum3` varchar(255) NULL COMMENT ""第三小结"",
`next_xma_time` datetime NULL COMMENT ""下次xma进线时间"",
`work_order_number` varchar(255) NULL COMMENT ""工单编号"",
`next_ivr_call` datetime NULL COMMENT ""二次进线"",
`is_repeat_48h` varchar(20) NULL COMMENT ""48h重复进线"",
`is_repeat_72h` varchar(20) NULL COMMENT ""72h重复进线"",
`is_repeat_96h` varchar(20) NULL COMMENT ""96h重复进线"",
`is_repeat_7d` varchar(20) NULL COMMENT ""7D重复进线"",
`is_solve_48h` varchar(20) NULL COMMENT ""48h未解决"",
`is_solve_72h` varchar(20) NULL COMMENT ""72h未解决"",
`is_solve_96h` varchar(20) NULL COMMENT ""96h未解决"",
`is_solve_7d` varchar(20) NULL COMMENT ""7D未解决""
) ENGINE=OLAP
DUPLICATE KEY(`xma_session_id`, `dt`)
COMMENT ""在线宽表分析表""
PARTITION BY RANGE(`dt`)
(PARTITION p20250501 VALUES [(""2025-05-01""), (""2025-05-02"")),
PARTITION p20250502 VALUES [(""2025-05-02""), (""2025-05-03"")),
PARTITION p20250503 VALUES [(""2025-05-03""), (""2025-05-04"")),
PARTITION p20250504 VALUES [(""2025-05-04""), (""2025-05-05"")),
PARTITION p20250505 VALUES [(""2025-05-05""), (""2025-05-06"")),
PARTITION p20250506 VALUES [(""2025-05-06""), (""2025-05-07"")),
PARTITION p20250507 VALUES [(""2025-05-07""), (""2025-05-08"")),
PARTITION p20250508 VALUES [(""2025-05-08""), (""2025-05-09"")),
PARTITION p20250509 VALUES [(""2025-05-09""), (""2025-05-10"")),
PARTITION p20250510 VALUES [(""2025-05-10""), (""2025-05-11"")),
PARTITION p20250511 VALUES [(""2025-05-11""), (""2025-05-12"")),
PARTITION p20250512 VALUES [(""2025-05-12""), (""2025-05-13"")),
PARTITION p20250513 VALUES [(""2025-05-13""), (""2025-05-14"")),
PARTITION p20250514 VALUES [(""2025-05-14""), (""2025-05-15"")),
PARTITION p20250515 VALUES [(""2025-05-15""), (""2025-05-16"")),
PARTITION p20250516 VALUES [(""2025-05-16""), (""2025-05-17"")),
PARTITION p20250517 VALUES [(""2025-05-17""), (""2025-05-18"")),
PARTITION p20250518 VALUES [(""2025-05-18""), (""2025-05-19"")),
PARTITION p20250519 VALUES [(""2025-05-19""), (""2025-05-20"")),
PARTITION p20250520 VALUES [(""2025-05-20""), (""2025-05-21"")),
PARTITION p20250521 VALUES [(""2025-05-21""), (""2025-05-22"")),
PARTITION p20250522 VALUES [(""2025-05-22""), (""2025-05-23"")),
PARTITION p20250523 VALUES [(""2025-05-23""), (""2025-05-24"")),
PARTITION p20250524 VALUES [(""2025-05-24""), (""2025-05-25"")),
PARTITION p20250525 VALUES [(""2025-05-25""), (""2025-05-26"")),
PARTITION p20250526 VALUES [(""2025-05-26""), (""2025-05-27"")),
PARTITION p20250527 VALUES [(""2025-05-27""), (""2025-05-28"")),
PARTITION p20250528 VALUES [(""2025-05-28""), (""2025-05-29"")),
PARTITION p20250529 VALUES [(""2025-05-29""), (""2025-05-30"")),
PARTITION p20250530 VALUES [(""2025-05-30""), (""2025-05-31"")),
PARTITION p20250531 VALUES [(""2025-05-31""), (""2025-06-01"")),
PARTITION p20250601 VALUES [(""2025-06-01""), (""2025-06-02"")),
PARTITION p20250602 VALUES [(""2025-06-02""), (""2025-06-03"")),
PARTITION p20250603 VALUES [(""2025-06-03""), (""2025-06-04"")),
PARTITION p20250604 VALUES [(""2025-06-04""), (""2025-06-05"")),
PARTITION p20250605 VALUES [(""2025-06-05""), (""2025-06-06"")),
PARTITION p20250606 VALUES [(""2025-06-06""), (""2025-06-07"")),
PARTITION p20250607 VALUES [(""2025-06-07""), (""2025-06-08"")),
PARTITION p20250608 VALUES [(""2025-06-08""), (""2025-06-09"")),
PARTITION p20250609 VALUES [(""2025-06-09""), (""2025-06-10"")),
PARTITION p20250610 VALUES [(""2025-06-10""), (""2025-06-11"")),
PARTITION p20250611 VALUES [(""2025-06-11""), (""2025-06-12"")),
PARTITION p20250612 VALUES [(""2025-06-12""), (""2025-06-13"")),
PARTITION p20250613 VALUES [(""2025-06-13""), (""2025-06-14"")),
PARTITION p20250614 VALUES [(""2025-06-14""), (""2025-06-15"")),
PARTITION p20250615 VALUES [(""2025-06-15""), (""2025-06-16"")),
PARTITION p20250616 VALUES [(""2025-06-16""), (""2025-06-17"")),
PARTITION p20250617 VALUES [(""2025-06-17""), (""2025-06-18"")),
PARTITION p20250618 VALUES [(""2025-06-18""), (""2025-06-19"")),
PARTITION p20250619 VALUES [(""2025-06-19""), (""2025-06-20"")),
PARTITION p20250620 VALUES [(""2025-06-20""), (""2025-06-21"")),
PARTITION p20250621 VALUES [(""2025-06-21""), (""2025-06-22"")),
PARTITION p20250622 VALUES [(""2025-06-22""), (""2025-06-23"")),
PARTITION p20250623 VALUES [(""2025-06-23""), (""2025-06-24"")),
PARTITION p20250624 VALUES [(""2025-06-24""), (""2025-06-25"")),
PARTITION p20250625 VALUES [(""2025-06-25""), (""2025-06-26"")),
PARTITION p20250626 VALUES [(""2025-06-26""), (""2025-06-27"")),
PARTITION p20250627 VALUES [(""2025-06-27""), (""2025-06-28"")),
PARTITION p20250628 VALUES [(""2025-06-28""), (""2025-06-29"")),
PARTITION p20250629 VALUES [(""2025-06-29""), (""2025-06-30"")),
PARTITION p20250630 VALUES [(""2025-06-30""), (""2025-07-01"")),
PARTITION p20250701 VALUES [(""2025-07-01""), (""2025-07-02"")),
PARTITION p20250702 VALUES [(""2025-07-02""), (""2025-07-03"")),
PARTITION p20250703 VALUES [(""2025-07-03""), (""2025-07-04"")),
PARTITION p20250704 VALUES [(""2025-07-04""), (""2025-07-05"")),
PARTITION p20250705 VALUES [(""2025-07-05""), (""2025-07-06"")),
PARTITION p20250706 VALUES [(""2025-07-06""), (""2025-07-07"")),
PARTITION p20250707 VALUES [(""2025-07-07""), (""2025-07-08"")),
PARTITION p20250708 VALUES [(""2025-07-08""), (""2025-07-09"")),
PARTITION p20250709 VALUES [(""2025-07-09""), (""2025-07-10"")),
PARTITION p20250710 VALUES [(""2025-07-10""), (""2025-07-11"")),
PARTITION p20250711 VALUES [(""2025-07-11""), (""2025-07-12"")),
PARTITION p20250712 VALUES [(""2025-07-12""), (""2025-07-13"")),
PARTITION p20250713 VALUES [(""2025-07-13""), (""2025-07-14"")),
PARTITION p20250714 VALUES [(""2025-07-14""), (""2025-07-15"")),
PARTITION p20250715 VALUES [(""2025-07-15""), (""2025-07-16"")),
PARTITION p20250716 VALUES [(""2025-07-16""), (""2025-07-17"")),
PARTITION p20250717 VALUES [(""2025-07-17""), (""2025-07-18"")),
PARTITION p20250718 VALUES [(""2025-07-18""), (""2025-07-19"")),
PARTITION p20250719 VALUES [(""2025-07-19""), (""2025-07-20"")),
PARTITION p20250720 VALUES [(""2025-07-20""), (""2025-07-21"")),
PARTITION p20250721 VALUES [(""2025-07-21""), (""2025-07-22"")),
PARTITION p20250722 VALUES [(""2025-07-22""), (""2025-07-23"")),
PARTITION p20250723 VALUES [(""2025-07-23""), (""2025-07-24"")),
PARTITION p20250724 VALUES [(""2025-07-24""), (""2025-07-25"")),
PARTITION p20250725 VALUES [(""2025-07-25""), (""2025-07-26"")),
PARTITION p20250726 VALUES [(""2025-07-26""), (""2025-07-27"")),
PARTITION p20250727 VALUES [(""2025-07-27""), (""2025-07-28"")),
PARTITION p20250728 VALUES [(""2025-07-28""), (""2025-07-29"")),
PARTITION p20250729 VALUES [(""2025-07-29""), (""2025-07-30"")),
PARTITION p20250730 VALUES [(""2025-07-30""), (""2025-07-31"")),
PARTITION p20250731 VALUES [(""2025-07-31""), (""2025-08-01"")),
PARTITION p20250801 VALUES [(""2025-08-01""), (""2025-08-02"")),
PARTITION p20250802 VALUES [(""2025-08-02""), (""2025-08-03"")),
PARTITION p20250803 VALUES [(""2025-08-03""), (""2025-08-04"")),
PARTITION p20250804 VALUES [(""2025-08-04""), (""2025-08-05"")),
PARTITION p20250805 VALUES [(""2025-08-05""), (""2025-08-06"")),
PARTITION p20250806 VALUES [(""2025-08-06""), (""2025-08-07"")),
PARTITION p20250807 VALUES [(""2025-08-07""), (""2025-08-08"")),
PARTITION p20250808 VALUES [(""2025-08-08""), (""2025-08-09"")),
PARTITION p20250809 VALUES [(""2025-08-09""), (""2025-08-10"")),
PARTITION p20250810 VALUES [(""2025-08-10""), (""2025-08-11"")),
PARTITION p20250811 VALUES [(""2025-08-11""), (""2025-08-12"")),
PARTITION p20250812 VALUES [(""2025-08-12""), (""2025-08-13"")),
PARTITION p20250813 VALUES [(""2025-08-13""), (""2025-08-14"")),
PARTITION p20250814 VALUES [(""2025-08-14""), (""2025-08-15"")),
PARTITION p20250815 VALUES [(""2025-08-15""), (""2025-08-16"")),
PARTITION p20250816 VALUES [(""2025-08-16""), (""2025-08-17"")),
PARTITION p20250817 VALUES [(""2025-08-17""), (""2025-08-18"")),
PARTITION p20250818 VALUES [(""2025-08-18""), (""2025-08-19"")),
PARTITION p20250819 VALUES [(""2025-08-19""), (""2025-08-20"")),
PARTITION p20250820 VALUES [(""2025-08-20""), (""2025-08-21"")),
PARTITION p20250821 VALUES [(""2025-08-21""), (""2025-08-22"")),
PARTITION p20250822 VALUES [(""2025-08-22""), (""2025-08-23"")),
PARTITION p20250823 VALUES [(""2025-08-23""), (""2025-08-24"")),
PARTITION p20250824 VALUES [(""2025-08-24""), (""2025-08-25"")),
PARTITION p20250825 VALUES [(""2025-08-25""), (""2025-08-26"")),
PARTITION p20250826 VALUES [(""2025-08-26""), (""2025-08-27"")),
PARTITION p20250827 VALUES [(""2025-08-27""), (""2025-08-28"")),
PARTITION p20250828 VALUES [(""2025-08-28""), (""2025-08-29"")),
PARTITION p20250829 VALUES [(""2025-08-29""), (""2025-08-30"")),
PARTITION p20250830 VALUES [(""2025-08-30""), (""2025-08-31"")),
PARTITION p20250831 VALUES [(""2025-08-31""), (""2025-09-01"")),
PARTITION p20250901 VALUES [(""2025-09-01""), (""2025-09-02"")),
PARTITION p20250902 VALUES [(""2025-09-02""), (""2025-09-03"")),
PARTITION p20250903 VALUES [(""2025-09-03""), (""2025-09-04"")),
PARTITION p20250904 VALUES [(""2025-09-04""), (""2025-09-05"")),
PARTITION p20250905 VALUES [(""2025-09-05""), (""2025-09-06"")),
PARTITION p20250906 VALUES [(""2025-09-06""), (""2025-09-07"")),
PARTITION p20250907 VALUES [(""2025-09-07""), (""2025-09-08"")),
PARTITION p20250908 VALUES [(""2025-09-08""), (""2025-09-09"")),
PARTITION p20250909 VALUES [(""2025-09-09""), (""2025-09-10"")),
PARTITION p20250910 VALUES [(""2025-09-10""), (""2025-09-11"")),
PARTITION p20250911 VALUES [(""2025-09-11""), (""2025-09-12"")),
PARTITION p20250912 VALUES [(""2025-09-12""), (""2025-09-13"")),
PARTITION p20250913 VALUES [(""2025-09-13""), (""2025-09-14"")),
PARTITION p20250914 VALUES [(""2025-09-14""), (""2025-09-15"")),
PARTITION p20250915 VALUES [(""2025-09-15""), (""2025-09-16"")),
PARTITION p20250916 VALUES [(""2025-09-16""), (""2025-09-17"")),
PARTITION p20250917 VALUES [(""2025-09-17""), (""2025-09-18"")),
PARTITION p20250918 VALUES [(""2025-09-18""), (""2025-09-19"")),
PARTITION p20250919 VALUES [(""2025-09-19""), (""2025-09-20"")),
PARTITION p20250920 VALUES [(""2025-09-20""), (""2025-09-21"")),
PARTITION p20250921 VALUES [(""2025-09-21""), (""2025-09-22"")),
PARTITION p20250922 VALUES [(""2025-09-22""), (""2025-09-23"")),
PARTITION p20250923 VALUES [(""2025-09-23""), (""2025-09-24"")),
PARTITION p20250924 VALUES [(""2025-09-24""), (""2025-09-25"")),
PARTITION p20250925 VALUES [(""2025-09-25""), (""2025-09-26"")),
PARTITION p20250926 VALUES [(""2025-09-26""), (""2025-09-27"")),
PARTITION p20250927 VALUES [(""2025-09-27""), (""2025-09-28"")),
PARTITION p20250928 VALUES [(""2025-09-28""), (""2025-09-29"")),
PARTITION p20250929 VALUES [(""2025-09-29""), (""2025-09-30"")),
PARTITION p20250930 VALUES [(""2025-09-30""), (""2025-10-01"")),
PARTITION p20251001 VALUES [(""2025-10-01""), (""2025-10-02"")),
PARTITION p20251002 VALUES [(""2025-10-02""), (""2025-10-03"")),
PARTITION p20251003 VALUES [(""2025-10-03""), (""2025-10-04"")),
PARTITION p20251004 VALUES [(""2025-10-04""), (""2025-10-05"")),
PARTITION p20251005 VALUES [(""2025-10-05""), (""2025-10-06"")),
PARTITION p20251006 VALUES [(""2025-10-06""), (""2025-10-07"")),
PARTITION p20251007 VALUES [(""2025-10-07""), (""2025-10-08"")),
PARTITION p20251008 VALUES [(""2025-10-08""), (""2025-10-09"")),
PARTITION p20251009 VALUES [(""2025-10-09""), (""2025-10-10"")),
PARTITION p20251010 VALUES [(""2025-10-10""), (""2025-10-11"")),
PARTITION p20251011 VALUES [(""2025-10-11""), (""2025-10-12"")),
PARTITION p20251012 VALUES [(""2025-10-12""), (""2025-10-13"")),
PARTITION p20251013 VALUES [(""2025-10-13""), (""2025-10-14"")),
PARTITION p20251014 VALUES [(""2025-10-14""), (""2025-10-15"")),
PARTITION p20251015 VALUES [(""2025-10-15""), (""2025-10-16"")),
PARTITION p20251016 VALUES [(""2025-10-16""), (""2025-10-17"")),
PARTITION p20251017 VALUES [(""2025-10-17""), (""2025-10-18"")),
PARTITION p20251018 VALUES [(""2025-10-18""), (""2025-10-19"")),
PARTITION p20251019 VALUES [(""2025-10-19""), (""2025-10-20"")),
PARTITION p20251020 VALUES [(""2025-10-20""), (""2025-10-21"")),
PARTITION p20251021 VALUES [(""2025-10-21""), (""2025-10-22"")),
PARTITION p20251022 VALUES [(""2025-10-22""), (""2025-10-23"")),
PARTITION p20251023 VALUES [(""2025-10-23""), (""2025-10-24"")),
PARTITION p20251024 VALUES [(""2025-10-24""), (""2025-10-25"")),
PARTITION p20251025 VALUES [(""2025-10-25""), (""2025-10-26"")),
PARTITION p20251026 VALUES [(""2025-10-26""), (""2025-10-27"")),
PARTITION p20251027 VALUES [(""2025-10-27""), (""2025-10-28"")),
PARTITION p20251028 VALUES [(""2025-10-28""), (""2025-10-29"")),
PARTITION p20251029 VALUES [(""2025-10-29""), (""2025-10-30"")),
PARTITION p20251030 VALUES [(""2025-10-30""), (""2025-10-31"")),
PARTITION p20251031 VALUES [(""2025-10-31""), (""2025-11-01"")),
PARTITION p20251101 VALUES [(""2025-11-01""), (""2025-11-02"")),
PARTITION p20251102 VALUES [(""2025-11-02""), (""2025-11-03"")),
PARTITION p20251103 VALUES [(""2025-11-03""), (""2025-11-04"")),
PARTITION p20251104 VALUES [(""2025-11-04""), (""2025-11-05"")),
PARTITION p20251105 VALUES [(""2025-11-05""), (""2025-11-06"")),
PARTITION p20251106 VALUES [(""2025-11-06""), (""2025-11-07"")),
PARTITION p20251107 VALUES [(""2025-11-07""), (""2025-11-08"")),
PARTITION p20251108 VALUES [(""2025-11-08""), (""2025-11-09"")),
PARTITION p20251109 VALUES [(""2025-11-09""), (""2025-11-10"")),
PARTITION p20251110 VALUES [(""2025-11-10""), (""2025-11-11"")),
PARTITION p20251111 VALUES [(""2025-11-11""), (""2025-11-12"")),
PARTITION p20251112 VALUES [(""2025-11-12""), (""2025-11-13"")),
PARTITION p20251113 VALUES [(""2025-11-13""), (""2025-11-14"")),
PARTITION p20251114 VALUES [(""2025-11-14""), (""2025-11-15"")),
PARTITION p20251115 VALUES [(""2025-11-15""), (""2025-11-16"")),
PARTITION p20251116 VALUES [(""2025-11-16""), (""2025-11-17"")),
PARTITION p20251117 VALUES [(""2025-11-17""), (""2025-11-18"")),
PARTITION p20251118 VALUES [(""2025-11-18""), (""2025-11-19"")),
PARTITION p20251119 VALUES [(""2025-11-19""), (""2025-11-20"")),
PARTITION p20251120 VALUES [(""2025-11-20""), (""2025-11-21"")),
PARTITION p20251121 VALUES [(""2025-11-21""), (""2025-11-22"")),
PARTITION p20251122 VALUES [(""2025-11-22""), (""2025-11-23"")),
PARTITION p20251123 VALUES [(""2025-11-23""), (""2025-11-24"")),
PARTITION p20251124 VALUES [(""2025-11-24""), (""2025-11-25"")),
PARTITION p20251125 VALUES [(""2025-11-25""), (""2025-11-26"")),
PARTITION p20251126 VALUES [(""2025-11-26""), (""2025-11-27"")),
PARTITION p20251127 VALUES [(""2025-11-27""), (""2025-11-28"")),
PARTITION p20251128 VALUES [(""2025-11-28""), (""2025-11-29"")),
PARTITION p20251129 VALUES [(""2025-11-29""), (""2025-11-30"")),
PARTITION p20251130 VALUES [(""2025-11-30""), (""2025-12-01"")),
PARTITION p20251201 VALUES [(""2025-12-01""), (""2025-12-02"")),
PARTITION p20251202 VALUES [(""2025-12-02""), (""2025-12-03"")),
PARTITION p20251203 VALUES [(""2025-12-03""), (""2025-12-04"")),
PARTITION p20251204 VALUES [(""2025-12-04""), (""2025-12-05"")),
PARTITION p20251205 VALUES [(""2025-12-05""), (""2025-12-06"")),
PARTITION p20251206 VALUES [(""2025-12-06""), (""2025-12-07"")),
PARTITION p20251207 VALUES [(""2025-12-07""), (""2025-12-08"")),
PARTITION p20251208 VALUES [(""2025-12-08""), (""2025-12-09"")),
PARTITION p20251209 VALUES [(""2025-12-09""), (""2025-12-10"")),
PARTITION p20251210 VALUES [(""2025-12-10""), (""2025-12-11"")),
PARTITION p20251211 VALUES [(""2025-12-11""), (""2025-12-12"")),
PARTITION p20251212 VALUES [(""2025-12-12""), (""2025-12-13"")),
PARTITION p20251213 VALUES [(""2025-12-13""), (""2025-12-14"")),
PARTITION p20251214 VALUES [(""2025-12-14""), (""2025-12-15"")),
PARTITION p20251215 VALUES [(""2025-12-15""), (""2025-12-16"")),
PARTITION p20251216 VALUES [(""2025-12-16""), (""2025-12-17"")),
PARTITION p20251217 VALUES [(""2025-12-17""), (""2025-12-18"")),
PARTITION p20251218 VALUES [(""2025-12-18""), (""2025-12-19"")),
PARTITION p20251219 VALUES [(""2025-12-19""), (""2025-12-20"")),
PARTITION p20251220 VALUES [(""2025-12-20""), (""2025-12-21"")),
PARTITION p20251221 VALUES [(""2025-12-21""), (""2025-12-22"")),
PARTITION p20251222 VALUES [(""2025-12-22""), (""2025-12-23"")),
PARTITION p20251223 VALUES [(""2025-12-23""), (""2025-12-24"")),
PARTITION p20251224 VALUES [(""2025-12-24""), (""2025-12-25"")),
PARTITION p20251225 VALUES [(""2025-12-25""), (""2025-12-26"")),
PARTITION p20251226 VALUES [(""2025-12-26""), (""2025-12-27"")),
PARTITION p20251227 VALUES [(""2025-12-27""), (""2025-12-28"")),
PARTITION p20251228 VALUES [(""2025-12-28""), (""2025-12-29"")),
PARTITION p20251229 VALUES [(""2025-12-29""), (""2025-12-30"")),
PARTITION p20251230 VALUES [(""2025-12-30""), (""2025-12-31"")))
DISTRIBUTED BY HASH(`xma_session_id`) BUCKETS 10
PROPERTIES (
""replication_num"" = ""3"",
""in_memory"" = ""false"",
""enable_persistent_index"" = ""false"",
""replicated_storage"" = ""true"",
""storage_medium"" = ""SSD"",
""compression"" = ""LZ4""
);"
这个表,我每次同步另一个表数据进去时,他就会出现两份数据,每次写入的数据都是最新的全量数据,该怎么建表