12345678910111213141516171819 |
- drop table if exists ods_energy_week_day;
- create table if not exists ods_energy_week_day (
- id integer,
- project_id string comment "项目id",
- `date` string comment "yyyyMMdd,日期",
- energy_cooling decimal(10, 4) comment "中央供冷系统,能耗",
- energy_heating decimal(10, 4) comment "中央供热系统,能耗",
- energy_ac_terminal decimal(10, 4) comment "空调末端系统,能耗",
- energy_light decimal(10, 4) comment "照明系统,能耗",
- energy_others decimal(10, 4) comment "其它,能耗",
- create_time string comment "创建时间",
- update_time string comment "更新时间"
- ) COMMENT '能耗系统'
- ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001'
- STORED AS ORC
- LOCATION
- 'hdfs://sagaCluster:8020/warehouse/saga_dw/ods/ods_energy_week_day'
- TBLPROPERTIES (
- 'orc.compress'='lzo');
|