Hello Jarcec,
Here is the command and the response I get on the console. Where would I find
the log for sqoop? There is no corresponding directory under /var/log.
Thank you very much!
Christos
--
ck@SVR-HDP01:~$ sqoop import-all-tables --connect
"jdbc:sqlserver://192.168.207.194\\SQL2008R2;user=sqoop;password=password;databasename=DWH_BSP;"
--driver com.microsoft.sqlserver.jdbc.SQLServerDriver --username sqoop
--password password --hive-import --verbose
Warning: /usr/lib/hcatalog does not exist! HCatalog jobs will fail.
Please set $HCAT_HOME to the root of your HCatalog installation.
13/10/31 16:47:48 DEBUG tool.BaseSqoopTool: Enabled debug logging.
13/10/31 16:47:48 WARN tool.BaseSqoopTool: Setting your password on the
command-line is insecure. Consider using -P instead.
13/10/31 16:47:48 INFO tool.BaseSqoopTool: Using Hive-specific delimiters for
output. You can override
13/10/31 16:47:48 INFO tool.BaseSqoopTool: delimiters with
--fields-terminated-by, etc.
13/10/31 16:47:48 DEBUG sqoop.ConnFactory: Loaded manager factory:
com.cloudera.sqoop.manager.DefaultManagerFactory
13/10/31 16:47:48 WARN sqoop.ConnFactory: Parameter --driver is set to an
explicit driver however appropriate connection manager is not being set (via
--connection-manager). Sqoop is going to fall back to
org.apache.sqoop.manager.GenericJdbcManager. Please specify explicitly which
connection manager should be used next time.
13/10/31 16:47:48 INFO manager.SqlManager: Using default fetchSize of 1000
13/10/31 16:47:49 DEBUG manager.SqlManager: No connection paramenters
specified. Using regular API for making connection.
13/10/31 16:47:50 INFO tool.CodeGenTool: Beginning code generation
13/10/31 16:47:50 DEBUG manager.SqlManager: Execute getColumnTypesRawQuery :
SELECT t.* FROM tblAdresse AS t WHERE 1=0
13/10/31 16:47:50 DEBUG manager.SqlManager: Using fetchSize for next query: 1000
13/10/31 16:47:50 INFO manager.SqlManager: Executing SQL statement: SELECT t.*
FROM tblAdresse AS t WHERE 1=0
13/10/31 16:47:50 ERROR manager.SqlManager: Error executing statement:
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name
'tblAdresse'.
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name
'tblAdresse'.
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:285)
at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:674)
at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:683)
at
org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:240)
at
org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:223)
at
org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:347)
at
org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1277)
at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1089)
at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:96)
at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:396)
at
org.apache.sqoop.tool.ImportAllTablesTool.run(ImportAllTablesTool.java:105)
at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
at org.apache.sqoop.Sqoop.main(Sqoop.java:238)
13/10/31 16:47:50 ERROR tool.ImportAllTablesTool: Encountered IOException
running import job: java.io.IOException: No columns to generate for ClassWriter
--
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
-----Ursprüngliche Nachricht-----
Von: Jarek Jarcec Cecho [mailto:[email protected]]
Gesendet: Donnerstag, 31. Oktober 2013 16:31
An: [email protected]
Betreff: Re: import-all-tables fails with exception 'Invalid object name' on
non dbo schemas
Hi Christos,
would you mind sharing with us entire Sqoop command and associated log
generated with parameter --verbose?
Jarcec
On Wed, Oct 30, 2013 at 09:40:40AM +0000, Kallinteris, Christos wrote:
> Hello!
>
> I would like to import a complete database from SQL Server into HDFS and from
> there to HIVE to have some data to play with.
>
> I figured out the necessary connection string and I get the first few tables
> imported but then the job throws the invalid object name exception. As far as
> I can tell this happens when the job encounters a table that has a schema
> other than dbo.
>
> Is this a known issue and if yes, is there a way around it?
>
> I'm using Sqoop 1.4.3-cdh4.4.0 on the latest stable Cloudera distribution.
>
> 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]<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
>
