Re: Re: HiveServer2 load data inpath fails

2015-10-27 Thread Takahiko Saito
but due to concurrency and >>> gc issue I am moving to HS2 but if its just dependent on load local then >>> its really strange. >>> >>> Thanks! >>> On Oct 21, 2015 6:22 AM, "r7raul1...@163.com" >>> wrote: >>> >>>>

Re: Re: HiveServer2 load data inpath fails

2015-10-20 Thread Vineet Mishra
on the hiveserver2 host local filesystem . Then try >>> load data local inpath >>> >>> -- >>> r7raul1...@163.com >>> >>> >>> *From:* Vineet Mishra >>> *Date:* 2015-10-21 03:05 >>> *To:* u

Re: Re: HiveServer2 load data inpath fails

2015-10-20 Thread Vineet Mishra
e file on the hiveserver2 host local filesystem . Then try > load data local inpath > > -- > r7raul1...@163.com > > > *From:* Vineet Mishra > *Date:* 2015-10-21 03:05 > *To:* user > *CC:* cdh-user > *Subject:* Re: HiveServer2 load dat

Re: Re: HiveServer2 load data inpath fails

2015-10-20 Thread r7raul1...@163.com
Place the file on the hiveserver2 host local filesystem . Then try load data local inpath r7raul1...@163.com 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:1> l

Re: HiveServer2 load data inpath fails

2015-10-20 Thread Vineet Mishra
Any update around this? 0: jdbc:hive2://hadoop-hs2:1> 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 poss

RE: HiveServer2 load data inpath fails

2015-10-20 Thread Vineet Mishra
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" wrote: > You Need to use “load data local inpath” > > > > > > *From:* Vineet Mishra [mailto:clearmido...@gmail.com] > *Sent:* Tuesday, Oc

RE: HiveServer2 load data inpath fails

2015-10-20 Thread Vikas Srivastava
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/refr