I don't think trying to 'mimic' an RDBS table in HBase is a very good idea. They both are completely different from each other, both in design and usage. For example, In order to get the latest value for a given column you don't have to do anything extra. You just do a Get operation on the desired rowkey, and by default HBase always gives you the latest value.
You could probably have a composite rowkey consisting of the fields you are going to use most frequently during data retrieval. It's actually a bit difficult to suggest something substantial without proper information on your use case. [image: http://] Tariq, Mohammad about.me/mti [image: http://] <http://about.me/mti> On Wed, Jun 1, 2016 at 12:03 AM, Subhash Pophale <subhash.poph...@gmail.com> wrote: > Hi > > It would be like: > 1) What is the latest (Expired = '31-Dec-9999') value of "col2" for > "col1" in date range between "From_Date" and "To_Date"? > > > On 5/31/16, Mohammad Tariq <donta...@gmail.com> wrote: > > Hi Subhash, > > > > What would be your query pattern like? > > > > > > > > [image: http://] > > > > Tariq, Mohammad > > about.me/mti > > [image: http://] > > <http://about.me/mti> > > > > > > On Tue, May 31, 2016 at 11:48 PM, Subhash Pophale > > <subhash.poph...@gmail.com > >> wrote: > > > >> Hi All, > >> > >> I am new to Hbase database. I am planning to create rather mimic table > >> in RDBMS which is temporal table which has below columns: > >> > >> Col1 > >> Col2 > >> From_Date > >> To_Date > >> Created > >> Expired > >> > >> Primary Key is : {Col1,From_Date,Expired} > >> > >> Anyone has idea what is best Hbase design structure for such table? > >> > >> Many Thanks! > >> > >> Regards, > >> Subhash Pophale > >> > > >