新年了,送你一份新年礼物,做数仓的都需要,哈哈!!!
建表语句
DROP TABLE IF EXISTS dim_date_info;
CREATE EXTERNAL TABLE dim_date_info(
`date_id` STRING COMMENT '日',
`week_id` STRING COMMENT '周ID',
`week_day` STRING COMMENT '周几',
`day` STRING COMMENT '每月的第几天',
`month` STRING COMMENT '第几月',
`quarter` STRING COMMENT '第几季度',
`year` STRING COMMENT '年',
`is_workday` STRING COMMENT '是否是工作日',
`holiday_id` STRING COMMENT '节假日'
) COMMENT '时间维度表'
STORED AS ORC
LOCATION '/warehouse/xxx/dim/dim_date_info/'
TBLPROPERTIES ("orc.compress"="snappy");
日期内容
2021-01-01 1 5 1 1 1 2021 0 元旦
2021-01-02 1 6 2 1 1 2021 0 元旦
2021-01-03 1 7 3 1 1 2021 0 元旦
2021-01-04 2 1 4 1 1 2021 1 \N
2021-01-05 2 2 5 1 1 2021 1 \N
2021-01-06 2 3 6 1 1 2021 1 \N
2021-01-07 2 4 7 1 1 2021 1 \N
2021-01-08 2 5 8 1 1 2021 1 \N
2021-01-09 2 6 9 1 1 2021 0 \N
2021-01-10 2 7 10 1 1 2021 0 \N
2021-01-11 3 1 11 1 1 2021 1 \N
2021-01-12 3 2 12 1 1 2021 1 \N
2021-01-13 3 3 13 1 1 2021 1 \N
2021-01-14 3 4 14 1 1 2021 1 \N
2021-01-15 3 5 15 1 1 2021 1 \N
2021-01-16 3 6 16 1 1 2021 0 \N
2021-01-17 3 7 17 1 1 2021 0 \N
2021-01-18 4 1 18 1 1 2021 1 \N
2021-01-19 4 2 19 1 1 2021 1 \N
2021-01-20 4 3 20 1 1 2021 1 \N
2021-01-21 4 4 21 1 1 2021 1 \N
2021-01-22 4 5 22 1 1 2021 1 \N
2021-01-23 4 6 23 1 1 2021 0 \N
2021-01-24 4 7 24 1 1 2021 0 \N
2021-01-25 5 1 25 1 1 2021 1 \N
2021-01-26 5 2 26 1 1 2021 1 \N
2021-01-27 5 3 27 1 1 2021 1 \N
2021-01-28 5 4 28 1 1 2021 1 \N
2021-01-29 5 5 29 1 1 2021 1 \N
2021-01-30 5 6 30 1 1 2021 0 \N
2021-01-31 5 7 31 1 1 2021 0 \N
2021-02-01 6 1 1 2 1 2021 1 \N
2021-02-02 6 2 2 2 1 2021 1 \N
2021-02-03 6 3 3 2 1 2021 1 \N
2021-02-04 6 4 4 2 1 2021 1 \N
2021-02-05 6 5 5 2 1 2021 1 \N
2021-02-06 6 6 6 2 1 2021 0 \N
2021-02-07 6 7 7 2 1 2021 1 \N
2021-02-08 7 1 8 2 1 2021 1 \N
2021-02-09 7 2 9 2 1 2021 1 \N
2021-02-10 7 3 10 2 1 2021 1 \N
2021-02-11 7 4 11 2 1 2021 0 春节
2021-02-12 7 5 12 2 1 2021 0 春节
2021-02-13 7 6 13 2 1 2021 0 春节
2021-02-14 7 7 14 2 1 2021 0 春节
2021-02-15 8 1 15 2 1 2021 0 春节
2021-02-16 8 2 16 2 1 2021 0 春节
2021-02-17 8 3 17 2 1 2021 0 春节
2021-02-18 8 4 18 2 1 2021 1 \N
2021-02-19 8 5 19 2 1 2021 1 \N
2021-02-20 8 6 20 2 1 2021 1 \N
2021-02-21 8 7 21 2 1 2021 0 \N
2021-02-22 9 1 22 2 1 2021 1 \N
2021-02-23 9 2 23 2 1 2021 1 \N
2021-02-24 9 3 24 2 1 2021 1 \N
2021-02-25 9 4 25 2 1 2021 1 \N
2021-02-26 9 5 26 2 1 2021 1 \N
2021-02-27 9 6 27 2 1 2021 0 \N
2021-02-28 9 7 28 2 1 2021 0 \N
2021-03-01 10 1 1 3 1 2021 1 \N
2021-03-02 10 2 2 3 1 2021 1 \N
2021-03-03 10 3 3 3 1 2021 1 \N
2021-03-04 10 4 4 3 1 2021 1 \N
2021-03-05 10 5 5 3 1 2021 1 \N
2021-03-06 10 6 6 3 1 2021 0 \N
2021-03-07 10 7 7 3 1 2021 0 \N
2021-03-08 11 1 8 3 1 2021 1 \N
2021-03-09 11 2 9 3 1 2021 1 \N
2021-03-10 11 3 10 3 1 2021 1 \N
2021-03-11 11 4 11 3 1 2021 1 \N
2021-03-12 11 5 12 3 1 2021 1 \N
2021-03-13 11 6 13 3 1 2021 0 \N
2021-03-14 11 7 14 3 1 2021 0 \N
2021-03-15 12 1 15 3 1 2021 1 \N
2021-03-16 12 2 16 3 1 2021 1 \N
2021-03-17 12 3 17 3 1 2021 1 \N
2021-03-18 12 4 18 3 1 2021 1 \N
2021-03-19 12 5 19 3 1 2021 1 \N
2021-03-20 12 6 20 3 1 2021 0 \N
2021-03-21 12 7 21 3 1 2021 0 \N
2021-03-22 13 1 22 3 1 2021 1 \N
2021-03-23 13 2 23 3 1 2021 1 \N
2021-03-24 13 3 24 3 1 2021 1 \N
2021-03-25 13 4 25 3 1 2021 1 \N
2021-03-26 13 5 26 3 1 2021 1 \N
2021-03-27 13 6 27 3 1 2021 0 \N
2021-03-28 13 7 28 3 1 2021 0 \N
2021-03-29 14 1 29 3 1 2021 1 \N
2021-03-30 14 2 30 3 1 2021 1 \N
2021-03-31 14 3 31 3 1 2021 1 \N
2021-04-01 14 4 1 4 2 2021 1 \N
2021-04-02 14 5 2 4 2 2021 1 \N
2021-04-03 14 6 3 4 2 2021 0 清明节
2021-04-04 14 7 4 4 2 2021 0 清明节
2021-04-05 15 1 5 4 2 2021 0 清明节
2021-04-06 15 2 6 4 2 2021 1 \N
2021-04-07 15 3 7 4 2 2021 1 \N
2021-04-08 15 4 8 4 2 2021 1 \N
2021-04-09 15 5 9 4 2 2021 1 \N
2021-04-10 15 6 10 4 2 2021 0 \N
2021-04-11 15 7 11 4 2 2021 0 \N
2021-04-12 16 1 12 4 2 2021 1 \N
2021-04-13 16 2 13 4 2 2021 1 \N
2021-04-14 16 3 14 4 2 2021 1 \N
2021-04-15 16 4 15 4 2 2021 1 \N
2021-04-16 16 5 16 4 2 2021 1 \N
2021-04-17 16 6 17 4 2 2021 0 \N
2021-04-18 16 7 18 4 2 2021 0 \N
2021-04-19 17 1 19 4 2 2021 1 \N
2021-04-20 17 2 20 4 2 2021 1 \N
2021-04-21 17 3 21 4 2 2021 1 \N
2021-04-22 17 4 22 4 2 2021 1 \N
2021-04-23 17 5 23 4 2 2021 1 \N
2021-04-24 17 6 24 4 2 2021 0 \N
2021-04-25 17 7 25 4 2 2021 1 \N
2021-04-26 18 1 26 4 2 2021 1 \N
2021-04-27 18 2 27 4 2 2021 1 \N
2021-04-28 18 3 28 4 2 2021 1 \N
2021-04-29 18 4 29 4 2 2021 1 \N
2021-04-30 18 5 30 4 2 2021 1 \N
2021-05-01 18 6 1 5 2 2021 0 劳动节
2021-05-02 18 7 2 5 2 2021 0 劳动节
2021-05-03 19 1 3 5 2 2021 0 劳动节
2021-05-04 19 2 4 5 2 2021 0 劳动节
2021-05-05 19 3 5 5 2 2021 0 劳动节
2021-05-06 19 4 6 5 2 2021 1 \N
2021-05-07 19 5 7 5 2 2021 1 \N
2021-05-08 19 6 8 5 2 2021 1 \N
2021-05-09 19 7 9 5 2 2021 0 \N
2021-05-10 20 1 10 5 2 2021 1 \N
2021-05-11 20 2 11 5 2 2021 1 \N
2021-05-12 20 3 12 5 2 2021 1 \N
2021-05-13 20 4 13 5 2 2021 1 \N
2021-05-14 20 5 14 5 2 2021 1 \N
2021-05-15 20 6 15 5 2 2021 0 \N
2021-05-16 20 7 16 5 2 2021 0 \N
2021-05-17 21 1 17 5 2 2021 1 \N
2021-05-18 21 2 18 5 2 2021 1 \N
2021-05-19 21 3 19 5 2 2021 1 \N
2021-05-20 21 4 20 5 2 2021 1 \N
2021-05-21 21 5 21 5 2 2021 1 \N
2021-05-22 21 6 22 5 2 2021 0 \N
2021-05-23 21 7 23 5 2 2021 0 \N
2021-05-24 22 1 24 5 2 2021 1 \N
2021-05-25 22 2 25 5 2 2021 1 \N
2021-05-26 22 3 26 5 2 2021 1 \N
2021-05-27 22 4 27 5 2 2021 1 \N
2021-05-28 22 5 28 5 2 2021 1 \N
2021-05-29 22 6 29 5 2 2021 0 \N
2021-05-30 22 7 30 5 2 2021 0 \N
2021-05-31 23 1 31 5 2 2021 1 \N
2021-06-01 23 2 1 6 2 2021 1 \N
2021-06-02 23 3 2 6 2 2021 1 \N
2021-06-03 23 4 3 6 2 2021 1 \N
2021-06-04 23 5 4 6 2 2021 1 \N
2021-06-05 23 6 5 6 2 2021 0 \N
2021-06-06 23 7 6 6 2 2021 0 \N
2021-06-07 24 1 7 6 2 2021 1 \N
2021-06-08 24 2 8 6 2 2021 1 \N
2021-06-09 24 3 9 6 2 2021 1 \N
2021-06-10 24 4 10 6 2 2021 1 \N
2021-06-11 24 5 11 6 2 2021 1 \N
2021-06-12 24 6 12 6 2 2021 0 端午节
2021-06-13 24 7 13 6 2 2021 0 端午节
2021-06-14 25 1 14 6 2 2021 0 端午节
2021-06-15 25 2 15 6 2 2021 1 \N
2021-06-16 25 3 16 6 2 2021 1 \N
2021-06-17 25 4 17 6 2 2021 1 \N
2021-06-18 25 5 18 6 2 2021 1 \N
2021-06-19 25 6 19 6 2 2021 0 \N
2021-06-20 25 7 20 6 2 2021 0 \N
2021-06-21 26 1 21 6 2 2021 1 \N
2021-06-22 26 2 22 6 2 2021 1 \N
2021-06-23 26 3 23 6 2 2021 1 \N
2021-06-24 26 4 24 6 2 2021 1 \N
2021-06-25 26 5 25 6 2 2021 1 \N
2021-06-26 26 6 26 6 2 2021 0 \N
2021-06-27 26 7 27 6 2 2021 0 \N
2021-06-28 27 1 28 6 2 2021 1 \N
2021-06-29 27 2 29 6 2 2021 1 \N
2021-06-30 27 3 30 6 2 2021 1 \N
2021-07-01 27 4 1 7 3 2021 1 \N
2021-07-02 27 5 2 7 3 2021 1 \N
2021-07-03 27 6 3 7 3 2021 0 \N
2021-07-04 27 7 4 7 3 2021 0 \N
2021-07-05 28 1 5 7 3 2021 1 \N
2021-07-06 28 2 6 7 3 2021 1 \N
2021-07-07 28 3 7 7 3 2021 1 \N
2021-07-08 28 4 8 7 3 2021 1 \N
2021-07-09 28 5 9 7 3 2021 1 \N
2021-07-10 28 6 10 7 3 2021 0 \N
2021-07-11 28 7 11 7 3 2021 0 \N
2021-07-12 29 1 12 7 3 2021 1 \N
2021-07-13 29 2 13 7 3 2021 1 \N
2021-07-14 29 3 14 7 3 2021 1 \N
2021-07-15 29 4 15 7 3 2021 1 \N
2021-07-16 29 5 16 7 3 2021 1 \N
2021-07-17 29 6 17 7 3 2021 0 \N
2021-07-18 29 7 18 7 3 2021 0 \N
2021-07-19 30 1 19 7 3 2021 1 \N
2021-07-20 30 2 20 7 3 2021 1 \N
2021-07-21 30 3 21 7 3 2021 1 \N
2021-07-22 30 4 22 7 3 2021 1 \N
2021-07-23 30 5 23 7 3 2021 1 \N
2021-07-24 30 6 24 7 3 2021 0 \N
2021-07-25 30 7 25 7 3 2021 0 \N
2021-07-26 31 1 26 7 3 2021 1 \N
2021-07-27 31 2 27 7 3 2021 1 \N
2021-07-28 31 3 28 7 3 2021 1 \N
2021-07-29 31 4 29 7 3 2021 1 \N
2021-07-30 31 5 30 7 3 2021 1 \N
2021-07-31 31 6 31 7 3 2021 0 \N
2021-08-01 31 7 1 8 3 2021 0 \N
2021-08-02 32 1 2 8 3 2021 1 \N
2021-08-03 32 2 3 8 3 2021 1 \N
2021-08-04 32 3 4 8 3 2021 1 \N
2021-08-05 32 4 5 8 3 2021 1 \N
2021-08-06 32 5 6 8 3 2021 1 \N
2021-08-07 32 6 7 8 3 2021 0 \N
2021-08-08 32 7 8 8 3 2021 0 \N
2021-08-09 33 1 9 8 3 2021 1 \N
2021-08-10 33 2 10 8 3 2021 1 \N
2021-08-11 33 3 11 8 3 2021 1 \N
2021-08-12 33 4 12 8 3 2021 1 \N
2021-08-13 33 5 13 8 3 2021 1 \N
2021-08-14 33 6 14 8 3 2021 0 \N
2021-08-15 33 7 15 8 3 2021 0 \N
2021-08-16 34 1 16 8 3 2021 1 \N
2021-08-17 34 2 17 8 3 2021 1 \N
2021-08-18 34 3 18 8 3 2021 1 \N
2021-08-19 34 4 19 8 3 2021 1 \N
2021-08-20 34 5 20 8 3 2021 1 \N
2021-08-21 34 6 21 8 3 2021 0 \N
2021-08-22 34 7 22 8 3 2021 0 \N
2021-08-23 35 1 23 8 3 2021 1 \N
2021-08-24 35 2 24 8 3 2021 1 \N
2021-08-25 35 3 25 8 3 2021 1 \N
2021-08-26 35 4 26 8 3 2021 1 \N
2021-08-27 35 5 27 8 3 2021 1 \N
2021-08-28 35 6 28 8 3 2021 0 \N
2021-08-29 35 7 29 8 3 2021 0 \N
2021-08-30 36 1 30 8 3 2021 1 \N
2021-08-31 36 2 31 8 3 2021 1 \N
2021-09-01 36 3 1 9 3 2021 1 \N
2021-09-02 36 4 2 9 3 2021 1 \N
2021-09-03 36 5 3 9 3 2021 1 \N
2021-09-04 36 6 4 9 3 2021 0 \N
2021-09-05 36 7 5 9 3 2021 0 \N
2021-09-06 37 1 6 9 3 2021 1 \N
2021-09-07 37 2 7 9 3 2021 1 \N
2021-09-08 37 3 8 9 3 2021 1 \N
2021-09-09 37 4 9 9 3 2021 1 \N
2021-09-10 37 5 10 9 3 2021 1 \N
2021-09-11 37 6 11 9 3 2021 0 \N
2021-09-12 37 7 12 9 3 2021 0 \N
2021-09-13 38 1 13 9 3 2021 1 \N
2021-09-14 38 2 14 9 3 2021 1 \N
2021-09-15 38 3 15 9 3 2021 1 \N
2021-09-16 38 4 16 9 3 2021 1 \N
2021-09-17 38 5 17 9 3 2021 1 \N
2021-09-18 38 6 18 9 3 2021 1 \N
2021-09-19 38 7 19 9 3 2021 0 中秋节
2021-09-20 39 1 20 9 3 2021 0 中秋节
2021-09-21 39 2 21 9 3 2021 0 中秋节
2021-09-22 39 3 22 9 3 2021 1 \N
2021-09-23 39 4 23 9 3 2021 1 \N
2021-09-24 39 5 24 9 3 2021 1 \N
2021-09-25 39 6 25 9 3 2021 0 \N
2021-09-26 39 7 26 9 3 2021 1 \N
2021-09-27 40 1 27 9 3 2021 1 \N
2021-09-28 40 2 28 9 3 2021 1 \N
2021-09-29 40 3 29 9 3 2021 1 \N
2021-09-30 40 4 30 9 3 2021 1 \N
2021-10-01 40 5 1 10 4 2021 0 国庆节
2021-10-02 40 6 2 10 4 2021 0 国庆节
2021-10-03 40 7 3 10 4 2021 0 国庆节
2021-10-04 41 1 4 10 4 2021 0 国庆节
2021-10-05 41 2 5 10 4 2021 0 国庆节
2021-10-06 41 3 6 10 4 2021 0 国庆节
2021-10-07 41 4 7 10 4 2021 0 国庆节
2021-10-08 41 5 8 10 4 2021 1 \N
2021-10-09 41 6 9 10 4 2021 1 \N
2021-10-10 41 7 10 10 4 2021 0 \N
2021-10-11 42 1 11 10 4 2021 1 \N
2021-10-12 42 2 12 10 4 2021 1 \N
2021-10-13 42 3 13 10 4 2021 1 \N
2021-10-14 42 4 14 10 4 2021 1 \N
2021-10-15 42 5 15 10 4 2021 1 \N
2021-10-16 42 6 16 10 4 2021 0 \N
2021-10-17 42 7 17 10 4 2021 0 \N
2021-10-18 43 1 18 10 4 2021 1 \N
2021-10-19 43 2 19 10 4 2021 1 \N
2021-10-20 43 3 20 10 4 2021 1 \N
2021-10-21 43 4 21 10 4 2021 1 \N
2021-10-22 43 5 22 10 4 2021 1 \N
2021-10-23 43 6 23 10 4 2021 0 \N
2021-10-24 43 7 24 10 4 2021 0 \N
2021-10-25 44 1 25 10 4 2021 1 \N
2021-10-26 44 2 26 10 4 2021 1 \N
2021-10-27 44 3 27 10 4 2021 1 \N
2021-10-28 44 4 28 10 4 2021 1 \N
2021-10-29 44 5 29 10 4 2021 1 \N
2021-10-30 44 6 30 10 4 2021 0 \N
2021-10-31 44 7 31 10 4 2021 0 \N
2021-11-01 45 1 1 11 4 2021 1 \N
2021-11-02 45 2 2 11 4 2021 1 \N
2021-11-03 45 3 3 11 4 2021 1 \N
2021-11-04 45 4 4 11 4 2021 1 \N
2021-11-05 45 5 5 11 4 2021 1 \N
2021-11-06 45 6 6 11 4 2021 0 \N
2021-11-07 45 7 7 11 4 2021 0 \N
2021-11-08 46 1 8 11 4 2021 1 \N
2021-11-09 46 2 9 11 4 2021 1 \N
2021-11-10 46 3 10 11 4 2021 1 \N
2021-11-11 46 4 11 11 4 2021 1 \N
2021-11-12 46 5 12 11 4 2021 1 \N
2021-11-13 46 6 13 11 4 2021 0 \N
2021-11-14 46 7 14 11 4 2021 0 \N
2021-11-15 47 1 15 11 4 2021 1 \N
2021-11-16 47 2 16 11 4 2021 1 \N
2021-11-17 47 3 17 11 4 2021 1 \N
2021-11-18 47 4 18 11 4 2021 1 \N
2021-11-19 47 5 19 11 4 2021 1 \N
2021-11-20 47 6 20 11 4 2021 0 \N
2021-11-21 47 7 21 11 4 2021 0 \N
2021-11-22 48 1 22 11 4 2021 1 \N
2021-11-23 48 2 23 11 4 2021 1 \N
2021-11-24 48 3 24 11 4 2021 1 \N
2021-11-25 48 4 25 11 4 2021 1 \N
2021-11-26 48 5 26 11 4 2021 1 \N
2021-11-27 48 6 27 11 4 2021 0 \N
2021-11-28 48 7 28 11 4 2021 0 \N
2021-11-29 49 1 29 11 4 2021 1 \N
2021-11-30 49 2 30 11 4 2021 1 \N
2021-12-01 49 3 1 12 4 2021 1 \N
2021-12-02 49 4 2 12 4 2021 1 \N
2021-12-03 49 5 3 12 4 2021 1 \N
2021-12-04 49 6 4 12 4 2021 0 \N
2021-12-05 49 7 5 12 4 2021 0 \N
2021-12-06 50 1 6 12 4 2021 1 \N
2021-12-07 50 2 7 12 4 2021 1 \N
2021-12-08 50 3 8 12 4 2021 1 \N
2021-12-09 50 4 9 12 4 2021 1 \N
2021-12-10 50 5 10 12 4 2021 1 \N
2021-12-11 50 6 11 12 4 2021 0 \N
2021-12-12 50 7 12 12 4 2021 0 \N
2021-12-13 51 1 13 12 4 2021 1 \N
2021-12-14 51 2 14 12 4 2021 1 \N
2021-12-15 51 3 15 12 4 2021 1 \N
2021-12-16 51 4 16 12 4 2021 1 \N
2021-12-17 51 5 17 12 4 2021 1 \N
2021-12-18 51 6 18 12 4 2021 0 \N
2021-12-19 51 7 19 12 4 2021 0 \N
2021-12-20 52 1 20 12 4 2021 1 \N
2021-12-21 52 2 21 12 4 2021 1 \N
2021-12-22 52 3 22 12 4 2021 1 \N
2021-12-23 52 4 23 12 4 2021 1 \N
2021-12-24 52 5 24 12 4 2021 1 \N
2021-12-25 52 6 25 12 4 2021 0 \N
2021-12-26 52 7 26 12 4 2021 0 \N
2021-12-27 53 1 27 12 4 2021 1 \N
2021-12-28 53 2 28 12 4 2021 1 \N
2021-12-29 53 3 29 12 4 2021 1 \N
2021-12-30 53 4 30 12 4 2021 1 \N
2021-12-31 53 5 31 12 4 2021 1 \N
2022-01-01 1 6 1 1 1 2022 0 元旦
2022-01-02 1 7 2 1 1 2022 0 元旦
2022-01-03 2 1 3 1 1 2022 0 元旦
2022-01-04 2 2 4 1 1 2022 1 \N
2022-01-05 2 3 5 1 1 2022 1 \N
2022-01-06 2 4 6 1 1 2022 1 \N
2022-01-07 2 5 7 1 1 2022 1 \N
2022-01-08 2 6 8 1 1 2022 0 \N
2022-01-09 2 7 9 1 1 2022 0 \N
2022-01-10 3 1 10 1 1 2022 1 \N
2022-01-11 3 2 11 1 1 2022 1 \N
2022-01-12 3 3 12 1 1 2022 1 \N
2022-01-13 3 4 13 1 1 2022 1 \N
2022-01-14 3 5 14 1 1 2022 1 \N
2022-01-15 3 6 15 1 1 2022 0 \N
2022-01-16 3 7 16 1 1 2022 0 \N
2022-01-17 4 1 17 1 1 2022 1 \N
2022-01-18 4 2 18 1 1 2022 1 \N
2022-01-19 4 3 19 1 1 2022 1 \N
2022-01-20 4 4 20 1 1 2022 1 \N
2022-01-21 4 5 21 1 1 2022 1 \N
2022-01-22 4 6 22 1 1 2022 0 \N
2022-01-23 4 7 23 1 1 2022 0 \N
2022-01-24 5 1 24 1 1 2022 1 \N
2022-01-25 5 2 25 1 1 2022 1 \N
2022-01-26 5 3 26 1 1 2022 1 \N
2022-01-27 5 4 27 1 1 2022 1 \N
2022-01-28 5 5 28 1 1 2022 1 \N
2022-01-29 5 6 29 1 1 2022 1 \N
2022-01-30 5 7 30 1 1 2022 1 \N
2022-01-31 6 1 31 1 1 2022 0 春节
2022-02-01 6 2 1 2 1 2022 0 春节
2022-02-02 6 3 2 2 1 2022 0 春节
2022-02-03 6 4 3 2 1 2022 0 春节
2022-02-04 6 5 4 2 1 2022 0 春节
2022-02-05 6 6 5 2 1 2022 0 春节
2022-02-06 6 7 6 2 1 2022 0 春节
2022-02-07 7 1 7 2 1 2022 1 \N
2022-02-08 7 2 8 2 1 2022 1 \N
2022-02-09 7 3 9 2 1 2022 1 \N
2022-02-10 7 4 10 2 1 2022 1 \N
2022-02-11 7 5 11 2 1 2022 1 \N
2022-02-12 7 6 12 2 1 2022 0 \N
2022-02-13 7 7 13 2 1 2022 0 \N
2022-02-14 8 1 14 2 1 2022 1 \N
2022-02-15 8 2 15 2 1 2022 1 \N
2022-02-16 8 3 16 2 1 2022 1 \N
2022-02-17 8 4 17 2 1 2022 1 \N
2022-02-18 8 5 18 2 1 2022 1 \N
2022-02-19 8 6 19 2 1 2022 0 \N
2022-02-20 8 7 20 2 1 2022 0 \N
2022-02-21 9 1 21 2 1 2022 1 \N
2022-02-22 9 2 22 2 1 2022 1 \N
2022-02-23 9 3 23 2 1 2022 1 \N
2022-02-24 9 4 24 2 1 2022 1 \N
2022-02-25 9 5 25 2 1 2022 1 \N
2022-02-26 9 6 26 2 1 2022 0 \N
2022-02-27 9 7 27 2 1 2022 0 \N
2022-02-28 10 1 28 2 1 2022 1 \N
2022-03-01 10 2 1 3 1 2022 1 \N
2022-03-02 10 3 2 3 1 2022 1 \N
2022-03-03 10 4 3 3 1 2022 1 \N
2022-03-04 10 5 4 3 1 2022 1 \N
2022-03-05 10 6 5 3 1 2022 0 \N
2022-03-06 10 7 6 3 1 2022 0 \N
2022-03-07 11 1 7 3 1 2022 1 \N
2022-03-08 11 2 8 3 1 2022 1 \N
2022-03-09 11 3 9 3 1 2022 1 \N
2022-03-10 11 4 10 3 1 2022 1 \N
2022-03-11 11 5 11 3 1 2022 1 \N
2022-03-12 11 6 12 3 1 2022 0 \N
2022-03-13 11 7 13 3 1 2022 0 \N
2022-03-14 12 1 14 3 1 2022 1 \N
2022-03-15 12 2 15 3 1 2022 1 \N
2022-03-16 12 3 16 3 1 2022 1 \N
2022-03-17 12 4 17 3 1 2022 1 \N
2022-03-18 12 5 18 3 1 2022 1 \N
2022-03-19 12 6 19 3 1 2022 0 \N
2022-03-20 12 7 20 3 1 2022 0 \N
2022-03-21 13 1 21 3 1 2022 1 \N
2022-03-22 13 2 22 3 1 2022 1 \N
2022-03-23 13 3 23 3 1 2022 1 \N
2022-03-24 13 4 24 3 1 2022 1 \N
2022-03-25 13 5 25 3 1 2022 1 \N
2022-03-26 13 6 26 3 1 2022 0 \N
2022-03-27 13 7 27 3 1 2022 0 \N
2022-03-28 14 1 28 3 1 2022 1 \N
2022-03-29 14 2 29 3 1 2022 1 \N
2022-03-30 14 3 30 3 1 2022 1 \N
2022-03-31 14 4 31 3 1 2022 1 \N
2022-04-01 14 5 1 4 2 2022 1 \N
2022-04-02 14 6 2 4 2 2022 1 \N
2022-04-03 14 7 3 4 2 2022 0 清明节
2022-04-04 15 1 4 4 2 2022 0 清明节
2022-04-05 15 2 5 4 2 2022 0 清明节
2022-04-06 15 3 6 4 2 2022 1 \N
2022-04-07 15 4 7 4 2 2022 1 \N
2022-04-08 15 5 8 4 2 2022 1 \N
2022-04-09 15 6 9 4 2 2022 0 \N
2022-04-10 15 7 10 4 2 2022 0 \N
2022-04-11 16 1 11 4 2 2022 1 \N
2022-04-12 16 2 12 4 2 2022 1 \N
2022-04-13 16 3 13 4 2 2022 1 \N
2022-04-14 16 4 14 4 2 2022 1 \N
2022-04-15 16 5 15 4 2 2022 1 \N
2022-04-16 16 6 16 4 2 2022 0 \N
2022-04-17 16 7 17 4 2 2022 0 \N
2022-04-18 17 1 18 4 2 2022 1 \N
2022-04-19 17 2 19 4 2 2022 1 \N
2022-04-20 17 3 20 4 2 2022 1 \N
2022-04-21 17 4 21 4 2 2022 1 \N
2022-04-22 17 5 22 4 2 2022 1 \N
2022-04-23 17 6 23 4 2 2022 0 \N
2022-04-24 17 7 24 4 2 2022 1 \N
2022-04-25 18 1 25 4 2 2022 1 \N
2022-04-26 18 2 26 4 2 2022 1 \N
2022-04-27 18 3 27 4 2 2022 1 \N
2022-04-28 18 4 28 4 2 2022 1 \N
2022-04-29 18 5 29 4 2 2022 1 \N
2022-04-30 18 6 30 4 2 2022 0 劳动节
2022-05-01 18 7 1 5 2 2022 0 劳动节
2022-05-02 19 1 2 5 2 2022 0 劳动节
2022-05-03 19 2 3 5 2 2022 0 劳动节
2022-05-04 19 3 4 5 2 2022 0 劳动节
2022-05-05 19 4 5 5 2 2022 1 \N
2022-05-06 19 5 6 5 2 2022 1 \N
2022-05-07 19 6 7 5 2 2022 1 \N
2022-05-08 19 7 8 5 2 2022 0 \N
2022-05-09 20 1 9 5 2 2022 1 \N
2022-05-10 20 2 10 5 2 2022 1 \N
2022-05-11 20 3 11 5 2 2022 1 \N
2022-05-12 20 4 12 5 2 2022 1 \N
2022-05-13 20 5 13 5 2 2022 1 \N
2022-05-14 20 6 14 5 2 2022 0 \N
2022-05-15 20 7 15 5 2 2022 0 \N
2022-05-16 21 1 16 5 2 2022 1 \N
2022-05-17 21 2 17 5 2 2022 1 \N
2022-05-18 21 3 18 5 2 2022 1 \N
2022-05-19 21 4 19 5 2 2022 1 \N
2022-05-20 21 5 20 5 2 2022 1 \N
2022-05-21 21 6 21 5 2 2022 0 \N
2022-05-22 21 7 22 5 2 2022 0 \N
2022-05-23 22 1 23 5 2 2022 1 \N
2022-05-24 22 2 24 5 2 2022 1 \N
2022-05-25 22 3 25 5 2 2022 1 \N
2022-05-26 22 4 26 5 2 2022 1 \N
2022-05-27 22 5 27 5 2 2022 1 \N
2022-05-28 22 6 28 5 2 2022 0 \N
2022-05-29 22 7 29 5 2 2022 0 \N
2022-05-30 23 1 30 5 2 2022 1 \N
2022-05-31 23 2 31 5 2 2022 1 \N
2022-06-01 23 3 1 6 2 2022 1 \N
2022-06-02 23 4 2 6 2 2022 1 \N
2022-06-03 23 5 3 6 2 2022 0 端午节
2022-06-04 23 6 4 6 2 2022 0 端午节
2022-06-05 23 7 5 6 2 2022 0 端午节
2022-06-06 24 1 6 6 2 2022 1 \N
2022-06-07 24 2 7 6 2 2022 1 \N
2022-06-08 24 3 8 6 2 2022 1 \N
2022-06-09 24 4 9 6 2 2022 1 \N
2022-06-10 24 5 10 6 2 2022 1 \N
2022-06-11 24 6 11 6 2 2022 0 \N
2022-06-12 24 7 12 6 2 2022 0 \N
2022-06-13 25 1 13 6 2 2022 1 \N
2022-06-14 25 2 14 6 2 2022 1 \N
2022-06-15 25 3 15 6 2 2022 1 \N
2022-06-16 25 4 16 6 2 2022 1 \N
2022-06-17 25 5 17 6 2 2022 1 \N
2022-06-18 25 6 18 6 2 2022 0 \N
2022-06-19 25 7 19 6 2 2022 0 \N
2022-06-20 26 1 20 6 2 2022 1 \N
2022-06-21 26 2 21 6 2 2022 1 \N
2022-06-22 26 3 22 6 2 2022 1 \N
2022-06-23 26 4 23 6 2 2022 1 \N
2022-06-24 26 5 24 6 2 2022 1 \N
2022-06-25 26 6 25 6 2 2022 0 \N
2022-06-26 26 7 26 6 2 2022 0 \N
2022-06-27 27 1 27 6 2 2022 1 \N
2022-06-28 27 2 28 6 2 2022 1 \N
2022-06-29 27 3 29 6 2 2022 1 \N
2022-06-30 27 4 30 6 2 2022 1 \N
2022-07-01 27 5 1 7 3 2022 1 \N
2022-07-02 27 6 2 7 3 2022 0 \N
2022-07-03 27 7 3 7 3 2022 0 \N
2022-07-04 28 1 4 7 3 2022 1 \N
2022-07-05 28 2 5 7 3 2022 1 \N
2022-07-06 28 3 6 7 3 2022 1 \N
2022-07-07 28 4 7 7 3 2022 1 \N
2022-07-08 28 5 8 7 3 2022 1 \N
2022-07-09 28 6 9 7 3 2022 0 \N
2022-07-10 28 7 10 7 3 2022 0 \N
2022-07-11 29 1 11 7 3 2022 1 \N
2022-07-12 29 2 12 7 3 2022 1 \N
2022-07-13 29 3 13 7 3 2022 1 \N
2022-07-14 29 4 14 7 3 2022 1 \N
2022-07-15 29 5 15 7 3 2022 1 \N
2022-07-16 29 6 16 7 3 2022 0 \N
2022-07-17 29 7 17 7 3 2022 0 \N
2022-07-18 30 1 18 7 3 2022 1 \N
2022-07-19 30 2 19 7 3 2022 1 \N
2022-07-20 30 3 20 7 3 2022 1 \N
2022-07-21 30 4 21 7 3 2022 1 \N
2022-07-22 30 5 22 7 3 2022 1 \N
2022-07-23 30 6 23 7 3 2022 0 \N
2022-07-24 30 7 24 7 3 2022 0 \N
2022-07-25 31 1 25 7 3 2022 1 \N
2022-07-26 31 2 26 7 3 2022 1 \N
2022-07-27 31 3 27 7 3 2022 1 \N
2022-07-28 31 4 28 7 3 2022 1 \N
2022-07-29 31 5 29 7 3 2022 1 \N
2022-07-30 31 6 30 7 3 2022 0 \N
2022-07-31 31 7 31 7 3 2022 0 \N
2022-08-01 32 1 1 8 3 2022 1 \N
2022-08-02 32 2 2 8 3 2022 1 \N
2022-08-03 32 3 3 8 3 2022 1 \N
2022-08-04 32 4 4 8 3 2022 1 \N
2022-08-05 32 5 5 8 3 2022 1 \N
2022-08-06 32 6 6 8 3 2022 0 \N
2022-08-07 32 7 7 8 3 2022 0 \N
2022-08-08 33 1 8 8 3 2022 1 \N
2022-08-09 33 2 9 8 3 2022 1 \N
2022-08-10 33 3 10 8 3 2022 1 \N
2022-08-11 33 4 11 8 3 2022 1 \N
2022-08-12 33 5 12 8 3 2022 1 \N
2022-08-13 33 6 13 8 3 2022 0 \N
2022-08-14 33 7 14 8 3 2022 0 \N
2022-08-15 34 1 15 8 3 2022 1 \N
2022-08-16 34 2 16 8 3 2022 1 \N
2022-08-17 34 3 17 8 3 2022 1 \N
2022-08-18 34 4 18 8 3 2022 1 \N
2022-08-19 34 5 19 8 3 2022 1 \N
2022-08-20 34 6 20 8 3 2022 0 \N
2022-08-21 34 7 21 8 3 2022 0 \N
2022-08-22 35 1 22 8 3 2022 1 \N
2022-08-23 35 2 23 8 3 2022 1 \N
2022-08-24 35 3 24 8 3 2022 1 \N
2022-08-25 35 4 25 8 3 2022 1 \N
2022-08-26 35 5 26 8 3 2022 1 \N
2022-08-27 35 6 27 8 3 2022 0 \N
2022-08-28 35 7 28 8 3 2022 0 \N
2022-08-29 36 1 29 8 3 2022 1 \N
2022-08-30 36 2 30 8 3 2022 1 \N
2022-08-31 36 3 31 8 3 2022 1 \N
2022-09-01 36 4 1 9 3 2022 1 \N
2022-09-02 36 5 2 9 3 2022 1 \N
2022-09-03 36 6 3 9 3 2022 0 \N
2022-09-04 36 7 4 9 3 2022 0 \N
2022-09-05 37 1 5 9 3 2022 1 \N
2022-09-06 37 2 6 9 3 2022 1 \N
2022-09-07 37 3 7 9 3 2022 1 \N
2022-09-08 37 4 8 9 3 2022 1 \N
2022-09-09 37 5 9 9 3 2022 1 \N
2022-09-10 37 6 10 9 3 2022 0 中秋节
2022-09-11 37 7 11 9 3 2022 0 中秋节
2022-09-12 38 1 12 9 3 2022 0 中秋节
2022-09-13 38 2 13 9 3 2022 1 \N
2022-09-14 38 3 14 9 3 2022 1 \N
2022-09-15 38 4 15 9 3 2022 1 \N
2022-09-16 38 5 16 9 3 2022 1 \N
2022-09-17 38 6 17 9 3 2022 0 \N
2022-09-18 38 7 18 9 3 2022 0 \N
2022-09-19 39 1 19 9 3 2022 1 \N
2022-09-20 39 2 20 9 3 2022 1 \N
2022-09-21 39 3 21 9 3 2022 1 \N
2022-09-22 39 4 22 9 3 2022 1 \N
2022-09-23 39 5 23 9 3 2022 1 \N
2022-09-24 39 6 24 9 3 2022 0 \N
2022-09-25 39 7 25 9 3 2022 0 \N
2022-09-26 40 1 26 9 3 2022 1 \N
2022-09-27 40 2 27 9 3 2022 1 \N
2022-09-28 40 3 28 9 3 2022 1 \N
2022-09-29 40 4 29 9 3 2022 1 \N
2022-09-30 40 5 30 9 3 2022 1 \N
2022-10-01 40 6 1 10 4 2022 0 国庆节
2022-10-02 40 7 2 10 4 2022 0 国庆节
2022-10-03 41 1 3 10 4 2022 0 国庆节
2022-10-04 41 2 4 10 4 2022 0 国庆节
2022-10-05 41 3 5 10 4 2022 0 国庆节
2022-10-06 41 4 6 10 4 2022 0 国庆节
2022-10-07 41 5 7 10 4 2022 0 国庆节
2022-10-08 41 6 8 10 4 2022 1 \N
2022-10-09 41 7 9 10 4 2022 1 \N
2022-10-10 42 1 10 10 4 2022 1 \N
2022-10-11 42 2 11 10 4 2022 1 \N
2022-10-12 42 3 12 10 4 2022 1 \N
2022-10-13 42 4 13 10 4 2022 1 \N
2022-10-14 42 5 14 10 4 2022 1 \N
2022-10-15 42 6 15 10 4 2022 0 \N
2022-10-16 42 7 16 10 4 2022 0 \N
2022-10-17 43 1 17 10 4 2022 1 \N
2022-10-18 43 2 18 10 4 2022 1 \N
2022-10-19 43 3 19 10 4 2022 1 \N
2022-10-20 43 4 20 10 4 2022 1 \N
2022-10-21 43 5 21 10 4 2022 1 \N
2022-10-22 43 6 22 10 4 2022 0 \N
2022-10-23 43 7 23 10 4 2022 0 \N
2022-10-24 44 1 24 10 4 2022 1 \N
2022-10-25 44 2 25 10 4 2022 1 \N
2022-10-26 44 3 26 10 4 2022 1 \N
2022-10-27 44 4 27 10 4 2022 1 \N
2022-10-28 44 5 28 10 4 2022 1 \N
2022-10-29 44 6 29 10 4 2022 0 \N
2022-10-30 44 7 30 10 4 2022 0 \N
2022-10-31 45 1 31 10 4 2022 1 \N
2022-11-01 45 2 1 11 4 2022 1 \N
2022-11-02 45 3 2 11 4 2022 1 \N
2022-11-03 45 4 3 11 4 2022 1 \N
2022-11-04 45 5 4 11 4 2022 1 \N
2022-11-05 45 6 5 11 4 2022 0 \N
2022-11-06 45 7 6 11 4 2022 0 \N
2022-11-07 46 1 7 11 4 2022 1 \N
2022-11-08 46 2 8 11 4 2022 1 \N
2022-11-09 46 3 9 11 4 2022 1 \N
2022-11-10 46 4 10 11 4 2022 1 \N
2022-11-11 46 5 11 11 4 2022 1 \N
2022-11-12 46 6 12 11 4 2022 0 \N
2022-11-13 46 7 13 11 4 2022 0 \N
2022-11-14 47 1 14 11 4 2022 1 \N
2022-11-15 47 2 15 11 4 2022 1 \N
2022-11-16 47 3 16 11 4 2022 1 \N
2022-11-17 47 4 17 11 4 2022 1 \N
2022-11-18 47 5 18 11 4 2022 1 \N
2022-11-19 47 6 19 11 4 2022 0 \N
2022-11-20 47 7 20 11 4 2022 0 \N
2022-11-21 48 1 21 11 4 2022 1 \N
2022-11-22 48 2 22 11 4 2022 1 \N
2022-11-23 48 3 23 11 4 2022 1 \N
2022-11-24 48 4 24 11 4 2022 1 \N
2022-11-25 48 5 25 11 4 2022 1 \N
2022-11-26 48 6 26 11 4 2022 0 \N
2022-11-27 48 7 27 11 4 2022 0 \N
2022-11-28 49 1 28 11 4 2022 1 \N
2022-11-29 49 2 29 11 4 2022 1 \N
2022-11-30 49 3 30 11 4 2022 1 \N
2022-12-01 49 4 1 12 4 2022 1 \N
2022-12-02 49 5 2 12 4 2022 1 \N
2022-12-03 49 6 3 12 4 2022 0 \N
2022-12-04 49 7 4 12 4 2022 0 \N
2022-12-05 50 1 5 12 4 2022 1 \N
2022-12-06 50 2 6 12 4 2022 1 \N
2022-12-07 50 3 7 12 4 2022 1 \N
2022-12-08 50 4 8 12 4 2022 1 \N
2022-12-09 50 5 9 12 4 2022 1 \N
2022-12-10 50 6 10 12 4 2022 0 \N
2022-12-11 50 7 11 12 4 2022 0 \N
2022-12-12 51 1 12 12 4 2022 1 \N
2022-12-13 51 2 13 12 4 2022 1 \N
2022-12-14 51 3 14 12 4 2022 1 \N
2022-12-15 51 4 15 12 4 2022 1 \N
2022-12-16 51 5 16 12 4 2022 1 \N
2022-12-17 51 6 17 12 4 2022 0 \N
2022-12-18 51 7 18 12 4 2022 0 \N
2022-12-19 52 1 19 12 4 2022 1 \N
2022-12-20 52 2 20 12 4 2022 1 \N
2022-12-21 52 3 21 12 4 2022 1 \N
2022-12-22 52 4 22 12 4 2022 1 \N
2022-12-23 52 5 23 12 4 2022 1 \N
2022-12-24 52 6 24 12 4 2022 0 \N
2022-12-25 52 7 25 12 4 2022 0 \N
2022-12-26 53 1 26 12 4 2022 1 \N
2022-12-27 53 2 27 12 4 2022 1 \N
2022-12-28 53 3 28 12 4 2022 1 \N
2022-12-29 53 4 29 12 4 2022 1 \N
2022-12-30 53 5 30 12 4 2022 1 \N
2022-12-31 53 6 31 12 4 2022 0 \N