-Re: About Hive Index
Philip Tromans 2012-08-22, 06:49
There's a case bug in hive. Put all the names into lower case. I've got a
JIRA open about it somewhere.
On Aug 22, 2012 4:39 AM, "Lin" <[EMAIL PROTECTED]> wrote:
> 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,