[
https://issues.apache.org/jira/browse/DRILL-4221?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Nikolay updated DRILL-4221:
---------------------------
Environment: Linux 14.04, JAVA 1.7.0_67, hbase 1.1.1 (was: Linux 14.04,
JAVA 1.7.0_67)
> Not correct number of rows when rows are fetched from hbase storage
> -------------------------------------------------------------------
>
> Key: DRILL-4221
> URL: https://issues.apache.org/jira/browse/DRILL-4221
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - HBase
> Affects Versions: 1.3.0
> Environment: Linux 14.04, JAVA 1.7.0_67, hbase 1.1.1
> Reporter: Nikolay
> Priority: Critical
>
> Drill returns incorrect result when rows more than *832*.
> When I run query
> bq. SELECT count(row_key) FROM hbase.`ns:events`
> query returns *833*(correct result).
> If I run query
> bq. SELECT count(\*) FROM hbase.`ns:events`
> query returns *832*(incorrect result).
> Also incorrect results can be for other type of queries. For example if I run
> query
> bq. SELECT count(`ns:events`.CF.column1) FROM hbase.`ns:events`
> query returns *833*(correct results) but if I run query with *WHERE CLAUSE*:
> bq. SELECT count(`ns:events`.CF.column1) FROM hbase.`ns:events` where row_key
> BETWEEN 'a' AND 'f'
> In this case the query returns incorrect result(*832*, range from '*a*' to
> '*f*' is enough for getting all rows, all keys starts with 'b')
> Also strange behavior is continued, when I added another 1000 rows, then the
> query that returns an incorrect number of rows (*832*), began to return the
> result *831*
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
