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
