Hi Christos, parameter --schema is a connector specific "extra" parameter, not a "sqoop" parameter and therefore you have to place it into the section for extra arguments, for example:
sqoop import --connect .... -- --schema Production Jarcec On Thu, Oct 31, 2013 at 08:47:00AM +0000, Kallinteris, Christos wrote: > Hello Abe, > > The command is as follows: > > sqoop import --connect > "jdbc:sqlserver://192.168.207.177\\SQL2012;user=sqoop;password=password;databasename=AdventureWorks2008R2;" > --driver com.microsoft.sqlserver.jdbc.SQLServerDriver --username sqoop > --password password --hive-import --table Product --schema Production > > If I omit the schema parameter it complains about an invalid object name, if > I include it, it complains about an unrecognized parameter. > > If this is a limitation of Sqoop, I will import using Sqoop2 and manually > load the tables into hive; I was just hoping to avoid the hassle of writing > the table definitions for hive myself. > > Thanks for your time! > > Christos > -- > > initions AG > Christos Kallinteris > Weidestraße 120a > D-22083 Hamburg > > t: +49 (0) 40 / 41 49 60-79 > f: +49 (0) 40 / 41 49 60-11 > e: [email protected]<mailto:[email protected]> > w: www.initions.com<http://www.initions.com/> > > > Vollständiger Name der Gesellschaft: initions innovative IT solutions AG > Sitz der Gesellschaft: Hamburg > Handelsregister Hamburg B 83929 > Aufsichtsratsvorsitzender: Dr. Michael Leue > Vorstand: Dr. Stefan Anschütz, André Paul Henkel, Dr. Helge Plehn > > Von: Abraham Elmahrek [mailto:[email protected]] > Gesendet: Mittwoch, 30. Oktober 2013 19:26 > An: [email protected] > Betreff: Re: Sqoop 1 Importing tables from non DBO schema > > Hey there, > > Can you provide the sqoop 1.4.3 command you're using? > > If you can import via sqoop2, but are missing the proper commands to import > into hive, you may be able to simply load the data into hive once it's in > HDFS > (https://cwiki.apache.org/confluence/display/Hive/GettingStarted#GettingStarted-DMLOperations). > > -Abe > > On Wed, Oct 30, 2013 at 6:36 AM, Kallinteris, Christos > <[email protected]<mailto:[email protected]>> wrote: > Hello! > > I'm trying to import a Table into Hive with Sqoop 1.4.3 that has a > nonstandard schema. If I just reference the table I get an invalid object > name exception. > > The documentation for Sqoop says that when importing from SQLServer one can > specify the schema with the -schema option but when I try that I get an > unrecognized parameter error. > > Import of dbo Tables works so it's not the rest of the connection string > that's broken. I can import the tables using Sqoop2 but then I don't have the > -hive option :( > > Any ideas and recommendations welcome. > > Thanks! > > Christos > > -- > > initions AG > Christos Kallinteris > Weidestraße 120a > D-22083 Hamburg > > t: +49 (0) 40 / 41 49 > 60-79<tel:%2B49%20%280%29%2040%20%2F%2041%2049%2060-79> > f: +49 (0) 40 / 41 49 > 60-11<tel:%2B49%20%280%29%2040%20%2F%2041%2049%2060-11> > e: [email protected]<mailto:[email protected]> > w: www.initions.com<http://www.initions.com/> > > > Vollständiger Name der Gesellschaft: initions innovative IT solutions AG > Sitz der Gesellschaft: Hamburg > Handelsregister Hamburg B 83929 > Aufsichtsratsvorsitzender: Dr. Michael Leue > Vorstand: Dr. Stefan Anschütz, André Paul Henkel, Dr. Helge Plehn > >
signature.asc
Description: Digital signature
