Petter, Drill currently supports HBase 0.94 only.
I am working on DRILL-1552 <https://issues.apache.org/jira/browse/DRILL-1552> to enable support for HBase 0.98.x. On Mon, Jan 26, 2015 at 6:07 PM, 张平恩 <[email protected]> wrote: > 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 > > > > > > > |
