e functions) are applied on keys other
>> > than
>> > the group-by keys. Since you are trying to get a count of id2 and have
>> > the
>> > index key (as well as the group-by key) on id1, the optimization is not
>> > applied. Hence the same plan.
&g
other
> than
> > the group-by keys. Since you are trying to get a count of id2 and have
> the
> > index key (as well as the group-by key) on id1, the optimization is not
> > applied. Hence the same plan.
> > Hope this helps. Please let me know if you have any questions
zation is not
> applied. Hence the same plan.
> Hope this helps. Please let me know if you have any questions.
> Regards,
> Prajakta
>
>
>> From: rohan monga
>> Date: September 19, 2011 11:26:29 PM PDT
>> To:
>> Subject: problems with indices
>> Repl
plan.
Hope this helps. Please let me know if you have any questions.
Regards,
Prajakta
> From: rohan monga
> Date: September 19, 2011 11:26:29 PM PDT
> To:
> Subject: problems with indices
> Reply-To:
>
> Hi,
> I have a table and index that look like
>
>
> CR
Hi,
I have a table and index that look like
CREATE TABLE table_t1(id1 int, id2 int)
CREATE INDEX table_t1_idx ON TABLE table_t1(id1) AS
'org.apache.hadoop.hive.ql.index.AggregateIndexHandler' WITH DEFERRED
REBUILD IDXPROPERTIES("AGGREGATES"="count(id2)");
ALTER INDEX table_t1_idx ON table_t1 REB
