I too got the same exception while insert overwrite to a bucketed table by selecting data from a partitioned table. I applied a work around to get around this problem. 1. First insert the data to a non partitioned temp table 2.select the data from the temp table and insert it to the bucketed table This solved the problem for me. ... View more

How can i dump the corrupted record to some location for future reference ... View more

Load the data using pig storage and then run tobag function http://pig.apache.org/docs/r0.15.0/func.html#tobag is it a comma separated file? a = LOAD 'student' AS (f1:chararray, f2:int, f3:float); DUMP a; (John,18,4.0) (Mary,19,3.8) (Bill,20,3.9) (Joe,18,3.8) b = FOREACH a GENERATE TOBAG(f1,f3); DUMP b; ({(John),(4.0)}) ({(Mary),(3.8)}) ({(Bill),(3.9)}) ({(Joe),(3.8)}) ... View more

For me this setting is disabled .I can not make any changes.Can you please let me know how to on the ACID properties? ... View more