fxtrade.com
>
> ----- Original Message -
> From: "Ranjith Raghunath"
> To: "user@hive.apache.org"
> Cc: "terry.zhao...@huawei.com"
> Sent: Wednesday, May 16, 2012 9:46:23 PM
> Subject: Re: Indexing in hive
>
> Thanks Mark, Carl, and Ransom
--
From: "Ranjith Raghunath"
To: "user@hive.apache.org"
Cc: "terry.zhao...@huawei.com"
Sent: Wednesday, May 16, 2012 9:46:23 PM
Subject: Re: Indexing in hive
Thanks Mark, Carl, and Ransom. I really appreciate the answers here. I am using
Hive 0.7.1 and currently trying to cre
: Zhaojun (Terry)
Subject: 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
che.org
Cc: "Zhaojun (Terry)"
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 configurat
Hi Ranjith,
Hive 0.7 supports the ability to build indexes, but the query compiler in
0.7 doesn't know how to optimize queries with these indexes. Hive 0.8 was
the first release to include some support for optimizing query plans with
indexes, and that only applies to GROUP BY and WHERE clauses und
“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.
