Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> About Hive Index


+
Lin 2012-08-22, 03:39
+
Philip Tromans 2012-08-22, 06:49
Copy link to this message
-
Re: About Hive Index
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
>>
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB