Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Indexing in hive


Copy link to this message
-
Re: Indexing in hive
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)" <[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.
Best regards

Ransom.