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 < [email protected]> wrote: > Missed that part. > > Have you tried hbase.namespace.table in Drill? > > --Andries > > > On May 4, 2016, at 2:09 PM, Chandrashekhar Shaw > <[email protected]> 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 < > [email protected]> 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 > <[email protected]> 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 > > > > > >
