drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aditya <adityakish...@gmail.com>
Subject Re: How to query from hbase where table name is in <table namespace>:<table qualifier> format
Date Wed, 04 May 2016 21:58:40 GMT
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
> <shawcs@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
> <shawcs@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
> >
> >
>
>

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