drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Krystal (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-896) Queries against split hbase tables return data from 1 region server
Date Tue, 03 Jun 2014 17:22:01 GMT

    [ 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)

Mime
View raw message