You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "Alexander Behm (JIRA)" <ji...@apache.org> on 2017/08/23 05:39:01 UTC
[jira] [Resolved] (IMPALA-5434) Incorrect count(*) if table
definition is has partitions defined where there are none
[ https://issues.apache.org/jira/browse/IMPALA-5434?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Alexander Behm resolved IMPALA-5434.
------------------------------------
Resolution: Not A Bug
Works as intended.
> Incorrect count(*) if table definition is has partitions defined where there are none
> -------------------------------------------------------------------------------------
>
> Key: IMPALA-5434
> URL: https://issues.apache.org/jira/browse/IMPALA-5434
> Project: IMPALA
> Issue Type: Bug
> Reporter: Peter Ebert
>
> Select count(*) on a text table that has partitions defined in the create statement, but no actual partitions (e.g. file path is /db/table/file.txt, instead of /db/table/partition=1/file.txt) you will end up getting counts that do not match hive and are a multiple of the actual count.
> Will work on re-production, but it appears to be caused by two different values for the partition column defined, so we saw 2x the correct count.
> The error can be corrected by re-defining the table without partitions of course, but would prefer an error over an incorrect query result.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)