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" <liulin....@gmail.com> 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 >
