Member since
06-16-2014
6
Posts
1
Kudos Received
0
Solutions
06-18-2014
09:37 AM
in my case, i'm using parcel, i'm not getting any exception. everything seems to install correctly(extracting jand copying sqljdbc4.jar to /var/lib/sqoop2). I restarted both sqoop2 and hue service. but when i create a new sqoop transfer job using hue's web ui, the jdbc driver class can't find any sql server driver. When i typed in "sql" in the jdbc driver class, it can only find MySql and PostGres Sql driver. it cannot find SQL server driver. I tried using sqoop1 via command line, it works, but not in sqoop2.
... View more
06-16-2014
11:29 PM
I'm using CDH5.0.2(automated install). Single node hadoop installation. CDH manager is installed on a different node. I follow this guide to install JDBC driver for SQL server. after copying sqljdbc4.jar to /var/lib/sqoop2, i restarted both sqoop2 and hue service. but when i create a new sqoop transfer job using hue's web ui, the jdbc driver class can't find any sql server driver. When i typed in "sql" in the jdbc driver class, it can only find MySql and PostGres Sql driver. it cannot find SQL server driver. I tried changing the owenership(to sqoop2:sqoop2) and also the permission to the sqljdbc4.jar(to 644) to match that is of postgresql-9.0-801.jdbc4.jar in /var/lib/sqoop2, and restart the sqoop2 and hue service again, and still no luck. It still can't seem to find SQL server driver when i typed in SQL. What should be the value of this field for MS SQL Server?? I would really appreciate any help. I've ben evaluating CDH5, and can't seem to figure out this problem.
... View more
Labels: