I'm using the following command and it errors. but I can see the file has been deleted from /tmp/hive_files/ and I can see the file under /apps/hive/dev.db/tmp_fx_amssubscriberlog4. but when I do a select count(*) from the table it retuns 0.
LOAD DATA INPATH '/tmp/hive_files/20170925190153_fx_amssubscriberlog1.csv' INTO TABLE dev.tmp_fx_amssubscriberlog4;
java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask
but if I use the following command and its fine
LOAD DATA INPATH '/tmp/hive_files/20170925190153_fx_amssubscriberlog1.csv' OVERWRITE INTO TABLE dev.tmp_fx_amssubscriberlog4;