hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashutosh Chauhan (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-7213) COUNT(*) returns out-dated count value after TRUNCATE or INSERT INTO
Date Fri, 11 Jul 2014 21:58:06 GMT

     [ https://issues.apache.org/jira/browse/HIVE-7213?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Ashutosh Chauhan updated HIVE-7213:
-----------------------------------

    Attachment: HIVE-7213.patch

Attached patch fixes truncate table scenario. Insert into is on different code path, for which
I will open separate jira and submit patch their.

> COUNT(*) returns out-dated count value after TRUNCATE or INSERT INTO
> --------------------------------------------------------------------
>
>                 Key: HIVE-7213
>                 URL: https://issues.apache.org/jira/browse/HIVE-7213
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor, Statistics
>    Affects Versions: 0.13.0
>         Environment: HDP 2.1
> Windows Server 2012 64-bit
>            Reporter: Moustafa Aboul Atta
>         Attachments: HIVE-7213.patch
>
>
> Running a query to count number of rows in a table through
> {{SELECT COUNT( * ) FROM t}}
> always returns the last number of rows added through the following statement:
> {{INSERT INTO TABLE t SELECT r FROM t2}}
> However, running
> {{SELECT * FROM t}}
> returns the expected results i.e. the old and newly added rows.
> Also running 
> {{TRUNCATE TABLE t;}}
> returns the original count of rows in the table, however running 
> {{SELECT * FROM t;}}
> returns nothing as expected



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message