Hi,
I am using a tool to move data from Oracle to HDFS via hiverserver 2 set up. The tool supposed to produce a text file that hive supposed to load into a table I am getting the following error from hiverserver2 Loading data to table asehadoop.rs_lastcommit partition (p_orig=0, p_conn=0) Failed with exception Unable to move source file:/tmp/hive/rs_hive_rec_0x2aaab001f7a0_1749856581.dat to destination hdfs://rhes564:9000/user/hive/warehouse/asehadoop.db/rs_lastcommit/p_orig=0/ p_conn=0/rs_hive_rec_0x2aaab001f7a0_1749856581.dat FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask Now both the tool and hive OS user hduser have read/wite/execute to directory /tmp/hive. However, I cannot see that file in /tmp/hive directory. Am I correct that the error message indicates an execution error (because could not find the source file) as opposed to permission error? Where can I get a fuller description of the issue? Thanks Mich NOTE: The information in this email is proprietary and confidential. This message is for the designated recipient only, if you are not the intended recipient, you should destroy it immediately. Any information in this message shall not be understood as given or endorsed by Peridale Ltd, its subsidiaries or their employees, unless expressly so stated. It is the responsibility of the recipient to ensure that this email is virus free, therefore neither Peridale Ltd, its subsidiaries nor their employees accept any responsibility.
