hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vineet Mishra <clearmido...@gmail.com>
Subject RE: HiveServer2 load data inpath fails
Date Tue, 20 Oct 2015 17:24:42 GMT
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" <hadoophive@gmail.com> wrote:

> You Need to use “load data local inpath”
>
>
>
>
>
> *From:* Vineet Mishra [mailto:clearmidoubt@gmail.com]
> *Sent:* Tuesday, October 20, 2015 6:08 PM
> *To:* user@hive.apache.org; cdh-user@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!
>

Mime
View raw message