Re: Sqoop Hcat Int partition error

2016-03-04 Thread Biswajit Nayak
Any one has seen this ? On Tue, Mar 1, 2016 at 11:07 AM, Biswajit Nayak wrote: > The fix in the https://issues.apache.org/jira/browse/HIVE-7164. does not > works. > > On Tue, Mar 1, 2016 at 10:51 AM, Richa Sharma > wrote: > >> Great! >> >> So what is the interim fix you are implementing >> >>

Re: Sqoop Hcat Int partition error

2016-02-29 Thread Biswajit Nayak
The fix in the https://issues.apache.org/jira/browse/HIVE-7164. does not works. On Tue, Mar 1, 2016 at 10:51 AM, Richa Sharma wrote: > Great! > > So what is the interim fix you are implementing > > Richa > On Mar 1, 2016 4:06 PM, "Biswajit Nayak" wrote: > >> Thanks Richa. >> >> The issue was s

Re: Sqoop Hcat Int partition error

2016-02-29 Thread Richa Sharma
Great! So what is the interim fix you are implementing Richa On Mar 1, 2016 4:06 PM, "Biswajit Nayak" wrote: > Thanks Richa. > > The issue was suppose to be fixed in Hive 0.12 version as per the jira > https://issues.apache.org/jira/browse/HIVE-7164. > > Even raised a ticket in sqoop jira [SQOO

Re: Sqoop Hcat Int partition error

2016-02-29 Thread Biswajit Nayak
Thanks Richa. The issue was suppose to be fixed in Hive 0.12 version as per the jira https://issues.apache.org/jira/browse/HIVE-7164. Even raised a ticket in sqoop jira [SQOOP-2840] for this . Thanks Biswa On Tue, Mar 1, 2016 at 9:56 AM, Richa Sharma wrote: > Hi, > > The values should sti

Re: Sqoop Hcat Int partition error

2016-02-29 Thread Richa Sharma
Hi, The values should still persist if partition column data type in Hive is a string. I am checking HCatalog documentation for support of int data type in partition column. Cheers Richa On Tue, Mar 1, 2016 at 3:06 PM, Biswajit Nayak wrote: > Hi Richa, > > Thats a work around. But how to hand

Re: Sqoop Hcat Int partition error

2016-02-29 Thread Biswajit Nayak
Hi Richa, Thats a work around. But how to handle the columns with INT type. Changing the type will be the last option for me. Regards Biswa On Tue, Mar 1, 2016 at 9:31 AM, Richa Sharma wrote: > Hi Biswajit > > The answer is in the last line of the error message. Change the data type > of par

Re: Sqoop Hcat Int partition error

2016-02-29 Thread Richa Sharma
Hi Biswajit The answer is in the last line of the error message. Change the data type of partition column to string in hive and try again. Hope it helps ! Richa 16/02/12 08:04:12 ERROR tool.ExportTool: Encountered IOException running export job: java.io.IOException: The table provided default.e

Sqoop Hcat Int partition error

2016-02-29 Thread Biswajit Nayak
Hi All, I am trying to do a SQOOP export from hive( integer type partition) to mysql through HCAT and it fails with the following error. Versions:- Hadoop :- 2.7.1 Hive :- 1.2.0 Sqoop :- 1.4.5 Table in Hive :- hive> use default; OK Time taken: 0.028 seconds hive> describe emp_detail