It's working now, After restarting Zookeeper. Thank You So Much    Regards, ... View more

I have removed/Rollback export USE_DEPRECATED_CLI=false using below if [ -n '$USE_DEPRECATED_CLI' ]; then USE_DEPRECATED_CLI="true" fi $ echo $USE_DEPRECATED_CLI false $ echo '$USE_DEPRECATED_CLI' $USE_DEPRECATED_CLI $ and now able to execute the query..But unable to create a hive table it's stuck with the running status .. Pls suggest how to fix this? ..(using 8 GB RAM, system).   [cloudera@quickstart ~]$ hive Logging initialized using configuration in jar:file:/usr/lib/hive/lib/hive-common-1.1.0-cdh5.13.0.jar!/hive-log4j.properties WARNING: Hive CLI is deprecated and migration to Beeline is recommended. hive> > > use cards; OK Time taken: 69.268 seconds hive> > > > CREATE TABLE deck_of_cards ( > COLOR string, > SUIT string, > PIP string) > ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' > STORED AS TEXTFILE; and stuck with the running status ...   Regards,     ... View more

Hi Jsensharma, Thank you for your updates ********************************** With netstat :   [cloudera@quickstart ~]$ netstat -tnlpa | grep 1521 (Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.)   [cloudera@quickstart ~]$ sudo netstat -tnlpa | grep 1521 [cloudera@quickstart ~]$   ***************************************************************************** I have added '--driver' and facing a new issue now.  And we are able to list the tables in sql developer for 'HR' user.   [cloudera@quickstart ~]$ sqoop list-tables \ > --driver oracle.jdbc.driver.OracleDriver \ > --connect jdbc:oracle:thin:@localhost:1521:pdborcl \ > --username hr \ > -P \ > --verbose Warning: /usr/lib/sqoop/../accumulo does not exist! Accumulo imports will fail. Please set $ACCUMULO_HOME to the root of your Accumulo installation. 20/02/24 11:41:28 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6-cdh5.13.0 20/02/24 11:41:28 DEBUG tool.BaseSqoopTool: Enabled debug logging. Enter password: 20/02/24 11:41:31 DEBUG sqoop.ConnFactory: Loaded manager factory: org.apache.sqoop.manager.oracle.OraOopManagerFactory 20/02/24 11:41:31 DEBUG sqoop.ConnFactory: Loaded manager factory: com.cloudera.sqoop.manager.DefaultManagerFactory 20/02/24 11:41:31 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. 20/02/24 11:41:31 INFO manager.SqlManager: Using default fetchSize of 1000 20/02/24 11:41:32 DEBUG manager.SqlManager: No connection paramenters specified. Using regular API for making connection. 20/02/24 11:41:32 ERROR manager.SqlManager: Error reading database metadata: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:743) at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:662) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:560) 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:904) at org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52) at org.apache.sqoop.manager.SqlManager.listTables(SqlManager.java:539) at org.apache.sqoop.tool.ListTablesTool.run(ListTablesTool.java:49) at org.apache.sqoop.Sqoop.run(Sqoop.java:147) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:234) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:243) at org.apache.sqoop.Sqoop.main(Sqoop.java:252) Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:470) at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:506) at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:595) at oracle.net.ns.NSProtocol.connect(NSProtocol.java:230) at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1452) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:496) ... 15 more Caused by: java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:579) at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:161) at oracle.net.nt.ConnOption.connect(ConnOption.java:159) at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:428) ... 20 more Could not retrieve tables list from server 20/02/24 11:41:32 ERROR tool.ListTablesTool: manager.listTables() returned null ... View more