Member since
09-20-2014
2
Posts
0
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
16760 | 09-21-2014 11:46 AM |
09-21-2014
11:46 AM
all, I found a solution and here it is If parcels are used then copy oracle jdbc driver to /opt/cloudera/parcels/CDH/lib/sqoop/lib Copying ojdbc5.jar to /opt/cloudera/parcels/CDH/lib/sqoop/lib resolved my issue Thanks, Prakash
... View more
09-20-2014
01:39 PM
Hi, I am testing loading oracle tables into hdfs/hadoop/hive with the following command sqoop import --connect jdbc:oracle:thin:@<host>:<port>/<db>--username <user name> -P --table <TABLE> i have copied ojdbc5.jar and ojdbc6.jar files in /usr/lib/sqoop/lib/ on the node from where I am running SQOOP. I am getting the following error java.lang.RuntimeException: Could not load db driver class: oracle.jdbc.OracleDriver I also tried export SQOOP_CLASSPATH=/usr/lib/sqoop/lib/* any ideas...? thanks
... View more
Labels:
- Labels:
-
Apache Hadoop
-
Apache Hive
-
Apache Sqoop
-
HDFS