[ https://issues.apache.org/jira/browse/HIVE-2471?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Phabricator updated HIVE-2471: ------------------------------ Attachment: HIVE-2471.D2367.3.patch kevinwilfong updated the revision "HIVE-2471 [jira] Add timestamp column with index to the partition stats table.". Reviewers: JIRA, njain Added a big comment saying it is up to the Hive administrator to drop old partition stats tables. REVISION DETAIL https://reviews.facebook.net/D2367 AFFECTED FILES ql/src/java/org/apache/hadoop/hive/ql/stats/jdbc/JDBCStatsSetupConstants.java ql/src/java/org/apache/hadoop/hive/ql/stats/jdbc/JDBCStatsUtils.java > Add timestamp column to the partition stats table. > -------------------------------------------------- > > Key: HIVE-2471 > URL: https://issues.apache.org/jira/browse/HIVE-2471 > Project: Hive > Issue Type: Improvement > Reporter: Kevin Wilfong > Assignee: Kevin Wilfong > Attachments: HIVE-2471.1.patch.txt, HIVE-2471.D2367.1.patch, > HIVE-2471.D2367.2.patch, HIVE-2471.D2367.3.patch > > > Occasionally, when entries are added to the partition stats table the program > is halted before it can delete those entries, by an exception, keyboard > interrupt, etc. These build up to the point where the table gets very large, > and it hurts the performance of the update statement which is often called. > In order to fix this, I am adding a column to the table which is > auto-populated with the current timestamp. This will allow us to create > scripts that go through periodically and clean out old entries from the table. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira