You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Lin <li...@gmail.com> on 2012/08/22 05:39:06 UTC
About Hive Index
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
Re: About Hive Index
Posted by Lin <li...@gmail.com>.
Hi Phil,
It works. Thanks a lot.
Best wishes,
Lin
On Tue, Aug 21, 2012 at 11:49 PM, Philip Tromans <philip.j.tromans@gmail.com
> 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" <li...@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
>>
>
Re: About Hive Index
Posted by Philip Tromans <ph...@gmail.com>.
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" <li...@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
>