sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kallinteris, Christos" <kallinte...@initions.com>
Subject AW: Sqoop 1 Importing tables from non DBO schema
Date Thu, 31 Oct 2013 08:47:00 GMT
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:  kallinteris@initions.com<mailto:kallinteris@initions.com>
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:abe@cloudera.com]
Gesendet: Mittwoch, 30. Oktober 2013 19:26
An: user@sqoop.apache.org
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 <kallinteris@initions.com<mailto:kallinteris@initions.com>>
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:  kallinteris@initions.com<mailto:kallinteris@initions.com>
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



Mime
View raw message