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

Posted to user@drill.apache.org by Sungwook Yoon <sy...@maprtech.com> on 2014/12/11 21:31:53 UTC

maprdb hbase drill does not get any result

Hi,

In hbase shell, I can scan data in '/tables/excel'

In drill sqlline, I can describe the table,
use maprdb;
describe excel;
returns correct column family names

But, select * from excel;
does not work.

What should I look at?

Thanks,

Sungwook

Re: maprdb hbase drill does not get any result

Posted by Sungwook Yoon <sy...@maprtech.com>.

Hi Abhishek,

The content is,
{
 "type" : "hbase",
 "enabled" : true,
 "config" : {
   "hbase.table.namespace.mappings" : "*:/tables"
 }
}

And there is no error. It returns with no rows, while there are 3000 rows.

Thanks,

Sungwook






On Thu, Dec 11, 2014 at 12:40 PM, Abhishek Girish <abhishek.girish@gmail.com
> wrote:

> Hi Sungwook,
>
> When you say "select * from excel" does not work, do you mean no results
> are returned or an error is thrown? If an error is thrown, can you share
> the error message and exceptions from log (since you are using MapR, it
> most likely at /opt/mapr/drill/drill-<version>/logs/drillbit.log)?
>
> Also, can you share the contents of your maprdb plug-in?
>
> -Abhishek
>
> On Thu, Dec 11, 2014 at 12:31 PM, Sungwook Yoon <sy...@maprtech.com>
> wrote:
>
> > Hi,
> >
> > In hbase shell, I can scan data in '/tables/excel'
> >
> > In drill sqlline, I can describe the table,
> > use maprdb;
> > describe excel;
> > returns correct column family names
> >
> > But, select * from excel;
> > does not work.
> >
> > What should I look at?
> >
> > Thanks,
> >
> > Sungwook
> >
>

Re: maprdb hbase drill does not get any result

Posted by Steven Phillips <sp...@maprtech.com>.

Are you running sqlline in local mode?

If not, it doesn't matter what sqlline is run as. what is the drill but
running as?

On Thursday, December 11, 2014, Sungwook Yoon <sy...@maprtech.com> wrote:

> The hbase (maprdb) table is created at /tables/excel by root.
> The sqlline is executed under root too.
>
> Sungwook
>
>
> On Thu, Dec 11, 2014 at 12:43 PM, Steven Phillips <sphillips@maprtech.com
> <javascript:;>>
> wrote:
>
> > If it's returning 0 records, but no exception is thrown, my first guess
> > would be that there is a permission issue.
> >
> > On Thursday, December 11, 2014, Abhishek Girish <
> abhishek.girish@gmail.com <javascript:;>
> > >
> > wrote:
> >
> > > Hi Sungwook,
> > >
> > > When you say "select * from excel" does not work, do you mean no
> results
> > > are returned or an error is thrown? If an error is thrown, can you
> share
> > > the error message and exceptions from log (since you are using MapR, it
> > > most likely at /opt/mapr/drill/drill-<version>/logs/drillbit.log)?
> > >
> > > Also, can you share the contents of your maprdb plug-in?
> > >
> > > -Abhishek
> > >
> > > On Thu, Dec 11, 2014 at 12:31 PM, Sungwook Yoon <syoon@maprtech.com
> <javascript:;>
> > > <javascript:;>> wrote:
> > >
> > > > Hi,
> > > >
> > > > In hbase shell, I can scan data in '/tables/excel'
> > > >
> > > > In drill sqlline, I can describe the table,
> > > > use maprdb;
> > > > describe excel;
> > > > returns correct column family names
> > > >
> > > > But, select * from excel;
> > > > does not work.
> > > >
> > > > What should I look at?
> > > >
> > > > Thanks,
> > > >
> > > > Sungwook
> > > >
> > >
> >
> >
> > --
> >  Steven Phillips
> >  Software Engineer
> >
> >  mapr.com
> >
>


-- 
 Steven Phillips
 Software Engineer

 mapr.com

Re: maprdb hbase drill does not get any result

Posted by Abhishek Girish <ab...@abhishekgirish.info>.

