[ https://issues.apache.org/jira/browse/HIVE-2335?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13078497#comment-13078497 ]
jirapos...@reviews.apache.org commented on HIVE-2335: ----------------------------------------------------- ----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/1260/ ----------------------------------------------------------- Review request for hive, John Sichi, Yongqiang He, and Ning Zhang. Summary ------- Check the timestamps of the tables/partitions to ensure that they were not written to since the index was last generated This addresses bug HIVE-2335. https://issues.apache.org/jira/browse/HIVE-2335 Diffs ----- ql/src/java/org/apache/hadoop/hive/ql/optimizer/physical/index/IndexWhereProcessor.java 8295687 ql/src/test/queries/clientpositive/index_stale.q PRE-CREATION ql/src/test/queries/clientpositive/index_stale_partitioned.q PRE-CREATION ql/src/test/results/clientpositive/index_stale.q.out PRE-CREATION ql/src/test/results/clientpositive/index_stale_partitioned.q.out PRE-CREATION Diff: https://reviews.apache.org/r/1260/diff Testing ------- added index_stale.q and index_stale_partitioned.q to the testcase suite Thanks, Syed > Indexes are still automatically queried when out of sync with their source > tables > --------------------------------------------------------------------------------- > > Key: HIVE-2335 > URL: https://issues.apache.org/jira/browse/HIVE-2335 > Project: Hive > Issue Type: Bug > Reporter: Syed S. Albiz > Assignee: Syed S. Albiz > Attachments: HIVE-2335.1.patch > > > The automatic index usage does not check whether or not the indexes are still > up-to-date when generating the index queries. This can be addressed in two > stages, the first is to add a check before generating the index query to > ensure that the index is still valid. The next stage may be to add some sort > of mode where indexes are automatically updated on table writes. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira