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

Switch to Plain View
Hive >> mail # user >> About Hive Index

Copy link to this message
About Hive Index

I build a compact index IX for table A as follows,

create index IX on table A(a, b) as 'COMPACT'
with deferred rebuild
in table A_IX.

When I run the following query,
select c, d from A
where a='a_v' and b ='b_v';

I got the following error:
FAILED: Error in semantic analysis: No partition predicate found for Alias
"A_IX" Table "A_IX"
FAILED: Hive Internal Error: java.lang.NullPointerException(null).

Any suggestions? Thanks.

Best wishes,
Philip Tromans 2012-08-22, 06:49
Lin 2012-08-22, 17:46