摘要：
判断步骤 1️⃣ 看表内容 属性字段多 → 倾向维度表 指标字段多 → 倾向事实表 2️⃣ 看业务含义 描述实体 → 维度表 记录事件/交易 → 事实表 3️⃣ 看数据增长方式 历史追溯 → 维度表可拉链 新增为主 → 事实表 4️⃣ 看表粒度 每条记录唯一描述一个实体 → 维度表 每条记录唯一描述
阅读全文
posted @ 2025-12-17 15:27
ZhangZhihuiAAA
阅读(4)
推荐(0)
摘要：
CREATE TABLE user_login ( user_id int, login_date date ); INSERT INTO user_login VALUES (1, '2025-12-01'::date), (1, '2025-12-01'::date), (1, '2025-12
阅读全文
posted @ 2025-12-17 10:34
ZhangZhihuiAAA
阅读(5)
推荐(0)
摘要：
pip install apache-airflow-providers-apache-spark Got below error when ran the above command: pip._vendor.resolvelib.resolvers.ResolutionTooDeep: 2000
阅读全文
posted @ 2025-12-16 23:20
ZhangZhihuiAAA
阅读(5)
推荐(0)
摘要：
The SparkOperator in Apache Airflow is used to submit Spark applications (usually via spark-submit) from an Airflow DAG. Below is a clear, practical g
阅读全文
posted @ 2025-12-16 21:55
ZhangZhihuiAAA
阅读(4)
推荐(0)
摘要：
ZhangZhihui@ZZHPC MINGW64 /e/WeChatProjects/MySongList $ git init Initialized empty Git repository in E:/WeChatProjects/MySongList/.git/ ZhangZhihui@Z
阅读全文
posted @ 2025-12-16 19:10
ZhangZhihuiAAA
阅读(4)
推荐(0)
摘要：
from __future__ import annotations import datetime from airflow.providers.standard.operators.empty import EmptyOperator from airflow.providers.standar
阅读全文
posted @ 2025-12-16 15:58
ZhangZhihuiAAA
阅读(4)
推荐(0)
摘要：
In Airflow, what's the difference between TaskMarker and TaskSensor? In Airflow, TaskSensor and TaskMarker both relate to dependencies between DAGs, b
阅读全文
posted @ 2025-12-16 11:24
ZhangZhihuiAAA
阅读(3)
推荐(0)
摘要：
""" Example DAG demonstrating the usage of dynamic task mapping with non-TaskFlow operators. """ from __future__ import annotations from datetime impo
阅读全文
posted @ 2025-12-16 10:07
ZhangZhihuiAAA
阅读(7)
推荐(0)
摘要：
from __future__ import annotations from datetime import datetime from airflow.sdk import DAG, task with DAG( dag_id='example_dynamic_task_mapping', st
阅读全文
posted @ 2025-12-16 09:34
ZhangZhihuiAAA
阅读(4)
推荐(0)
摘要：
In shell (especially POSIX shells like sh, bash, dash, zsh), : is a builtin command called the null command. What it does Does nothing Always succeeds
阅读全文
posted @ 2025-12-15 23:29
ZhangZhihuiAAA
阅读(4)
推荐(0)
浙公网安备 33010602011771号
浙ICP备2021040463号-3
