123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110 |
- /** 能源原始数据 15min 差值 */
- create table ods_energy_15_min
- (
- building string,
- func_id string,
- meter string,
- data_time string,
- data_value decimal(30, 15)
- ) COMMENT '能源原始数据15min差值数据'
- PARTITIONED BY (`dt` string)
- ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001'
- STORED AS TEXTFILE
- LOCATION
- 'hdfs://sagaCluster:8020/warehouse/saga_dw/ods/ods_energy_15_min'
- TBLPROPERTIES (
- 'orc.compress'='lzo');
- /** 能源原始数据 15min 差值临时表 */
- create table ods_energy_15_min_tmp
- (
- building string,
- func_id string,
- meter string,
- data_time string,
- data_value decimal(30, 15)
- ) COMMENT '能源原始数据15min差值临时表'
- PARTITIONED BY (`dt` string)
- ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001'
- STORED AS TEXTFILE
- LOCATION
- 'hdfs://sagaCluster:8020/warehouse/saga_dw/ods/ods_energy_15_min_tmp'
- TBLPROPERTIES (
- 'orc.compress'='lzo');
- /** 能源原始数据 5min 差值 */
- create table ods_energy_5_min
- (
- building string,
- func_id string,
- meter string,
- data_time string,
- data_value decimal(30, 15)
- ) COMMENT '能源原始数据15min差值数据'
- PARTITIONED BY (`dt` string)
- ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001'
- STORED AS TEXTFILE
- LOCATION
- 'hdfs://sagaCluster:8020/warehouse/saga_dw/ods/ods_energy_5_min'
- TBLPROPERTIES (
- 'orc.compress'='lzo');
- /** 能源数据 15min */
- create table ods_energy_15_min_fjd
- (
- building string,
- func_id string,
- meter string,
- data_time string,
- data_value decimal(30, 15)
- ) COMMENT '能源原始数据 15min'
- PARTITIONED BY (`dt` string)
- ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001'
- STORED AS TEXTFILE
- LOCATION
- 'hdfs://sagaCluster:8020/warehouse/saga_dw/ods/ods_energy_15_min_fjd'
- TBLPROPERTIES (
- 'orc.compress'='lzo');
- /** 能源数据 5min */
- create table ods_energy_5_min_fjd
- (
- building string,
- func_id string,
- meter string,
- data_time string,
- data_value decimal(30, 15)
- ) COMMENT '能源原始数据 5min'
- PARTITIONED BY (`dt` string)
- ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001'
- STORED AS TEXTFILE
- LOCATION
- 'hdfs://sagaCluster:8020/warehouse/saga_dw/ods/ods_energy_5_min_fjd'
- TBLPROPERTIES (
- 'orc.compress'='lzo');
- create table saga_dw.dwd_energy_15_min_hour
- (
- building string,
- func_id string,
- branch_type string,
- branch_type_name string,
- use_range_type string,
- value_sum decimal(30, 15),
- current_hour string comment '小时',
- current_year integer comment '年份',
- year_mouth string comment '年份-月份',
- week_of_year integer comment '这一年的第几周'
- ) COMMENT '能源原始数据15min按小时维度数据'
- PARTITIONED BY (`dt` string)
- ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001'
- STORED AS TEXTFILE
- LOCATION
- 'hdfs://sagaCluster:8020/warehouse/saga_dw/dwd/dwd_energy_15_min_hour'
- TBLPROPERTIES (
- 'orc.compress' = 'lzo');
|