Looks like you are invoking in cluster mode, but the plug-in does not
include ZooKeeper info.

Can you add it and try once?

Example:

"config": {
    "hbase.zookeeper.quorum": "10.10.103.32",
    "hbase.zookeeper.property.clientPort": "5181"
  }



On Thu, Dec 11, 2014 at 12:54 PM, Sungwook Yoon <sy...@maprtech.com> 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 <ad...@gmail.com> wrote:
>
> > On Thu, Dec 11, 2014 at 12:47 PM, Sungwook Yoon <sy...@maprtech.com>
> > wrote:
> >
> > > The sqlline is executed under root too.
> >
> >
> > What about DrillBits? Or are you running Drill in embedded mode?
> >
>

Re: maprdb hbase drill does not get any result

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

On Thu, Dec 11, 2014 at 12:57 PM, Abhishek Girish <
abhishek@abhishekgirish.info> wrote:

> Looks like you are invoking in cluster mode, but the plug-in does not
> include ZooKeeper info.
>
> Can you add it and try once?
>
> Example:
>
> "config": {
>     "hbase.zookeeper.quorum": "10.10.103.32",
>     "hbase.zookeeper.property.clientPort": "5181"
>   }
>

You do not need to configure Zookeeper settings in HBase pluginif all you
want is to connect to MapR-DB.

On Thu, Dec 11, 2014 at 1:00 PM, Carol McDonald <cm...@maprtech.com>
wrote:

>
> you can also use maprdb with the dfs plugin, for example (on the mapr
> sandbox drill .6):
>
> select * from dfs.*`/tables/customers` *limit 5;
>

This will not work if it is the permission issue as suspected by Steven
and I.

Most likely DrillBits in the cluster are running as user "mapr" while the
table is owned by "root". Adding read permission for user "mapr" at table
and CF level should resolve this.

Re: maprdb hbase drill does not get any result

Posted by Carol McDonald <cm...@maprtech.com>.

you can also use maprdb with the dfs plugin, for example (on the mapr
sandbox drill .6):

select * from dfs.*`/tables/customers` *limit 5;



On Thu, Dec 11, 2014 at 3:54 PM, Sungwook Yoon <sy...@maprtech.com> 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 <ad...@gmail.com> wrote:
>
> > On Thu, Dec 11, 2014 at 12:47 PM, Sungwook Yoon <sy...@maprtech.com>
> > wrote:
> >
> > > The sqlline is executed under root too.
> >
> >
> > What about DrillBits? Or are you running Drill in embedded mode?
> >
>

Re: maprdb hbase drill does not get any result

Posted by James Sun <js...@maprtech.com>.

Sungwook,

   What's the column family permission? You probably want to do 
something like this to give r/w permissions:

maprcli table cf edit -cfname dependent_vars -path '/tables/lecxe' 
-readperm 'u:root|u:mapr'
maprcli table cf edit -cfname dependent_vars -path '/tables/lecxe' 
-writeperm 'u:root|u:mapr'

-James


On 12/11/14, 3:24 PM, Sungwook Yoon wrote:
> I've done that already.. still I am seeing the error.
> I will double check though.
>
> Thanks,
> Sungwook
>
>
> On Thu, Dec 11, 2014 at 2:23 PM, Aditya <ad...@gmail.com> wrote:
>
>> Please add the setting "size.calculator.enabled" : false to the plugin
>> configuration.
>>
>> i.e.
>> {
>>   "type" : "hbase",
>>   "enabled" : true,
>>
>>   "size.calculator.enabled": false,
>>
>>   "config" : {
>>     "hbase.table.namespace.mappings" : "*:/tables"
>>    }
>> }
>>
>> On Thu, Dec 11, 2014 at 1:39 PM, Sungwook Yoon <sy...@maprtech.com> wrote:
>>
>>> 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 <kk...@maprtech.com>
>>> 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 <
>> abhishek@abhishekgirish.info>
>>>> 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
>>>>>>

Re: maprdb hbase drill does not get any result

Posted by Sungwook Yoon <sy...@maprtech.com>.

I've done that already.. still I am seeing the error.
I will double check though.

Thanks,
Sungwook


