index in hive question

[#1]

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 ?

[#2 · Accepted solution]

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

[#3]

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...