Hive java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask

[#1]

Hello community:

I am trying to execute the following code:

create external table IF NOT EXISTS json_kpi3(Column1....columnN);

load data INPATH '/user/raj_ops/malaga/indicadores/kpi-2016-Ciudad-containers-faults_KeyPerformanceIndicator/kpi-2016-Ciudad-containers-faults_KeyPerformanceIndicator.txt' into table json_kpi3;

select * from json_kpi3;

The code return the following error and delete the data file:

 java.lang.Exception: java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask

java.lang.Exception: java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask
	at org.apache.ambari.view.hive20.resources.jobs.JobService.getOne(JobService.java:147)
	at sun.reflect.GeneratedMethodAccessor768.invoke(Unknown Source) 

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

I have given the full permission in /tmp and /user.

[#2]

hello Antonio read this post https://community.hortonworks.com/content/supportkb/154011/execution-error-return-code-1-from-orgapa...