[
https://issues.apache.org/jira/browse/HIVE-7695?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ashutosh Chauhan updated HIVE-7695:
-----------------------------------
Attachment: tests.patch
Hi [~vasanthkumar] Sorry I missed this jira. If you are still working on this
jira. I am attaching test cases which can be used for this bug. Can you add
these tests to verify your patch. After that, once you are ready with new patch
it will be great if you can create a RB entry for it.
> hive stats issue when insert query is appending data into table
> ---------------------------------------------------------------
>
> Key: HIVE-7695
> URL: https://issues.apache.org/jira/browse/HIVE-7695
> Project: Hive
> Issue Type: Bug
> Components: Logical Optimizer, Statistics
> Affects Versions: 0.13.0, 0.13.1
> Reporter: Thejas M Nair
> Attachments: HIVE-7695-test.patch, tests.patch
>
>
> When 'insert' is used to append (not overrite), the stats don't seem to get
> updated.
> {code}
> set hive.compute.query.using.stats=true;
> set hive.stats.autogather=true;
> //insert 4 rows
> insert into table t2 select * from t1;
> select count(*) from t2;
> 4
> //insert 4 again (appending instead of overrite)
> insert into table t2 select * from t1;
> select count(*) from t2;
> 4
> select * from t2;
> 1
> 2
> 3
> 4
> 1
> 2
> 3
> 4
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
