Failed with exception Unable to move source file .. to destination

[Mich Talebzadeh <mi...@peridale.co.uk>]

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.