You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Lulu Prat <lu...@gmail.com> on 2014/06/05 12:34:39 UTC

can't connect to hbase

hello

i am triing to use drill with an existing hbase table.

i try
./bin/sqlline -u jdbc:drill:schema=hbase -n admin -p admin
sqlline version 1.1.6
0: jdbc:drill:schema=hbase>SELECT SCHEMA_NAME AS Database FROM
INFORMATION_SCHEMA.SCHEMATA;
+------------+
|  Database  |
+------------+
| dfs.default |
| dfs.root   |
| dfs.tmp    |
| cp.default |
| hbase      |
| sys        |
| INFORMATION_SCHEMA |
+------------+
7 rows selected (0,828 seconds)


there is no hbase table.

i configure this way :
hbase : {
      type:"hbase",
      config : {
        "hbase.zookeeper.quorum" : "localhost",
        "hbase.zookeeper.property.clientPort" : 2181
      }
    }

i use cloudera CDH5
zookeeper is working


So wath's wrong ??

thanks for your help

Lucile

Re: can't connect to hbase

Posted by Lulu Prat <lu...@gmail.com>.
use hbase;
+------------+------------+
|     ok     |  summary   |
+------------+------------+
| true       | Default schema changed to 'hbase' |
+------------+------------+
1 row selected (0,126 seconds)



but when i do
0: jdbc:drill:schema=hbase> !tables
there is nothing




2014-06-05 13:05 GMT+02:00 Darion Yaphet <da...@gmail.com>:

> Just guess
> You select from  INFORMATION_SCHEMA.SCHEMATA
>
>
>
>
> 2014-06-05 18:54 GMT+08:00 Lulu Prat <lu...@gmail.com>:
>
> > i don't understand wath you say ?
> >
> >
> > 2014-06-05 12:43 GMT+02:00 darion <da...@gmail.com>:
> >
> > > It not the hbase's table  it seems like the drill data source
> > >
> > > darion.yaphet
> > >
> > > 于 14-6-5 下午6:34, Lulu Prat 写道:
> > >
> > >  hello
> > >>
> > >> i am triing to use drill with an existing hbase table.
> > >>
> > >> i try
> > >> ./bin/sqlline -u jdbc:drill:schema=hbase -n admin -p admin
> > >> sqlline version 1.1.6
> > >> 0: jdbc:drill:schema=hbase>SELECT SCHEMA_NAME AS Database FROM
> > >> INFORMATION_SCHEMA.SCHEMATA;
> > >> +------------+
> > >> |  Database  |
> > >> +------------+
> > >> | dfs.default |
> > >> | dfs.root   |
> > >> | dfs.tmp    |
> > >> | cp.default |
> > >> | hbase      |
> > >> | sys        |
> > >> | INFORMATION_SCHEMA |
> > >> +------------+
> > >> 7 rows selected (0,828 seconds)
> > >>
> > >>
> > >> there is no hbase table.
> > >>
> > >> i configure this way :
> > >> hbase : {
> > >>        type:"hbase",
> > >>        config : {
> > >>          "hbase.zookeeper.quorum" : "localhost",
> > >>          "hbase.zookeeper.property.clientPort" : 2181
> > >>        }
> > >>      }
> > >>
> > >> i use cloudera CDH5
> > >> zookeeper is working
> > >>
> > >>
> > >> So wath's wrong ??
> > >>
> > >> thanks for your help
> > >>
> > >> Lucile
> > >>
> > >>
> > >
> >
>
>
>
> --
>
>
> long is the way and hard  that out of Hell leads up to light
>

Re: can't connect to hbase

Posted by Darion Yaphet <da...@gmail.com>.
Just guess
You select from  INFORMATION_SCHEMA.SCHEMATA




2014-06-05 18:54 GMT+08:00 Lulu Prat <lu...@gmail.com>:

