Support Questions
Find answers, ask questions, and share your expertise

index in hive question

Master Collaborator

after i create an index on hive table will the index be used in the query selecting from that table or do i have to select from the index itself ?

1 ACCEPTED SOLUTION

Accepted Solutions

Expert Contributor

Yes, indexes automatically help in filtering data when your select query has filters on indexed column. You dont need to explicitily select from index.

View solution in original post

2 REPLIES 2

Expert Contributor

Yes, indexes automatically help in filtering data when your select query has filters on indexed column. You dont need to explicitily select from index.

View solution in original post

Master Collaborator

can you give me an example on how to use the index after creation ?

I am seeing all kinds of strange things just to use the index , don't know if its valid for hive 1.2.1

http://mail-archives.apache.org/mod_mbox/hive-user/201205.mbox/%3C60367909.283357.1337221656873.Java...