hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Moustafa Aboul Atta (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-7213) COUNT(*) returns the count of the last inserted rows through INSERT INTO TABLE
Date Wed, 11 Jun 2014 12:49:01 GMT
Moustafa Aboul Atta created HIVE-7213:
-----------------------------------------

             Summary: COUNT(*) returns the count of the last inserted rows through INSERT
INTO TABLE
                 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
            Priority: Minor


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.




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

Mime
View raw message