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
> >
> >
>
>
|