Hbase 与 Hive的结合 

 1 CREATE EXTERNAL TABLE  IF NOT EXISTS ia_nwp_fp_rp_cft(
 2 key String,
 3 rp_power_real String,
 4 sd_prepower String,
 5 R001_masta_layer String,
 6 R001_masta_speed String,
 7 C001_masta_layer String,
 8 C001_masta_speed String,
 9 speed_forecast String,
10 00_speed70 String,
11 05_speed70 String,
12 06_speed70 String,
13 00_direction70 String,
14 05_direction70 String,
15 06_direction70 String,
16 00_temperature70 String,
17 05_temperature70 String,
18 06_temperature70 String,
19 pf_prepower String,
20 a300_prepower String,
21 a305_prepower String
22 )
23 STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
24 WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,
25 rp:rp_power_real,
26 fp:sd_prepower,
27 cft:R001_masta_layer,
28 cft:R001_masta_speed,
29 cft:C001_masta_layer,
30 cft:C001_masta_speed,
31 nwp:speed_forecast,
32 nwp:00_speed70,
33 nwp:05_speed70,
34 nwp:06_speed70,
35 nwp:00_direction70,
36 nwp:05_direction70,
37 nwp:06_direction70,
38 nwp:00_temperature70,
39 nwp:05_temperature70,
40 nwp:06_temperature70,
41 fp:pf_prepower,
42 fp:a300_prepower,
43 fp:a305_prepower
44 ")
45 TBLPROPERTIES ("hbase.table.name" = "ia_nwp_fp_rp_cft");

 

posted @ 2017-09-19 16:13  一醉方休  阅读(263)  评论(0)  编辑  收藏  举报