I'll take a look and get back to you soon. On Tue, Aug 2, 2016 at 1:03 AM, Stack <[email protected]> wrote:
> I was trying 1.7.0 against the tip of the hbase 1.1 branch and I was > getting: > > 0: jdbc:drill:zk=local> select * from students; > Error: SYSTEM ERROR: IllegalAccessError: tried to access method > com.google.common.base.Stopwatch.<init>()V from class > org.apache.hadoop.hbase.zookeeper.MetaTableLocator > > > [Error Id: 02a432c3-90cb-4892-8e31-cdfb0fc3e463 on localhost:31010] > (state=,code=0) > > Seems like a clash between hbase and drill guava versions (hbase has old > 0.12.1). > > I then tried compiling drill with a later hbase (1.2) where the Stopwatch > is purged but I kept getting the below issue when trying to run where drill > could 'see' all the hbase tables but when I try to query, they don't exist > (See below). > > Pointers appreciated, > Thanks, > St.Ack > > > kalashnikov:apache-drill-1.8.0-SNAPSHOT stack$ ./bin/drill-embedded > Java HotSpot(TM) 64-Bit Server VM warning: ignoring option > MaxPermSize=512M; support was removed in 8.0 > Aug 02, 2016 12:57:30 AM org.glassfish.jersey.server.ApplicationHandler > initialize > INFO: Initiating Jersey application, version Jersey: 2.8 2014-04-29 > 01:25:26... > apache drill 1.8.0-SNAPSHOT > "a drill is a terrible thing to waste" > 0: jdbc:drill:zk=local> !tables > > +------------+---------------------+-------------+-------------+----------+-----------+-------------+------------+----------------------------+-----------------+ > | TABLE_CAT | TABLE_SCHEM | TABLE_NAME | TABLE_TYPE | REMARKS | > TYPE_CAT | TYPE_SCHEM | TYPE_NAME | SELF_REFERENCING_COL_NAME | > REF_GENERATION | > > +------------+---------------------+-------------+-------------+----------+-----------+-------------+------------+----------------------------+-----------------+ > | DRILL | INFORMATION_SCHEMA | CATALOGS | TABLE | | > | | | | > | > | DRILL | INFORMATION_SCHEMA | COLUMNS | TABLE | | > | | | | > | > | DRILL | INFORMATION_SCHEMA | SCHEMATA | TABLE | | > | | | | > | > | DRILL | INFORMATION_SCHEMA | TABLES | TABLE | | > | | | | > | > | DRILL | INFORMATION_SCHEMA | VIEWS | TABLE | | > | | | | > | > | DRILL | hbase | clicks | TABLE | | > | | | | > | > | DRILL | hbase | students | TABLE | | > | | | | > | > | DRILL | sys | boot | TABLE | | > | | | | > | > | DRILL | sys | drillbits | TABLE | | > | | | | > | > | DRILL | sys | memory | TABLE | | > | | | | > | > | DRILL | sys | options | TABLE | | > | | | | > | > | DRILL | sys | threads | TABLE | | > | | | | > | > | DRILL | sys | version | TABLE | | > | | | | > | > > +------------+---------------------+-------------+-------------+----------+-----------+-------------+------------+----------------------------+-----------------+ > 0: jdbc:drill:zk=local> select * from students; > Aug 02, 2016 12:57:54 AM > org.apache.calcite.sql.validate.SqlValidatorException <init> > SEVERE: org.apache.calcite.sql.validate.SqlValidatorException: Table > 'students' not found > Aug 02, 2016 12:57:54 AM org.apache.calcite.runtime.CalciteException <init> > SEVERE: org.apache.calcite.runtime.CalciteContextException: From line 1, > column 15 to line 1, column 22: Table 'students' not found > Error: VALIDATION ERROR: From line 1, column 15 to line 1, column 22: Table > 'students' not found > > SQL Query null > > [Error Id: a21db8a5-7e8d-4868-9e9d-252bc55d010b on localhost:31010] > (state=,code=0) >
