Thanks, I made user mapr owned table. Here is what I got from drill sqlline.
0: jdbc:drill:zk=10.180.98.244:5181,10.180.98> describe lecxe; +-------------+------------+-------------+ | COLUMN_NAME | DATA_TYPE | IS_NULLABLE | +-------------+------------+-------------+ | row_key | ANY | NO | | dependent_vars | (VARCHAR(1), ANY) MAP | NO | | independent_vars | (VARCHAR(1), ANY) MAP | NO | +-------------+------------+-------------+ 3 rows selected (0.197 seconds) 0: jdbc:drill:zk=10.180.98.244:5181,10.180.98> select * from lecxe limit 2; Query failed: Failure while setting up Foreman. Error: exception while executing query: Failure while executing query. (state=,code=0) I guess, this is due to hbase version 0.98??? Sungwook On Thu, Dec 11, 2014 at 1:26 PM, Kunal Khatua <[email protected]> wrote: > If Drill doesnt show any results, and no errors... it's a permissions > issue. By design, MapRDB will not reveal anything about the requested table > due to security reasons. > > You can try running the following on all of the tables you wish to query. > maprcli table cf edit -path ${tblPath} -cfname ${colFam} -readperm > "u:mapr|u:root" > > Expand this to allow other users that you wish to grant read permissions > to. > > ~ Kunal > > > On 12/11/2014 1:16:50 PM, Abhishek Girish <[email protected]> > wrote: > What about the permissions for the table on MFS? > > On Thu, Dec 11, 2014 at 1:11 PM, Sungwook Yoon wrote: > > > drillbit is running on mapr > > > > Sungwook > > > > > > On Thu, Dec 11, 2014 at 1:01 PM, Steven Phillips > > wrote: > > > > > Can you check what user drillbit is running as? > > > > > > On Thursday, December 11, 2014, Sungwook Yoon > > wrote: > > > > > > > Here is how I invoke sqlline, > > > > > > > > sqlline -u jdbc:drill:zk=10.180.98.244:5181,10.180.98.245:5181, > > > > 10.180.98.246:5181 > > > > > > > > Sungwook > > > > > > > > > > > > On Thu, Dec 11, 2014 at 12:50 PM, Aditya > > > > > wrote: > > > > > > > > > On Thu, Dec 11, 2014 at 12:47 PM, Sungwook Yoon > > > > > > > > > > wrote: > > > > > > > > > > > The sqlline is executed under root too. > > > > > > > > > > > > > > > What about DrillBits? Or are you running Drill in embedded mode? > > > > > > > > > > > > > > > > > > -- > > > Steven Phillips > > > Software Engineer > > > > > > mapr.com > > > > > >
