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 !!?

Reply via email to