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
Post a Comment