Sqoop 1.4.3 freshly built even works very well with sql server. Just get the sqoop jar and replace it and should work just fine. I so far never had any issues changing sqoop version :)
Good luck! Thanks, Chalcy On Fri, Oct 12, 2012 at 2:16 PM, Artem Ervits <[email protected]> wrote: > Actually I was just able to test 3) below and it succeeded, I cast the > nvarchar as char. > > Thank you again, I will do 1) and 2) and report back the results. > > -----Original Message----- > From: Jarek Jarcec Cecho [mailto:[email protected]] > Sent: Friday, October 12, 2012 1:51 PM > To: [email protected] > Subject: Re: SQOOP 1.3.0 questions using SQL Server > > Hi Artem, > Sqoop 1.3.0 is very old release, so I would definitely recommend to > upgrade to latest 1.4.2. Please note that this release include SQOOP-480[1] > that fixes some issues for connectors compiled against 1.3 in 1.4. Sqoop is > simple command line utility so you might try to download release into some > temporary folder and verify that everything is working prior upgrading > Sqoop system wise. > > Specifically to your questions > > 1) --incremental > Usually Sqoop will print out error message first followed by help page, so > I would advise checking few initial lines to see what exactly is wrong. > > 2) --compress > Please try to reproduce this issue on 1.4.2 and file jira if you'll be > able to reproduce it. > > 3) --as-avrodatafile > Based on [2] SQL type -9 corresponds to data type NVARCHAR. We've added > support for NVARCHAR in SQOOP-323 [3] that is part of Sqoop since version > 1.4.0-incubating - e.g. 1.3.0 version do not support NVARCHAR type out of > the box. > > Jarcec > > Links: > 1: https://issues.apache.org/jira/browse/SQOOP-480 > 2: > http://docs.oracle.com/javase/6/docs/api/constant-values.html#java.sql.Types.DECIMAL > 3: https://issues.apache.org/jira/browse/SQOOP-323 > > On Fri, Oct 12, 2012 at 05:29:41PM +0000, Artem Ervits wrote: > > > > Hello all, > > > > I'm testing a few switches for Sqoop import and I'm having the following > problems. > > > > When I use the -incremental switch, the command fails and shows me the > help page. > > When I use the -compress switch, the command works but when I try to > uncompress the results, it says gzip undefined compression code. I also > tried to explicitly state the codec and it would still not append the > compression extension to the files nor am I able to uncompress the data. > > When I use the -as-avrodatafile I get ERROR tool.ImportTool: Imported > Failed: Cannot convert SQL type -9 > > > > Any ideas? I am not sure if upgrading Sqoop will fix it because SQL > Server connector specifically required a 1.3.0 release. > > > > Thanks. > > > > Artem Ervits > > Data Analyst > > New York Presbyterian Hospital > > > > > > > > -------------------- > > > > This electronic message is intended to be for the use only of the named > recipient, and may contain information that is confidential or privileged. > If you are not the intended recipient, you are hereby notified that any > disclosure, copying, distribution or use of the contents of this message is > strictly prohibited. If you have received this message in error or are not > the named recipient, please notify us immediately by contacting the sender > at the electronic mail address noted above, and delete and destroy all > copies of this message. Thank you. > > > > > > > > > > -------------------- > > > > This electronic message is intended to be for the use only of the named > recipient, and may contain information that is confidential or privileged. > If you are not the intended recipient, you are hereby notified that any > disclosure, copying, distribution or use of the contents of this message is > strictly prohibited. If you have received this message in error or are not > the named recipient, please notify us immediately by contacting the sender > at the electronic mail address noted above, and delete and destroy all > copies of this message. Thank you. > > > > > > > > > -------------------- > > This electronic message is intended to be for the use only of the named > recipient, and may contain information that is confidential or privileged. > If you are not the intended recipient, you are hereby notified that any > disclosure, copying, distribution or use of the contents of this message is > strictly prohibited. If you have received this message in error or are not > the named recipient, please notify us immediately by contacting the sender > at the electronic mail address noted above, and delete and destroy all > copies of this message. Thank you. > > > > > -------------------- > > This electronic message is intended to be for the use only of the named > recipient, and may contain information that is confidential or privileged. > If you are not the intended recipient, you are hereby notified that any > disclosure, copying, distribution or use of the contents of this message is > strictly prohibited. If you have received this message in error or are not > the named recipient, please notify us immediately by contacting the sender > at the electronic mail address noted above, and delete and destroy all > copies of this message. Thank you. > > > >