> i don't understand wath you say ?
>
>
> 2014-06-05 12:43 GMT+02:00 darion <da...@gmail.com>:
>
> > It not the hbase's table  it seems like the drill data source
> >
> > darion.yaphet
> >
> > 于 14-6-5 下午6:34, Lulu Prat 写道:
> >
> >  hello
> >>
> >> i am triing to use drill with an existing hbase table.
> >>
> >> i try
> >> ./bin/sqlline -u jdbc:drill:schema=hbase -n admin -p admin
> >> sqlline version 1.1.6
> >> 0: jdbc:drill:schema=hbase>SELECT SCHEMA_NAME AS Database FROM
> >> INFORMATION_SCHEMA.SCHEMATA;
> >> +------------+
> >> |  Database  |
> >> +------------+
> >> | dfs.default |
> >> | dfs.root   |
> >> | dfs.tmp    |
> >> | cp.default |
> >> | hbase      |
> >> | sys        |
> >> | INFORMATION_SCHEMA |
> >> +------------+
> >> 7 rows selected (0,828 seconds)
> >>
> >>
> >> there is no hbase table.
> >>
> >> i configure this way :
> >> hbase : {
> >>        type:"hbase",
> >>        config : {
> >>          "hbase.zookeeper.quorum" : "localhost",
> >>          "hbase.zookeeper.property.clientPort" : 2181
> >>        }
> >>      }
> >>
> >> i use cloudera CDH5
> >> zookeeper is working
> >>
> >>
> >> So wath's wrong ??
> >>
> >> thanks for your help
> >>
> >> Lucile
> >>
> >>
> >
>



-- 


long is the way and hard  that out of Hell leads up to light

Re: can't connect to hbase

Posted by Lulu Prat <lu...@gmail.com>.
i don't understand wath you say ?


2014-06-05 12:43 GMT+02:00 darion <da...@gmail.com>:

> It not the hbase's table  it seems like the drill data source
>
> darion.yaphet
>
> 于 14-6-5 下午6:34, Lulu Prat 写道:
>
>  hello
>>
>> i am triing to use drill with an existing hbase table.
>>
>> i try
>> ./bin/sqlline -u jdbc:drill:schema=hbase -n admin -p admin
>> sqlline version 1.1.6
>> 0: jdbc:drill:schema=hbase>SELECT SCHEMA_NAME AS Database FROM
>> INFORMATION_SCHEMA.SCHEMATA;
>> +------------+
>> |  Database  |
>> +------------+
>> | dfs.default |
>> | dfs.root   |
>> | dfs.tmp    |
>> | cp.default |
>> | hbase      |
>> | sys        |
>> | INFORMATION_SCHEMA |
>> +------------+
>> 7 rows selected (0,828 seconds)
>>
>>
>> there is no hbase table.
>>
>> i configure this way :
>> hbase : {
>>        type:"hbase",
>>        config : {
>>          "hbase.zookeeper.quorum" : "localhost",
>>          "hbase.zookeeper.property.clientPort" : 2181
>>        }
>>      }
>>
>> i use cloudera CDH5
>> zookeeper is working
>>
>>
>> So wath's wrong ??
>>
>> thanks for your help
>>
>> Lucile
>>
>>
>

Re: can't connect to hbase

Posted by darion <da...@gmail.com>.
It not the hbase's table  it seems like the drill data source

darion.yaphet

于 14-6-5 下午6:34, Lulu Prat 写道:
> hello
>
> i am triing to use drill with an existing hbase table.
>
> i try
> ./bin/sqlline -u jdbc:drill:schema=hbase -n admin -p admin
> sqlline version 1.1.6
> 0: jdbc:drill:schema=hbase>SELECT SCHEMA_NAME AS Database FROM
> INFORMATION_SCHEMA.SCHEMATA;
> +------------+
> |  Database  |
> +------------+
> | dfs.default |
> | dfs.root   |
> | dfs.tmp    |
> | cp.default |
> | hbase      |
> | sys        |
> | INFORMATION_SCHEMA |
> +------------+
> 7 rows selected (0,828 seconds)
>
>
> there is no hbase table.
>
> i configure this way :
> hbase : {
>        type:"hbase",
>        config : {
>          "hbase.zookeeper.quorum" : "localhost",
>          "hbase.zookeeper.property.clientPort" : 2181
>        }
>      }
>
> i use cloudera CDH5
> zookeeper is working
>
>
> So wath's wrong ??
>
> thanks for your help
>
> Lucile
>