Hey,
I have a package in ODI 12c in which I have made a mapping which uses IKM file-to-hive, and maps flat file data to HIVE.
The problem is every time I restart my System and turn on the mapping, it fails and gives me the following error :
"
ODI-1226: Step File_to_Hive fails after 1 attempt(s).
ODI-1240: Flow File_to_Hive fails while performing a Load data file(s)-IKM File to Hive (LOAD DATA)- operation. This flow loads target table null.
ODI-1298: Serial task "SERIAL-MAP_MAIN- (10)" failed because child task "SERIAL-EU-fileinfo_UNIT (20)" is in error.
ODI-1298: Serial task "SERIAL-EU-fileinfo_UNIT (20)" failed because child task "Load data file(s)-IKM File to Hive (LOAD DATA)- (60)" is in error.
ODI-1590: The execution of the script failed.
Caused By: org.apache.bsf.BSFException: exception from Groovy: java.sql.SQLException: Exception encountered while submitting:
-------------------
load data local inpath '/home/hive/WIP/com20150430_201_187548.unl'
into table default.I_stg_cbs_com "
However when I do 'chmod 755' on the directories, It starts working. I have to do this everytime i turn on my system.
Is there any solution to this ? So that I can run the package in a batch.