Files
airflow/dags/db/tmp.community_summary
shenjian@fangjia.com 2666137af9 新增置信度
2023-03-31 14:27:10 +08:00

22 lines
962 B
Plaintext

CREATE TABLE tmp.community_summary
(
_id String COMMENT '小区ID',
city String COMMENT '城市',
region String COMMENT '区域',
name String COMMENT '名称',
lng Nullable(Float32) COMMENT '经度',
lat Nullable(Float32) COMMENT '纬度',
alias Array(String) COMMENT '别名',
estate_type2 String COMMENT '物业类型',
build_type String COMMENT '建筑类型',
household_count String COMMENT '户数',
block String COMMENT '板块',
estate_charge String COMMENT '物业费',
finish_building_date String COMMENT '建成年代',
m_date DateTime('Asia/Shanghai') default now() COMMENT '更新时间',
avg_price Nullable(Int32) COMMENT '均价',
total_price Nullable(Int32) COMMENT '户均总价',
price_rating Nullable(Int32) COMMENT '价格评级',
consumption_rating Nullable(Int32) COMMENT '财力评级'
) ENGINE ReplacingMergeTree(m_date)
PARTITION BY city PRIMARY KEY (city, region, name) ORDER BY (city, region, name);