[ https://issues.apache.org/jira/browse/HIVE-2128?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13060888#comment-13060888 ]
John Sichi commented on HIVE-2128: ---------------------------------- I was thinking of the case of compact indexes (one on each table). Your test case is similar, but for bitmap indexes. We certainly should not be trying to combine the indexes in this case since they are on different tables! The plan looks strange already because it is applying the srcpart predicate twice, and the src index not at all. (It's hard to tell what's going on since the same predicate is applied on both tables; use a different predicate to see if it's two copies of the same vs one of each.) Regardless of index type, I think we *should* be able to use indexes on different tables at once in the same query. > Automatic Indexing with multiple tables > --------------------------------------- > > Key: HIVE-2128 > URL: https://issues.apache.org/jira/browse/HIVE-2128 > Project: Hive > Issue Type: Improvement > Components: Indexing > Affects Versions: 0.8.0 > Reporter: Russell Melick > Assignee: Syed S. Albiz > Attachments: HIVE-2128.1.patch, HIVE-2128.1.patch, HIVE-2128.2.patch > > > Make automatic indexing work with jobs which access multiple tables. We'll > probably need to modify the way that the index input format works in order to > associate index formats/files with specific tables. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira