[DRILL-671] Select against hbase table with filter against row_key fails

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.1.0-m1
• Fix Version/s: 0.4.0
• Component/s: Storage - HBase
• Assignee: Aditya Kishore
• Reporter: Krystal
• Created: 08/May/14 21:36
• Updated: 31/Jul/14 06:32
• Resolved: 20/May/14 16:02

Description

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

---------------------------------------------------------------+