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
-
Re: About Hive Index
There's a case bug in hive. Put all the names into lower case. I've got a
JIRA open about it somewhere.

Phil.
On Aug 22, 2012 4:39 AM, "Lin" <[EMAIL PROTECTED]> wrote:

> 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