Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

index in hive question

Solved Go to solution

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

Re: index in hive question

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.

2 REPLIES 2

Re: index in hive question

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.

Highlighted

Re: index in hive question

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

Don't have an account?
Coming from Hortonworks? Activate your account here