Cloudera Community
dharmendra78
user rank
Explorer
My Accepted Solutions
Show All

sqoop import error from oracle database

by Explorer in Support Questions
‎07-27-2018 05:19 AM
‎07-27-2018 05:19 AM
Hi, I am able to view the list of table of input source db-oracle from sqoop but when trying to import the table then getting below error. $ sqoop import -connect jdbc:oracle:thin:@192.168.*.*:1521:orcl --username *** --P --table SDO_GR_RDT_1 --target-dir /user/****/SDO_GR_RDT_1/ --driver oracle.jdbc.OracleDriver Warning: /usr/hdp/3.0.0.0-1634/accumulo does not exist! Accumulo imports will fail. Please set $ACCUMULO_HOME to the root of your Accumulo installation. SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/usr/hdp/3.0.0.0-1634/hadoop/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/usr/hdp/3.0.0.0-1634/hive/lib/log4j-slf4j-impl-2.10.0.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] 18/07/27 10:34:10 INFO sqoop.Sqoop: Running Sqoop version: 1.4.7.3.0.0.0-1634 Enter password: 18/07/27 10:34:16 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. 18/07/27 10:34:16 INFO manager.SqlManager: Using default fetchSize of 1000 18/07/27 10:34:16 INFO tool.CodeGenTool: Beginning code generation 18/07/27 10:34:19 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM SDO_GR_RDT_1 AS t WHERE 1=0 18/07/27 10:34:19 ERROR manager.SqlManager: Error executing statement: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791) at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491) at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:777) at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:786) at org.apache.sqoop.manager.SqlManager.getColumnInfoForRawQuery(SqlManager.java:289) at org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:260) at org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:246) at org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:328) at org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1872) at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1671) at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:106) at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:512) at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:643) at org.apache.sqoop.Sqoop.run(Sqoop.java:150) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76) at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:186) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:240) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:249) at org.apache.sqoop.Sqoop.main(Sqoop.java:258) 18/07/27 10:34:19 ERROR tool.ImportTool: Import failed: java.io.IOException: No columns to generate for ClassWriter at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1677) at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:106) at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:512) at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:643) at org.apache.sqoop.Sqoop.run(Sqoop.java:150) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76) at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:186) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:240) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:249) at org.apache.sqoop.Sqoop.main(Sqoop.java:258) ... View more
Labels:

Re: HDP 3.0 Tez rpm issue

by Explorer in Support Questions
‎07-26-2018 04:07 PM
‎07-26-2018 04:07 PM
thanks a lot to all the supportive team members. i have used rm -rf /usr/hdp/3.0.0.0-1634/tez/conf and installed tez and it installed now. ... View more

Re: HDP 3.0 tez installation issue on one of new n...

by Explorer in Support Questions
‎07-26-2018 04:05 PM
‎07-26-2018 04:05 PM
thanks it is resolved using #rm -rf /usr/hdp/3.0.0.0-1634/tez/conf and again installing it. ... View more

Re: HDP 3.0 tez installation issue on one of new n...

by Explorer in Support Questions
‎07-26-2018 03:54 PM
‎07-26-2018 03:54 PM
Hi, I am not sure what is issue with tez. ================================================================================ Install 1 Package Total download size: 256 M Installed size: 259 M Downloading packages: tez_3_0_0_0_1634-0.9.1.3.0.0.0-1634.noarch.rpm | 256 MB 03:54 Running transaction check Running transaction test Transaction test succeeded Running transaction Installing : tez_3_0_0_0_1634-0.9.1.3.0.0.0-1634.noarch 1/1 Error unpacking rpm package tez_3_0_0_0_1634-0.9.1.3.0.0.0-1634.noarch error: unpacking of archive failed on file /usr/hdp/3.0.0.0-1634/tez/conf: cpio: rename Verifying : tez_3_0_0_0_1634-0.9.1.3.0.0.0-1634.noarch 1/1 Failed: tez_3_0_0_0_1634.noarch 0:0.9.1.3.0.0.0-1634 ... View more

Re: HDP 3.0 Tez rpm issue

by Explorer in Support Questions
‎07-26-2018 05:20 AM
‎07-26-2018 05:20 AM
Hi, I have created ambari 2.7 cluster with HDP 3.0 with single node as a master server , now after everything is up now adding one more data node where i have assigned tez as a slave service in new node but installation is getting failed as mentioned in previous mail. regards ... View more

