Hi Phil, It works. Thanks a lot.
Best wishes, Lin On Tue, Aug 21, 2012 at 11:49 PM, Philip Tromans <[email protected] > wrote: > 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 >> >
