You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Krystal (JIRA)" <ji...@apache.org> on 2014/06/03 19:22:01 UTC
[jira] [Commented] (DRILL-896) Queries against split hbase tables
return data from 1 region server
[ https://issues.apache.org/jira/browse/DRILL-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14016893#comment-14016893 ]
Krystal commented on DRILL-896:
-------------------------------
Physical Plan:
<?xml version="1.0" encoding="utf-8"?><LoggingEvent xmlns="http://lilith.sf.net/schema/logging/14" logger="org.apache.drill.exec.planner.PhysicalPlanReader" level="DEBUG" threadName="BitServer-1" threadId="15" threadGroup="main" threadGroupId="959095803" timeStamp="2014-06-03T09:50:24.893-07:00" timeStampMillis="1401814224893"><Message>Attempting to read {}</Message><Arguments><Argument>{
"pop" : "single-sender",
"@id" : 0,
"receiver-major-fragment" : 0,
"child" : {
"pop" : "project",
"@id" : 1,
"exprs" : [ {
"ref" : "`voter_id`",
"expr" : "cast( (`row_key` ) as INT )"
} ],
"child" : {
"pop" : "selection-vector-remover",
"@id" : 2,
"child" : {
"pop" : "filter",
"@id" : 3,
"child" : {
"pop" : "hbase-region-scan",
"@id" : 4,
"storage" : {
"type" : "hbase",
"config" : {
"hbase.zookeeper.quorum" : "10.10.100.56",
"hbase.zookeeper.property.clientPort" : "5181"
}
},
"regionScanSpecList" : [ {
"tableName" : "voter",
"regionServer" : "qa-node57.qa.lab",
"startRow" : "Ng==",
"stopRow" : "Nw==",
"serializedFilter" : null
} ],
"columns" : [ "`row_key`", "`twocf`" ],
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000
},
"expr" : "booleanAnd(greater_than_or_equal_to(`twocf`.`age`, 75) , less_than_or_equal_to(`twocf`.`age`, 80) ) ",
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000
},
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000
},
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000
},
"destination" : "ChBxYS1ub2RlNTYucWEubGFiEKLyARij8gEgpPIB",
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000
}
> Queries against split hbase tables return data from 1 region server
> -------------------------------------------------------------------
>
> Key: DRILL-896
> URL: https://issues.apache.org/jira/browse/DRILL-896
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - HBase
> Reporter: Krystal
>
> git.commit.id.abbrev=8490d74
> git.build.time=02.06.2014 @ 10\:11\:56 PDT
> Selects against split hbase tables seem to return data only from 1 hbase region. I have 2 hbase region servers and 1 hbase master.
> 0: jdbc:drill:schema=hbase> select cast(row_key as integer) voter_id from voter where twocf['age'] between 75 and 80;
> +------------+
> | voter_id |
> +------------+
> | 201 |
> | 217 |
> | 248 |
> | 289 |
> | 293 |
> | 296 |
> | 402 |
> | 434 |
> | 472 |
> | 473 |
> | 490 |
> | 606 |
> | 608 |
> It returned the above data and just hangs. There should be 39 rows returned instead of 13. The keys (voter_id) returned belongs to 1 region server.
--
This message was sent by Atlassian JIRA
(v6.2#6252)