On Thu, Dec 11, 2014 at 2:23 PM, Aditya <ad...@gmail.com> wrote:

> Please add the setting "size.calculator.enabled" : false to the plugin
> configuration.
>
> i.e.
> {
>  "type" : "hbase",
>  "enabled" : true,
>
>  "size.calculator.enabled": false,
>
>  "config" : {
>    "hbase.table.namespace.mappings" : "*:/tables"
>   }
> }
>
> On Thu, Dec 11, 2014 at 1:39 PM, Sungwook Yoon <sy...@maprtech.com> wrote:
>
> > 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 <kk...@maprtech.com>
> > 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 <
> abhishek@abhishekgirish.info>
> > > 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
> > > > >
> > > >
> > >
> >
>

Re: maprdb hbase drill does not get any result

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

Please add the setting "size.calculator.enabled" : false to the plugin
configuration.

i.e.
{
 "type" : "hbase",
 "enabled" : true,

 "size.calculator.enabled": false,

 "config" : {
   "hbase.table.namespace.mappings" : "*:/tables"
  }
}

On Thu, Dec 11, 2014 at 1:39 PM, Sungwook Yoon <sy...@maprtech.com> wrote:

> 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 <kk...@maprtech.com>
> 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 <ab...@abhishekgirish.info>
> > 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
> > > >
> > >
> >
>

Re: maprdb hbase drill does not get any result

Posted by Sungwook Yoon <sy...@maprtech.com>.

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 <kk...@maprtech.com> 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 <ab...@abhishekgirish.info>
> 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
> > >
> >
>

Re: maprdb hbase drill does not get any result

Posted by Kunal Khatua <kk...@maprtech.com>.

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 <ab...@abhishekgirish.info> 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
> >
>

Re: maprdb hbase drill does not get any result

Posted by Abhishek Girish <ab...@abhishekgirish.info>.

What about the permissions for the table on MFS?

On Thu, Dec 11, 2014 at 1:11 PM, Sungwook Yoon <sy...@maprtech.com> wrote:

> drillbit is running on mapr
>
> Sungwook
>
>
> On Thu, Dec 11, 2014 at 1:01 PM, Steven Phillips <sp...@maprtech.com>
> wrote:
>
> > Can you check what user drillbit is running as?
> >
> > On Thursday, December 11, 2014, Sungwook Yoon <sy...@maprtech.com>
> 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 <adityakishore@gmail.com
> > > <javascript:;>> wrote:
> > >
> > > > On Thu, Dec 11, 2014 at 12:47 PM, Sungwook Yoon <syoon@maprtech.com
> > > <javascript:;>>
> > > > 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
> >
>

Re: maprdb hbase drill does not get any result

Posted by Sungwook Yoon <sy...@maprtech.com>.

drillbit is running on mapr

Sungwook


On Thu, Dec 11, 2014 at 1:01 PM, Steven Phillips <sp...@maprtech.com>
wrote:

> Can you check what user drillbit is running as?
>
> On Thursday, December 11, 2014, Sungwook Yoon <sy...@maprtech.com> 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 <adityakishore@gmail.com
> > <javascript:;>> wrote:
> >
> > > On Thu, Dec 11, 2014 at 12:47 PM, Sungwook Yoon <syoon@maprtech.com
> > <javascript:;>>
> > > 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
>

Re: maprdb hbase drill does not get any result

Posted by Steven Phillips <sp...@maprtech.com>.

Can you check what user drillbit is running as?

On Thursday, December 11, 2014, Sungwook Yoon <sy...@maprtech.com> 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 <adityakishore@gmail.com
> <javascript:;>> wrote:
>
> > On Thu, Dec 11, 2014 at 12:47 PM, Sungwook Yoon <syoon@maprtech.com
> <javascript:;>>
> > 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

Re: maprdb hbase drill does not get any result

Posted by Sungwook Yoon <sy...@maprtech.com>.

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 <ad...@gmail.com> wrote:

> On Thu, Dec 11, 2014 at 12:47 PM, Sungwook Yoon <sy...@maprtech.com>
> wrote:
>
> > The sqlline is executed under root too.
>
>
> What about DrillBits? Or are you running Drill in embedded mode?
>

