Hive: Dynamic Partition
<p>Getting the following error when tried to execute the following code for dynamic partitioning in hive.</p>

<p>Hive Query:</p>

<pre><code>CREATE EXTERNAL TABLE VODPARTITION(EVENT_ID string, EVENT_TYPE string, DATE string) 
PARTITIONED BY (IPADDRESS string) 
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' stored as sequencefile;

 INSERT OVERWRITE TABLE VODPARTITION
 PARTITION(ipaddress) 
 SELECT EVENT_ID, EVENT_TYPE, DATE, t.IP_ADDRESS as ipaddress FROM VOD t; 
</code></pre>

<p>Error:</p>

<pre><code>FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask 
</code></pre>

<p>I am getting this error after map task and 70% of reduce task is completed.
Any help on how to proceed in this case....?</p>

<p>Regards</p>