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 >> >