Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

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


Copy link to this message
-
About Hive Index
Hi,

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,
Lin
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB