It works. Thanks a lot.
On Tue, Aug 21, 2012 at 11:49 PM, Philip Tromans <[EMAIL PROTECTED]
> 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,