Ransom, >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. Mark ----- Original Message ----- From: "Hezhiqiang (Ransom)" <ransom.hezhiqi...@huawei.com> To: user@hive.apache.org Cc: "Zhaojun (Terry)" <terry.zhao...@huawei.com> 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. Best regards Ransom.
