Hi,
recently, I installed drill 0.7.0 on distributed cluster and register the
hbase0.96 date source as following:
|
{
"type": "hbase",
"config": {
"hbase.zookeeper.quorum":
"172.16.19.101,172.16.19.102,172.16.19.103,172.16.19.105,172.16.19.107",
"hbase.zookeeper.property.clientPort": "2181"
},
"size.calculator.enabled": false,
"enabled": true
}
[dba@hbmaster /opt/drill/log]$hbase shell
2015-01-27 09:45:34,059 INFO [main] Configuration.deprecation:
hadoop.native.lib is deprecated. Instead, use io.native.lib.available
HBase Shell; enter 'help<RETURN>' for list of supported commands.
Type "exit<RETURN>" to leave the HBase Shell
Version 0.96.2-hadoop2, r1581096, Mon Mar 24 16:03:18 PDT 2014
hbase(main):001:0> list
TABLE
test
test_distributed
7 row(s) in 3.1320 seconds
But I get following error when query hbase table:
[root@hbmaster ~]$/opt/drill/bin/sqlline -u jdbc:drill:
Drill log directory /var/log/drill does not exist, defaulting to /opt/drill/log
sqlline version 1.1.6
0: jdbc:drill:> select * from hbase.`test`;
Query failed: Query failed: Failure validating SQL.
java.lang.IllegalArgumentException: Not a host:port pair: PBUF
hbmaster?r
r: exception while executing query: Failure while executing query.
(state=,code=0)
[dba@hbmaster /opt/drill/log]$vi drillbit.log
2015-01-27 09:40:48,172 [2b39135f-2e9f-d832-536a-82480041eb6a:foreman] ERROR
o.a.drill.exec.work.foreman.Foreman - Error
6c5aefde-09e5-4469-ad48-a7f179f1534f: Query failed: Failure validating SQL.
java.lang.IllegalArgumentException: Not a host:port pair: PBUF
^U
^Hhbmaster^P??^C^X????)^P^@
org.apache.drill.exec.planner.sql.QueryInputException: Failure validating SQL.
java.lang.IllegalArgumentException: Not a host:port pair: PBUF
^U
^Hhbmaster^P??^C^X????)^P^@
at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:147)
~[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:507)
~[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:185)
~[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
at
org.apache.drill.exec.work.WorkManager$RunnableWrapper.run(WorkManager.java:254)
[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
[na:1.7.0_65]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
[na:1.7.0_65]
at java.lang.Thread.run(Thread.java:745) [na:1.7.0_65]
Caused by: net.hydromatic.optiq.tools.ValidationException:
java.lang.IllegalArgumentException: Not a host:port pair: PBUF
^Hhbmaster^P��^C^X���ױ)^P^@
at
net.hydromatic.optiq.prepare.PlannerImpl.validate(PlannerImpl.java:178)
~[optiq-core-0.9-drill-r12.jar:na]
at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode(DefaultSqlHandler.java:145)
~[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
at
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:125)
~[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
at
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:145)
~[drill-java-exec-0.7.0-rebuffed.jar:0.7.0]
... 6 common frames omitted
Caused by: java.lang.IllegalArgumentException: Not a host:port pair: PBUF
^U
^Hhbmaster^P��^C^X���ױ)^P^@
at
org.apache.hadoop.hbase.util.Addressing.parseHostname(Addressing.java:60)
~[hbase-0.94.22-drill-r1.jar:0.94.22-drill-r1]
Does drill-0.7.0 supports hbase0.96? Could you take a look at the above issue?
thanks
petter
|
