I'm using HDP 2.5 in our server with 2 nodes. I'm running query successfully in hive. Suddenly I'm facing mapping with source table to add column to my new table, By this below query; I got vertext failled error. Please find my log hive-error.txt while running this query in hive view. Please tell me how do i resolve this issue.
create table New_table As select distinct ab.id, ab.first_name, ab.middle_name, ab.last_name, b.Address, b.City_Name, b.State_Name from Temp_table ab join Source_table b on (ab.id=b.id);
How much memory do you have available for your cluster.
Caused by: java.util.concurrent.ExecutionException: java.lang.OutOfMemoryError: Java heap space
Please have a look at this document help you
In our cluster each node has 16 gb memory. and also set in cli java heap size. still i can't able to resolve
set hive.tez.container.size=4096; set hive.tez.java.opts=-Xmx3280m; set tez.runtime.io.sort.mb=1640; set tez.runtime.unordered.output.buffer.size-mb=410;
Mapper 2 initialied failed.