You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "jiaxin zou (JIRA)" <ji...@apache.org> on 2019/05/29 12:41:00 UTC

[jira] [Created] (HIVE-21803) The result of "insert overwrite table" is inconsistent with the original table

jiaxin zou created HIVE-21803:
---------------------------------

             Summary: The result of "insert overwrite table" is inconsistent with the original table
                 Key: HIVE-21803
                 URL: https://issues.apache.org/jira/browse/HIVE-21803
             Project: Hive
          Issue Type: Bug
    Affects Versions: 2.3.0
            Reporter: jiaxin zou
         Attachments: 企业微信截图_15591333565716.png

Hi all

I have a tableA partitioned by day/hour( insert overwrite table A partiton(day,hour) select ...from table B where day =.. and hour =...) but  count(*) of table A and B is not equal occasionally (for example, hour =12). when i rerun the job (  insert overwrite ..hour =12), the count(*) is consistent. That means the bug cannot repeat.

I find the map output records is not equal to the reducer input records

  !企业微信截图_15591333565716.png!

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)