saga_dw_ods.sql 841 B

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