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...@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.
