Any update around this? 0: jdbc:hive2://hadoop-hs2:10000> load data inpath '/data/my_table/' overwrite into table mydb.mytable; Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask (state=08S01,code=1)
I couldn't get any possible solution for this. Does it mean HS2 is incapable of supporting load data or there's no JIRA open for it? Version : 0.13.1-cdh5.3.2 On Tue, Oct 20, 2015 at 10:54 PM, Vineet Mishra <clearmido...@gmail.com> wrote: > My data files resides on hdfs and for the given command I guess it will > point to local filesystem instead of hdfs. > On Oct 20, 2015 10:25 PM, "Vikas Srivastava" <hadooph...@gmail.com> wrote: > >> You Need to use “load data local inpath” >> >> >> >> >> >> *From:* Vineet Mishra [mailto:clearmido...@gmail.com] >> *Sent:* Tuesday, October 20, 2015 6:08 PM >> *To:* user@hive.apache.org; cdh-u...@cloudera.or to >> *Subject:* HiveServer2 load data inpath fails >> >> >> >> Hi All, >> >> I am trying to run load data inpath to update/refresh my table data in >> hive. I am using HiveServer2 to make jdbc connection and run the following >> command >> >> load data inpath 'path_to_file_on_hdfs' overwrite into table tablename; >> >> Eventually this query works fine with HiveServer1 through thrift >> connection but fails through jdbc connection on HS2, stack trace mentioned >> below. >> >> java.sql.SQLException: Error while processing statement: FAILED: >> Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask >> >> at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:277) >> >> at >> com.sd.dwh.sc.tungsten.misc.CommonFunction.executeQuery(CommonFunction.java:813) >> >> at >> com.sd.dwh.sc.tungsten.misc.CommonFunction.dataLoadFromFile(CommonFunction.java:836) >> >> at >> com.sd.dwh.sc.tungsten.custom.JDBCMaterialize.merge(JDBCMaterialize.java:105) >> >> at >> com.sd.dwh.sc.tungsten.custom.JDBCMaterialize.run(JDBCMaterialize.java:54) >> >> at >> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) >> >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) >> >> at java.lang.Thread.run(Thread.java:745) >> >> Any suggestions would be highly appreciated. >> >> URGENT CALL. >> >> Thanks! >> >
