hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Subhash Pophale <subhash.poph...@gmail.com>
Subject Re: How to designTemporal table in Hbase
Date Tue, 31 May 2016 18:33:18 GMT
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 <dontariq@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.pophale@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
>>
>

Mime
View raw message