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)