How to query from hbase where table name is in <table namespace>:<table qualifier> format

You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@drill.apache.org by Chandrashekhar Shaw <sh...@yahoo-inc.com.INVALID> on 2016/05/04 18:01:36 UTC

How to query from hbase where table name is in :

format

Hi,
What will be the corresponding command in sql for hbase command> get 'school:students', 'student1'
Where school is namespace, students is table name, student1 is row key.

~Thanks
Chandrashekhar

Re: How to query from hbase where table name is in

formatPosted by Bradley Wright <bw...@salesforce.com>.

Does Drill 1.6 include a Cassandra plug-in? Below post indicates yes, but I
can't find any mention in the docs.

https://www.mapr.com/blog/apache-drill-architecture-ultimate-guide

If yes, links to instructions to install/configure appreciated.

Thanks.

Brad

Re: How to query from hbase where table name is in

formatPosted by Aditya <ad...@gmail.com>.

You should try the following format.

select * from hbase.`<table namespace>:<table qualifier>` limit 1;

Back-tic (`) around the whole namespace-qualifier combination is important.


On Wed, May 4, 2016 at 2:16 PM, Andries Engelbrecht <
aengelbrecht@maprtech.com> wrote:

> Missed that part.
>
> Have you tried hbase.namespace.table in Drill?
>
> --Andries
>
> > On May 4, 2016, at 2:09 PM, Chandrashekhar Shaw
> <sh...@yahoo-inc.com.INVALID> wrote:
> >
> > It does not talk anything about table with <table namespace>:<table
> qualifier> format. Apparently drill is yet to support this.
> >
> > ~
> > Chandrashekhar
> >
> >    On Wednesday, 4 May 2016 11:55 AM, Andries Engelbrecht <
> aengelbrecht@maprtech.com> wrote:
> >
> >
> > See https://drill.apache.org/docs/querying-hbase/ <
> https://drill.apache.org/docs/querying-hbase/>
> >
> > Should cover your question and some additional info that will be useful
> in querying HBase.
> >
> > --Andries
> >
> >
> >> On May 4, 2016, at 11:01 AM, Chandrashekhar Shaw
> <sh...@yahoo-inc.com.INVALID> wrote:
> >>
> >> Hi,
> >> What will be the corresponding command in sql for hbase command> get
> 'school:students', 'student1'
> >> Where school is namespace, students is table name, student1 is row key.
> >>
> >> ~Thanks
> >> Chandrashekhar
> >
> >
>
>

Re: How to query from hbase where table name is in

formatPosted by Andries Engelbrecht <ae...@maprtech.com>.

Missed that part.

Have you tried hbase.namespace.table in Drill?

--Andries

> On May 4, 2016, at 2:09 PM, Chandrashekhar Shaw <sh...@yahoo-inc.com.INVALID> wrote:
> 
> It does not talk anything about table with <table namespace>:<table qualifier> format. Apparently drill is yet to support this. 
> 
> ~
> Chandrashekhar 
> 
>    On Wednesday, 4 May 2016 11:55 AM, Andries Engelbrecht <ae...@maprtech.com> wrote:
> 
> 
> See https://drill.apache.org/docs/querying-hbase/ <https://drill.apache.org/docs/querying-hbase/>
> 
> Should cover your question and some additional info that will be useful in querying HBase.
> 
> --Andries
> 
> 
>> On May 4, 2016, at 11:01 AM, Chandrashekhar Shaw <sh...@yahoo-inc.com.INVALID> wrote:
>> 
>> Hi,
>> What will be the corresponding command in sql for hbase command> get 'school:students', 'student1'
>> Where school is namespace, students is table name, student1 is row key.
>> 
>> ~Thanks
>> Chandrashekhar
> 
>

Re: How to query from hbase where table name is in

formatPosted by Chandrashekhar Shaw <sh...@yahoo-inc.com.INVALID>.

It does not talk anything about table with <table namespace>:<table qualifier> format. Apparently drill is yet to support this. 

~
Chandrashekhar 

    On Wednesday, 4 May 2016 11:55 AM, Andries Engelbrecht <ae...@maprtech.com> wrote:
 

 See https://drill.apache.org/docs/querying-hbase/ <https://drill.apache.org/docs/querying-hbase/>

Should cover your question and some additional info that will be useful in querying HBase.

--Andries


> On May 4, 2016, at 11:01 AM, Chandrashekhar Shaw <sh...@yahoo-inc.com.INVALID> wrote:
> 
> Hi,
> What will be the corresponding command in sql for hbase command> get 'school:students', 'student1'
> Where school is namespace, students is table name, student1 is row key.
> 
> ~Thanks
> Chandrashekhar

Re: How to query from hbase where table name is in

formatPosted by Andries Engelbrecht <ae...@maprtech.com>.

See https://drill.apache.org/docs/querying-hbase/ <https://drill.apache.org/docs/querying-hbase/>

Should cover your question and some additional info that will be useful in querying HBase.

--Andries


> On May 4, 2016, at 11:01 AM, Chandrashekhar Shaw <sh...@yahoo-inc.com.INVALID> wrote:
> 
> Hi,
> What will be the corresponding command in sql for hbase command> get 'school:students', 'student1'
> Where school is namespace, students is table name, student1 is row key.
> 
> ~Thanks
> Chandrashekhar