Which version of Drill are you using? I see that you have non default setting for "zookeeper.znode.parent", i.e. "/hbase-unsecure". Is this also set in the "hbase-site.xml" which you HBase shell is including?
On Mon, Oct 27, 2014 at 1:33 PM, Perler, Eric <[email protected]> wrote: > thanks u for ur response... > > yes.. here is my config > > > { > "type": "hbase", > "config": { > "hbase.zookeeper.quorum": "node1.rcggs.com,node4.rcggs.com", > "hbase.zookeeper.property.clientPort": "2181", > "zookeeper.znode.parent": "/hbase-unsecure" > }, > "enabled": true > } > > i can see the hbase schema > > 0: jdbc:drill:zk=local> show schemas; > +-------------+ > | SCHEMA_NAME | > +-------------+ > | hive.default | > | dfs.default | > | dfs.root | > | dfs.tmp | > | sys | > | hdfs.default | > | hdfs.root | > | cp.default | > | hbase | > | INFORMATION_SCHEMA | > > but i dont see the table... > > 0: jdbc:drill:zk=local> show tables in hbase; > +--------------+------------+ > | TABLE_SCHEMA | TABLE_NAME | > +--------------+------------+ > +--------------+------------+ > No rows selected (0.281 second > > i can see the table in hbase shell... > > hbase(main):001:0> scan 'test' > > ROW COLUMN+CELL > row-key column=cf:number107, > timestamp=1414338024796, value=10 > row-key column=cf:number272, > timestamp=1414338024916, value=10 > row-key column=cf:number336, > timestamp=1414338024699, value=10 > row-key column=cf:number337, > timestamp=1414338024673, value=10 > row-key column=cf:number354, > timestamp=1414338024892, value=10 > row-key column=cf:number384, > timestamp=1414338024942, value=10 > row-key column=cf:number536, > timestamp=1414338024870, value=10 > row-key column=cf:number549, > timestamp=1414338024756, value=10 > row-key column=cf:number565, > timestamp=1414338024826, value=10 > row-key column=cf:number906, > timestamp=1414338024722, value=10 > 1 row(s) in 0.1340 seconds > > > Thanks for helping !!!!! > > ________________________________________ > From: Steven Phillips <[email protected]> > Sent: Monday, October 27, 2014 3:26 PM > To: [email protected] > Subject: Re: drill cant see hbase table > > Do you have the hbase storage plugin configured and enabled in Drill? > > You can configure hbase storage by going to the Drill UI, <hostname>:8047 > and clicking on the Storage tab. > > On Mon, Oct 27, 2014 at 6:45 AM, Perler, Eric <[email protected]> > wrote: > > > > > hello > > > > i followed the instructions here to install drill and connect to hbase... > > > > https://cwiki.apache.org/confluence/display/DRILL/Querying+HBase > > > > I can see the table in hbase shell... > > > > hbase(main):001:0> scan 'students' > > SLF4J: Class path contains multiple SLF4J bindings. > > SLF4J: Found binding in > > > [jar:file:/usr/lib/hadoop/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class] > > SLF4J: Found binding in > > > [jar:file:/usr/lib/zookeeper/lib/slf4j-log4j12-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] > > SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an > > explanation. > > ROW COLUMN+CELL > > student1 column=account:name, > > timestamp=1414348080466, value=Alice > > student1 column=address:state, > > timestamp=1414348080606, value=CA > > > > > > but when i try to query it from drill, it cant find the table... > > > > 0: jdbc:drill:zk=local> select * from hbase.`students`; > > Oct 26, 2014 1:54:17 PM org.eigenbase.sql.validate.SqlValidatorException > > <init> > > SEVERE: org.eigenbase.sql.validate.SqlValidatorException: Table > 'students' > > not found > > Oct 26, 2014 1:54:17 PM org.eigenbase.util.EigenbaseException <init> > > SEVERE: org.eigenbase.util.EigenbaseContextException: From line 1, column > > 15 to line 1, column 22: Table 'students' not found > > Query failed: Failure while parsing sql. Table 'students' not found > > [73ba9672-fea9-48ac-9eba-505cac5820f0] > > Error: exception while executing query: Failure while trying to get next > > result batch. (state=,code=0) > > > > > > This is the command Im using to connect... > > > > bin/sqlline -u jdbc:drill:zk=local -n admin -p admin > > > > Any help is appreciated.. > > > > Thx !!? > > > > > > > -- > Steven Phillips > Software Engineer > > mapr.com >
