I am currently using hive 0.7.1 and creating indexes based on columns in the 
where clause. However, when I run the explain plan I do not see the index being 
leveraged. The syntax that I am using to build the index is as follows:


CREATE INDEX x ON TABLE t(j)
AS 'org.apache.hadoop.hive.ql.index.compact.CompactIndexHandler'
WITH DEFERRED REBUILD

The query is as follows:

Select a,count(*) from x where j='and' group by a

Is there anything I am doing incorrectly?

Thanks,
Ranjith



Reply via email to