Member since
10-08-2018
2
Posts
0
Kudos Received
0
Solutions
10-11-2018
02:29 PM
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.
... View more
Labels:
- Labels:
-
Apache Hive