drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Nadeau (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-671) Select against hbase table with filter against row_key fails
Date Tue, 20 May 2014 16:02:57 GMT

    [ https://issues.apache.org/jira/browse/DRILL-671?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14003536#comment-14003536
] 

Jacques Nadeau commented on DRILL-671:
--------------------------------------

6d4dc8f

> 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
>         Attachments: DRILL-671-Select-against-hbase-table-with-filter-aga.patch
>
>
> 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