>From this JIRA (https://issues.apache.org/jira/browse/HIVE-1644), it looks like automatic use of indexes using hive.optimize.index.filter was introduced in Hive 0.8. However, Ranjith seems to be using Hive 0.7.1 which doesn't support those properties.
Ranjith, you need to set the appropriate priorities before calling your query to make use of indexes. Are you setting any properties? If so, what?
I will try to dig up what those properties are, in the meanwhile.
----- Original Message -----
From: "Hezhiqiang (Ransom)" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Cc: "Zhaojun (Terry)" <[EMAIL PROTECTED]>
Sent: Wednesday, May 16, 2012 8:32:55 PM
Subject: RE: Indexing in hive
“ hive.optimize.index.filter ” is the conf automatically use indexes
If u set hive.optimize.index.groupby = true.
It will set hive.optimize.index.filter =false.
See your configurations.
And you need to build index after create index.