hadoop - nested Rowkey in Hbase tables -


i have weather data base 4 tables : province,city,station, instantharvestinfo,dailyharvestinfo , relation between tables parent-child: (province,city): r(1,m) (city,station):r(1,m) (statin,istantharvestinfo):r(1,m) (station,dailyharvestinfo):r(1,m) want put of them in 1 bigtable in hbase , echa 1 create column family..but dont know how define row key...i think need nested row key in each step split of rowkey related comuln family , give me information of same cf..but how cant define it? please me

there.

i guess going save huge amount of istantharvestinfo , dailyharvestinfo each station.

since there parent-child relationship in data model, think

design schema as:

------------------------------------------------------------------------- **row-key**:              province + city + station + timestamp  --------+---------------------+------------------------------------------ family  | qualifier           |          value --------+---------------------+------------------------------------------         | istantharvestinfo   |        "value of istantinfo"    f    +---------------------+------------------------------------------          | dailyharvestinfo    |        "value of dailyinfo" --------+---------------------+------------------------------------------ 

note there 1 family, because should make #family small possible.


Comments

Popular posts from this blog

assembly - 8086 TASM: Illegal Indexing Mode -

Java, LWJGL, OpenGL 1.1, decoding BufferedImage to Bytebuffer and binding to OpenGL across classes -

javascript - addthis share facebook and google+ url -