Re: HDP 3.0 Tez rpm issue

by Explorer in Support Questions
‎07-26-2018 04:44 AM
‎07-26-2018 04:44 AM
Hi, I am using public repos. and getting below error. Total download size: 256 M Installed size: 259 M Downloading packages: tez_3_0_0_0_1634-0.9.1.3.0.0.0-1634.noarch.rpm | 256 MB 13:08 Running transaction check Running transaction test Transaction test succeeded Running transaction Installing : tez_3_0_0_0_1634-0.9.1.3.0.0.0-1634.noarch 1/1 Error unpacking rpm package tez_3_0_0_0_1634-0.9.1.3.0.0.0-1634.noarch error: unpacking of archive failed on file /usr/hdp/3.0.0.0-1634/tez/conf: cpio: rename Verifying : tez_3_0_0_0_1634-0.9.1.3.0.0.0-1634.noarch 1/1 Failed: tez_3_0_0_0_1634.noarch 0:0.9.1.3.0.0.0-1634 Complete! Regards ... View more

Re: HDP 3.0 tez installation issue on one of new n...

by Explorer in Support Questions
‎07-26-2018 04:38 AM
‎07-26-2018 04:38 AM
Hi, Thanks for quick response, I have tried above commands but still getting below errors. Total download size: 256 M Installed size: 259 M Downloading packages: tez_3_0_0_0_1634-0.9.1.3.0.0.0-1634.noarch.rpm | 256 MB 13:08 Running transaction check Running transaction test Transaction test succeeded Running transaction Installing : tez_3_0_0_0_1634-0.9.1.3.0.0.0-1634.noarch 1/1 Error unpacking rpm package tez_3_0_0_0_1634-0.9.1.3.0.0.0-1634.noarch error: unpacking of archive failed on file /usr/hdp/3.0.0.0-1634/tez/conf: cpio: rename Verifying : tez_3_0_0_0_1634-0.9.1.3.0.0.0-1634.noarch 1/1 Failed: tez_3_0_0_0_1634.noarch 0:0.9.1.3.0.0.0-1634 Complete! regards Dharam ... View more

HDP 3.0 tez installation issue on one of new node ...

by Explorer in Support Questions
‎07-25-2018 07:47 PM
‎07-25-2018 07:47 PM
Traceback (most recent call last): File "/var/lib/ambari-agent/cache/stacks/HDP/3.0/services/TEZ/package/scripts/tez_client.py", line 130, in <module> TezClient().execute() File "/usr/lib/ambari-agent/lib/resource_management/libraries/script/script.py", line 353, in execute method(env) File "/var/lib/ambari-agent/cache/stacks/HDP/3.0/services/TEZ/package/scripts/tez_client.py", line 90, in install self.install_packages(env) File "/usr/lib/ambari-agent/lib/resource_management/libraries/script/script.py", line 836, in install_packages retry_count=agent_stack_retry_count) File "/usr/lib/ambari-agent/lib/resource_management/core/base.py", line 166, in __init__ self.env.run() File "/usr/lib/ambari-agent/lib/resource_management/core/environment.py", line 160, in run self.run_action(resource, action) File "/usr/lib/ambari-agent/lib/resource_management/core/environment.py", line 124, in run_action provider_action() File "/usr/lib/ambari-agent/lib/resource_management/core/providers/packaging.py", line 30, in action_install self._pkg_manager.install_package(package_name, self.__create_context()) File "/usr/lib/ambari-agent/lib/ambari_commons/repo_manager/yum_manager.py", line 219, in install_package shell.repository_manager_executor(cmd, self.properties, context) File "/usr/lib/ambari-agent/lib/ambari_commons/shell.py", line 749, in repository_manager_executor raise RuntimeError(message) RuntimeError: Failed to execute command '/usr/bin/yum -y install tez_3_0_0_0_1634', exited with code '1', message: 'Error unpacking rpm package tez_3_0_0_0_1634-0.9.1.3.0.0.0-1634.noarch ... View more
Labels:

HDP 3.0 Tez rpm issue

by Explorer in Support Questions
‎07-25-2018 05:36 PM
‎07-25-2018 05:36 PM
... View more
Labels:
Contact Me
Online
Offline
Last Visited
‎09-04-2018 12:05 PM
Community Statistics
Member Since ‎07-25-2018 03:35 PM
Last Visited ‎09-04-2018 12:05 PM
Posts 9