Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Sqoop >> mail # user >> Sqoop 1 Importing tables from non DBO schema


Copy link to this message
-
Re: Sqoop 1 Importing tables from non DBO schema
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