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
