1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071 |
- /** 能源差值数据 15min 历史数据 */
- create table ods_energy_15_min_history
- (
- building string comment '大楼id',
- func_id string comment '仪表功能号',
- meter string comment '仪表号',
- data_time string comment '数据采集时间',
- data_value decimal(30, 15) comment '采集值',
- `dt` string comment '采集日期'
- ) COMMENT '能源原始数据 15min 历史数据'
- ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001'
- STORED AS TEXTFILE
- LOCATION
- 'hdfs://sagaCluster:8020/warehouse/saga_dw/ods/ods_energy_15_min_history'
- TBLPROPERTIES (
- 'orc.compress'='lzo');
- /** 能源差值数据 5min 历史数据 */
- create table ods_energy_5_min_history
- (
- building string comment '大楼id',
- func_id string comment '仪表功能号',
- meter string comment '仪表号',
- data_time string comment '数据采集时间',
- data_value decimal(30, 15) comment '采集值',
- `dt` string comment '采集日期'
- ) COMMENT '能源原始数据 5min 历史数据'
- ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001'
- STORED AS TEXTFILE
- LOCATION
- 'hdfs://sagaCluster:8020/warehouse/saga_dw/ods/ods_energy_5_min_history'
- TBLPROPERTIES (
- 'orc.compress'='lzo');
- /** 能源 fjd 数据 15min 历史数据 */
- create table ods_energy_15_min_fjd_history
- (
- building string comment '大楼id',
- func_id string comment '仪表功能号',
- meter string comment '仪表号',
- data_time string comment '数据采集时间',
- data_value decimal(30, 15) comment '采集值',
- `dt` string comment '采集日期'
- ) COMMENT '能源 fjd 数据 15min 历史数据'
- ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001'
- STORED AS TEXTFILE
- LOCATION
- 'hdfs://sagaCluster:8020/warehouse/saga_dw/ods/ods_energy_15_min_fjd_history'
- TBLPROPERTIES (
- 'orc.compress'='lzo');
- /** 能源 fjd 数据 5min 历史数据 */
- create table ods_energy_5_min_fjd_history
- (
- building string comment '大楼id',
- func_id string comment '仪表功能号',
- meter string comment '仪表号',
- data_time string comment '数据采集时间',
- data_value decimal(30, 15) comment '采集值',
- `dt` string comment '采集日期'
- ) COMMENT '能源 fjd 数据 5min 历史数据'
- ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001'
- STORED AS TEXTFILE
- LOCATION
- 'hdfs://sagaCluster:8020/warehouse/saga_dw/ods/ods_energy_5_min_fjd_history'
- TBLPROPERTIES (
- 'orc.compress'='lzo');
|