drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ulf Andreasson @ MapR" <uandreas...@maprtech.com>
Subject Re: Quering Hbase with TimeRange, Version, Timestamp,etc
Date Wed, 14 Sep 2016 12:15:32 GMT
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 <abhishekdtc@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
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message