2022年-数仓-【时间维度表】-年、周、节假日_数仓指标如何算出日期是周几

新年了，送你一份新年礼物，做数仓的都需要，哈哈！！！

建表语句

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