hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From trang van anh <anh...@vtc.vn>
Subject Re: Problem build hive index table
Date Fri, 14 Oct 2011 02:08:27 GMT
Thanks for your reply,

I found that when loading data into hive table with key is null value 
then the exception thrown,

after that, i reload data that value is not null. the exception don't 
throw.  Now i cant build index table.

please forgive  to me because my English is not good.

Best regards.

On 10/12/2011 9:20 AM, wd wrote:
> You can look at your hadoop jobtracker log for the detail of the error.
>
>
> On Tue, Oct 11, 2011 at 5:04 PM, trang van anh<anh.tv@vtc.vn>  wrote:
>> Dear Experts,
>>
>> I have problem with building index table in hive, step by step :
>>
>> 1. i created table  named pv_users (pageid int, age int ) that has around 31
>> minion rows.
>> 2 create index table
>> create index pv_users_index on table pv_users(age) as 'compact' with
>> deferred rebuild stored as RCFile.
>> 3.  rebuild index table with command
>> alter index pv_users_index on pv_users(age) rebuild;
>>
>> but i cannot build index table, that throw exception
>>
>> Error: Java heap space
>> Task attempt_201110111005_0013_m_000002_1 failed to report status for 602
>> seconds. Killing
>>
>> Although, time for query with group by is rather quick ~100s
>>
>> Any idea for me
>>
>> Thanks in advance.
>>
>>
>>
>>
>>
>>
>>
>


Mime
View raw message