Ah, I see that 2.1 release from HW included HBase version 0.96.x. Drill currently support only HBase 0.94.x. There is JIRA[1] open to support HBase 0.96 and newer.
1. https://issues.apache.org/jira/browse/DRILL-1552 On Mon, Oct 27, 2014 at 5:13 PM, Perler, Eric <[email protected]> wrote: > yes.. it is from hbase-site.xml... its the default znode for hortonworks > 2.1.. if i dont set that property.. i get this error... > > ERROR o.a.h.h.c.HConnectionManager$HConnectionImplementation - Check the > value configured in 'zookeeper.znode.parent'. There could be a mismatch > with the one configured in the master. > > Im using drill-jdbc-all-0.5.0-incubating > > ________________________________________ > From: Aditya <[email protected]> > Sent: Monday, October 27, 2014 7:04 PM > To: drill > Subject: Re: drill cant see hbase table > > 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 > > >
