question index in hive question in Archives of Support Questions (Read Only)

index in hive question

aliyesami — Fri, 12 Oct 2018 20:48:14 GMT

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 ?

nramanaiah — Sat, 13 Oct 2018 11:24:55 GMT

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

aliyesami — Sun, 14 Oct 2018 10:01:16 GMT

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