Re: maprdb hbase drill does not get any result

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

On Thu, Dec 11, 2014 at 12:47 PM, Sungwook Yoon <sy...@maprtech.com> wrote:

> The sqlline is executed under root too.


What about DrillBits? Or are you running Drill in embedded mode?

Re: maprdb hbase drill does not get any result

Posted by Sungwook Yoon <sy...@maprtech.com>.

The hbase (maprdb) table is created at /tables/excel by root.
The sqlline is executed under root too.

Sungwook


On Thu, Dec 11, 2014 at 12:43 PM, Steven Phillips <sp...@maprtech.com>
wrote:

> If it's returning 0 records, but no exception is thrown, my first guess
> would be that there is a permission issue.
>
> On Thursday, December 11, 2014, Abhishek Girish <abhishek.girish@gmail.com
> >
> wrote:
>
> > Hi Sungwook,
> >
> > When you say "select * from excel" does not work, do you mean no results
> > are returned or an error is thrown? If an error is thrown, can you share
> > the error message and exceptions from log (since you are using MapR, it
> > most likely at /opt/mapr/drill/drill-<version>/logs/drillbit.log)?
> >
> > Also, can you share the contents of your maprdb plug-in?
> >
> > -Abhishek
> >
> > On Thu, Dec 11, 2014 at 12:31 PM, Sungwook Yoon <syoon@maprtech.com
> > <javascript:;>> wrote:
> >
> > > Hi,
> > >
> > > In hbase shell, I can scan data in '/tables/excel'
> > >
> > > In drill sqlline, I can describe the table,
> > > use maprdb;
> > > describe excel;
> > > returns correct column family names
> > >
> > > But, select * from excel;
> > > does not work.
> > >
> > > What should I look at?
> > >
> > > Thanks,
> > >
> > > Sungwook
> > >
> >
>
>
> --
>  Steven Phillips
>  Software Engineer
>
>  mapr.com
>

Re: maprdb hbase drill does not get any result

Posted by Steven Phillips <sp...@maprtech.com>.

If it's returning 0 records, but no exception is thrown, my first guess
would be that there is a permission issue.

On Thursday, December 11, 2014, Abhishek Girish <ab...@gmail.com>
wrote:

> Hi Sungwook,
>
> When you say "select * from excel" does not work, do you mean no results
> are returned or an error is thrown? If an error is thrown, can you share
> the error message and exceptions from log (since you are using MapR, it
> most likely at /opt/mapr/drill/drill-<version>/logs/drillbit.log)?
>
> Also, can you share the contents of your maprdb plug-in?
>
> -Abhishek
>
> On Thu, Dec 11, 2014 at 12:31 PM, Sungwook Yoon <syoon@maprtech.com
> <javascript:;>> wrote:
>
> > Hi,
> >
> > In hbase shell, I can scan data in '/tables/excel'
> >
> > In drill sqlline, I can describe the table,
> > use maprdb;
> > describe excel;
> > returns correct column family names
> >
> > But, select * from excel;
> > does not work.
> >
> > What should I look at?
> >
> > Thanks,
> >
> > Sungwook
> >
>


-- 
 Steven Phillips
 Software Engineer

 mapr.com

Re: maprdb hbase drill does not get any result

Posted by Abhishek Girish <ab...@gmail.com>.

Hi Sungwook,

When you say "select * from excel" does not work, do you mean no results
are returned or an error is thrown? If an error is thrown, can you share
the error message and exceptions from log (since you are using MapR, it
most likely at /opt/mapr/drill/drill-<version>/logs/drillbit.log)?

Also, can you share the contents of your maprdb plug-in?

-Abhishek

On Thu, Dec 11, 2014 at 12:31 PM, Sungwook Yoon <sy...@maprtech.com> wrote:

> Hi,
>
> In hbase shell, I can scan data in '/tables/excel'
>
> In drill sqlline, I can describe the table,
> use maprdb;
> describe excel;
> returns correct column family names
>
> But, select * from excel;
> does not work.
>
> What should I look at?
>
> Thanks,
>
> Sungwook
>