[
https://issues.apache.org/jira/browse/DRILL-671?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14000475#comment-14000475
]
Krystal commented on DRILL-671:
-------------------------------
git.commit.id.abbrev=70fab8c
Scanning any hbase tables using row_key in the where clause gives a
NullPointerException error. For example:
select * from student where row_key=650;
Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while
running query.[error_id: "97153bda-fdf3-4c3c-be8d-89dfbc2bd550"
endpoint {
address: "qa-node56.qa.lab"
user_port: 31010
control_port: 31011
data_port: 31012
}
error_type: 0
message: "Failure while setting up Foreman. < AssertionError:[ Internal error:
Error while applying rule HBasePushFilterIntoScan, args
[rel#8053:FilterPrel.PHYSICAL.SINGLETON([]).[](child=rel#8044:Subset#3.PHYSICAL.ANY([]).[],condition==(CAST($1):INTEGER,
650)), rel#8047:ScanPrel.PHYSICAL.SINGLETON([]).[](groupscan=HBaseGroupScan
[HBaseScanSpec=HBaseScanSpec [tableName=student, startRow=null, stopRow=null,
filter=null], columns=null])] ] < NullPointerException"
Stack trace:
java.lang.NullPointerException
org.apache.drill.exec.store.hbase.HBaseFilterBuilder.mergeScanSpecs(HBaseFilterBuilder.java:138)
~[drill-storage-hbase-1.0.0-m2-incubating-SNAPSHOT.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.store.hbase.HBaseFilterBuilder.parseTree(HBaseFilterBuilder.java:56)
~[drill-storage-hbase-1.0.0-m2-incubating-SNAPSHOT.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.store.hbase.HBasePushFilterIntoScan.onMatch(HBasePushFilterIntoScan.java:60)
~[drill-storage-hbase-1.0.0-m2-incubating-SNAPSHOT.jar:1.0.0-m2-incubating-SNAPSHOT]
org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:221)
~[optiq-core-0.7-20140513.013236-5.jar:na]
org.eigenbase.relopt.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:653)
~[optiq-core-0.7-20140513.013236-5.jar:na]
net.hydromatic.optiq.prepare.PlannerImpl.transform(PlannerImpl.java:271)
~[optiq-core-0.7-20140513.013236-5.jar:na]
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToPrel(DefaultSqlHandler.java:119)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:89)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:134)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:338)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:186)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
[na:1.7.0_45]
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
[na:1.7.0_45]
java.lang.Thread.run(Thread.java:744) [na:1.7.0_45]
> Select against hbase table with filter against row_key fails
> ------------------------------------------------------------
>
> Key: DRILL-671
> URL: https://issues.apache.org/jira/browse/DRILL-671
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - HBase
> Affects Versions: 1.0.0-milestone-1
> Reporter: Krystal
> Assignee: Aditya Kishore
>
> Properties of hbase table:
> hbase(main):005:0> describe 'voter'
> DESCRIPTION ENABLED
>
> 'voter', {NAME => 'fourcf', DATA_BLOCK_ENCODING => 'NONE', BLOOMFIL true
>
> TER => 'NONE', REPLICATION_SCOPE => '0', VERSIONS => '3', MIN_VERSI
>
> ONS => '0', TTL => '2147483647', KEEP_DELETED_CELLS => 'false', BLO
>
> CKSIZE => '65536', IN_MEMORY => 'false', ENCODE_ON_DISK => 'true',
>
> BLOCKCACHE => 'true'}, {NAME => 'onecf', DATA_BLOCK_ENCODING => 'NO
>
> NE', BLOOMFILTER => 'NONE', REPLICATION_SCOPE => '0', VERSIONS => '
>
> 3', MIN_VERSIONS => '0', TTL => '2147483647', KEEP_DELETED_CELLS =>
>
> 'false', BLOCKSIZE => '65536', IN_MEMORY => 'false', ENCODE_ON_DIS
>
> K => 'true', BLOCKCACHE => 'true'}, {NAME => 'threecf', DATA_BLOCK_
>
> ENCODING => 'NONE', BLOOMFILTER => 'NONE', REPLICATION_SCOPE => '0'
>
> , VERSIONS => '3', MIN_VERSIONS => '0', TTL => '2147483647', KEEP_D
>
> ELETED_CELLS => 'false', BLOCKSIZE => '65536', IN_MEMORY => 'false'
>
> , ENCODE_ON_DISK => 'true', BLOCKCACHE => 'true'}, {NAME => 'twocf'
>
> , DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'NONE', REPLICATION
>
> _SCOPE => '0', VERSIONS => '3', MIN_VERSIONS => '0', TTL => '214748
>
> 3647', KEEP_DELETED_CELLS => 'false', BLOCKSIZE => '65536', IN_MEMO
>
> RY => 'false', ENCODE_ON_DISK => 'true', BLOCKCACHE => 'true'}
>
> With the latest build, the following query fails:
> select * from voter where row_key=100;
> Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while
> running query.[error_id: "0dbabd27-b027-4afe-b509-efa2974a0ff2"
> endpoint {
> address: "qa-node64.qa.lab"
> user_port: 31010
> control_port: 31011
> data_port: 31012
> }
> error_type: 0
> message: "Failure while running fragment. < IllegalStateException:[ Failure
> while closing accountor. Expected private and shared pools to be set to
> initial values. However, one or more were not. Stats
> are\n\tzone\tinit\tallocated\tdelta \n\tprivate\t1000000\t999778\t222
> \n\tshared\t9999000000\t9999000000\t0. ]"
> ]
> Error: exception while executing query (state=,code=0)
> This could be due to the "voter" table expands multiple regions. I have a
> table that exists in only 1 region and the same select went fine:
> select * from student where row_key=100;
> +------------+-------------+------------+------------+------------+------------+
> | row_key | create_date | studentnum | name | gpa | age
> |
> +------------+-------------+------------+------------+------------+------------+
> | [B@31174ed3 | [B@713817d2 | [B@19a41610 | [B@63a48196 | [B@4537d1f5 |
> [B@53b94f53 |
> +------------+-------------+------------+------------+------------+------------+
--
This message was sent by Atlassian JIRA
(v6.2#6252)
