Place the file on the hiveserver2 host local filesystem . Then try load data local inpath
[email protected] From: Vineet Mishra Date: 2015-10-21 03:05 To: user CC: cdh-user Subject: Re: HiveServer2 load data inpath fails 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 <[email protected]> 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" <[email protected]> wrote: You Need to use “load data local inpath” From: Vineet Mishra [mailto:[email protected]] Sent: Tuesday, October 20, 2015 6:08 PM To: [email protected]; [email protected] 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!
