Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- sqoop import --connect jdbc:sap://xxxxxxxxxxxxxxxxx.xx.xx.xxxxxxxxxx.com:30015/?currentschema=UNILEVER --driver com.sap.db.jdbc.Driver --username xxxx --password xxxxxxxxxxxx --table BRAND_POSITION_HIERARCHY --hive-import --hive-table BRAND_POSITION_HIER_CODE -m -1
- Warning: /usr/hdp/2.4.2.4-5/accumulo does not exist! Accumulo imports will fail.
- Please set $ACCUMULO_HOME to the root of your Accumulo installation.
- 17/01/31 10:38:03 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6.2.4.2.4-5
- 17/01/31 10:38:03 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
- 17/01/31 10:38:03 INFO tool.BaseSqoopTool: Using Hive-specific delimiters for output. You can override
- 17/01/31 10:38:03 INFO tool.BaseSqoopTool: delimiters with --fields-terminated-by, etc.
- 17/01/31 10:38:03 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.
- 17/01/31 10:38:03 INFO manager.SqlManager: Using default fetchSize of 1000
- 17/01/31 10:38:03 INFO tool.CodeGenTool: Beginning code generation
- SLF4J: Class path contains multiple SLF4J bindings.
- SLF4J: Found binding in [jar:file:/usr/hdp/2.4.2.4-5/hadoop/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]
- SLF4J: Found binding in [jar:file:/usr/hdp/2.4.2.4-5/zookeeper/lib/slf4j-log4j12-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
- SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
- SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
- 17/01/31 10:38:04 ERROR manager.SqlManager: Error executing statement: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: Cannot connect to jdbc:sap://xxxxxxxxxxxxxxxxx.xx.xx.xxxxxxxxxx.com:30015/ [Unknown host xxxxxxxxxxxxxxxxx.xx.xx.xxxxxxxxxx.com:30015 [xxxxxxxxxxxxxxxxx.xx.xx.xxxxxxxxxx.com], -709].
- com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: Cannot connect to jdbc:sap://xxxxxxxxxxxxxxxxx.xx.xx.xxxxxxxxxx.com:30015/ [Unknown host xxxxxxxxxxxxxxxxx.xx.xx.xxxxxxxxxx.com:30015 [xxxxxxxxxxxxxxxxx.xx.xx.xxxxxxxxxx.com], -709].
- at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.createException(SQLExceptionSapDB.java:242)
- at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.createException(SQLExceptionSapDB.java:226)
- at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.generateDatabaseException(SQLExceptionSapDB.java:209)
- at com.sap.db.jdbc.Driver.connect(Driver.java:308)
- at java.sql.DriverManager.getConnection(DriverManager.java:571)
- at java.sql.DriverManager.getConnection(DriverManager.java:215)
- at org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:885)
- at org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52)
- at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:744)
- at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:767)
- at org.apache.sqoop.manager.SqlManager.getColumnInfoForRawQuery(SqlManager.java:270)
- at org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:241)
- at org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:227)
- at org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:295)
- at org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1845)
- at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1645)
- at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:107)
- at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:478)
- at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:605)
- at org.apache.sqoop.Sqoop.run(Sqoop.java:148)
- at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76)
- at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:184)
- at org.apache.sqoop.Sqoop.runTool(Sqoop.java:226)
- at org.apache.sqoop.Sqoop.runTool(Sqoop.java:235)
- at org.apache.sqoop.Sqoop.main(Sqoop.java:244)
- 17/01/31 10:38:04 ERROR tool.ImportTool: Encountered IOException running import job: java.io.IOException: No columns to generate for ClassWriter
- at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1651)
- at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:107)
- at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:478)
- at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:605)
- at org.apache.sqoop.Sqoop.run(Sqoop.java:148)
- at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76)
- at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:184)
- at org.apache.sqoop.Sqoop.runTool(Sqoop.java:226)
- at org.apache.sqoop.Sqoop.runTool(Sqoop.java:235)
- at org.apache.sqoop.Sqoop.main(Sqoop.java:244)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement