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
>