If I have followed your steps correctly, I see that you have not switched
to "hbase" schema before running query against an HBase table.
Please use one of the following methods.
0: jdbc:drill:zk=local> use hbase;
0: jdbc:drill:zk=local> select * from students;
or
0: jdbc:drill:zk=local> select * from hbase.students;
On Tue, Aug 2, 2016 at 2:46 PM, Aditya <adityakishore@gmail.com> wrote:
> I'll take a look and get back to you soon.
>
> On Tue, Aug 2, 2016 at 1:03 AM, Stack <stack@duboce.net> 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)
>>
>
>
|