Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB