I specified the schema / database within the jdbc connection string and it works fine.
Give that a try. On Thu, Oct 31, 2013 at 4:47 AM, Kallinteris, Christos < [email protected]> 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] > w: 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]> 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 L**** > > **** > > 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 > f: +49 (0) 40 / 41 49 60-11 > e: [email protected] > w: 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***** > > **** > > ** ** > -- -- JChan
