drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Krystal (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-671) Select against hbase table with filter against row_key fails
Date Sat, 10 May 2014 22:13:45 GMT
Krystal created DRILL-671:
-----------------------------

             Summary: 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
    Affects Versions: 1.0.0-milestone-1
            Reporter: Krystal


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)

Mime
View raw message