Cloudera Community
Announcements
Celebrating as our community reaches 100,000 members! Thank you!
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