You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Tim Armstrong (JIRA)" <ji...@apache.org> on 2018/10/30 18:27:01 UTC
[jira] [Updated] (IMPALA-283) select count(*) produces inconsistent
results for hbase tables because of NULL projection
[ https://issues.apache.org/jira/browse/IMPALA-283?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tim Armstrong updated IMPALA-283:
---------------------------------
Summary: select count(*) produces inconsistent results for hbase tables because of NULL projection (was: select count(*) produces inconsistent results for hbase tables)
> select count(*) produces inconsistent results for hbase tables because of NULL projection
> -----------------------------------------------------------------------------------------
>
> Key: IMPALA-283
> URL: https://issues.apache.org/jira/browse/IMPALA-283
> Project: IMPALA
> Issue Type: Bug
> Components: Frontend
> Affects Versions: Impala 0.7
> Reporter: Ishaan Joshi
> Priority: Minor
>
> When count(*) is clubbed with another aggregation columns, it produces different results.
> {code}
> [localhost:21000] > select count(*) from functional.alltypesagg;
> Query: select count(*) from functional.alltypesagg
> Query finished, fetching results ...
> +----------+
> | count(*) |
> +----------+
> | 10000 |
> +----------+
> Returned 1 row(s) in 0.26s
> [localhost:21000] > select count(*) from functional_hbase.alltypesagg;
> Query: select count(*) from functional_hbase.alltypesagg
> Query finished, fetching results ...
> +----------+
> | count(*) |
> +----------+
> | 10000 |
> +----------+
> Returned 1 row(s) in 0.65s
> [localhost:21000] > select count(*), count(int_col) from functional_hbase.alltypesagg;
> Query: select count(*), count(int_col) from functional_hbase.alltypesagg
> Query finished, fetching results ...
> +----------+----------------+
> | count(*) | count(int_col) |
> +----------+----------------+
> | 9990 | 9990 |
> +----------+----------------+
> Returned 1 row(s) in 0.91s
> [localhost:21000] > select count(*), count(int_col) from functional.alltypesagg;
> Query: select count(*), count(int_col) from functional.alltypesagg
> Query finished, fetching results ...
> +----------+----------------+
> | count(*) | count(int_col) |
> +----------+----------------+
> | 10000 | 9990 |
> +----------+----------------+
> Returned 1 row(s) in 0.26s
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org