Re: Quering Hbase with TimeRange, Version, Timestamp,etc

["Ulf Andreasson @ MapR" <ua...@maprtech.com>]

I am also curious regarding this, is it possible ?


--------
Ulf Andreasson | Ericsson Global Alliance Solution Engineer, MapR.com | +46
72 700 2295


On Fri, Mar 4, 2016 at 2:51 AM, Abhishek <ab...@gmail.com> wrote:

> In hbase shell we could use command like
>
> get '/test/service','rk1',{COLUMN=>'fm1:col1',TIMERAGE=>[0,TS1]}
>
> to query the record versions fall into [0,TS1) where TS1 is the timestamp
> for each version (the ts1 we set when running the 'put' command).
>
> Is there a way to do the same SQL query in Drill to query such data?
>
> e.g. select * from hbase.`/test/table` as t where t.fm1.TIMESTAMP =
> 1442XXXXX
>
> or is there a native search mod in Drill that I could use hbase query
> instead of sql?
>
> --
> If you tell the truth, you don't have to remember anything..
> Regards,
> Abhishek Agrawal
>

Re: Quering Hbase with TimeRange, Version, Timestamp,etc

[Sudheesh Katkam <sk...@maprtech.com>]

AFAIK, not possible currently.

Thank you,
Sudheesh

> On Sep 14, 2016, at 5:15 AM, Ulf Andreasson @ MapR <ua...@maprtech.com> wrote:
> 
> I am also curious regarding this, is it possible ?
> 
> 
> --------
> Ulf Andreasson | Ericsson Global Alliance Solution Engineer, MapR.com | +46
> 72 700 2295
> 
> 
> On Fri, Mar 4, 2016 at 2:51 AM, Abhishek <ab...@gmail.com> wrote:
> 
>> In hbase shell we could use command like
>> 
>> get '/test/service','rk1',{COLUMN=>'fm1:col1',TIMERAGE=>[0,TS1]}
>> 
>> to query the record versions fall into [0,TS1) where TS1 is the timestamp
>> for each version (the ts1 we set when running the 'put' command).
>> 
>> Is there a way to do the same SQL query in Drill to query such data?
>> 
>> e.g. select * from hbase.`/test/table` as t where t.fm1.TIMESTAMP =
>> 1442XXXXX
>> 
>> or is there a native search mod in Drill that I could use hbase query
>> instead of sql?
>> 
>> --
>> If you tell the truth, you don't have to remember anything..
>> Regards,
>> Abhishek Agrawal
>>