Member since
03-28-2017
6
Posts
0
Kudos Received
0
Solutions
04-02-2017
05:49 PM
Thank you Jay, it is actually listening on different network interface. Thank you very much.
... View more
04-01-2017
09:20 PM
Hi Sensharma, Thank you for replying, I tried telnet from virtual box it throwed below error: [root@sandbox ml-100k]# telnet 127.0.0.1 1521
Trying 127.0.0.1...
telnet: connect to address 127.0.0.1: Connection refused as my Oracle xe is on local host but Im trying to connect through sqoop from my virtual machine, I;m wondering if I have to do any additional configuration. Any help would be appreciated.
... View more
04-01-2017
06:19 PM
Hi All, I have installed HDP 2.5 virtual sandbox and was able to run HDFS commans and create some hive tables. I'm now trying to connect to oracle database and sqoop some tables. I have done the prepreq steps like bringing in ojdbc jar and placing in the lib directory. My Oracle XE edition database is running on my localhost and Hadoop as you are aware on vitual machine. I'm trying to run the below command but throws the following error: sqoop list-tables --connect jdbc:oracle:thin@127.0.0.1:1521/xe --username hr --password xxxxx Error: Please set $ACCUMULO_HOME to the root of your Accumulo installation.
17/04/01 18:09:36 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6.2.5.0.0-1245
17/04/01 18:09:37 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
17/04/01 18:09:37 INFO oracle.OraOopManagerFactory: Data Connector for Oracle and Hadoop is disabled.
17/04/01 18:09:37 INFO manager.SqlManager: Using default fetchSize of 1000
17/04/01 18:09:37 ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.NullPointerException
java.lang.NullPointerException
at org.apache.sqoop.manager.OracleManager.listTables(OracleManager.java:760)
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:76)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:225)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:234)
at org.apache.sqoop.Sqoop.main(Sqoop.java:243) Can someone please help me if I'm missing any additional configuration.
... View more
Labels:
- Labels:
-
Apache Sqoop