@JJ Meyer ... View more

Hive ctx..sql(s).show was not giving expected output i.e a blank table. Passed values to source and target db through arguments with spark submit. I was able to find the issue-Worked after I Converted dtshipment date and thedate both to timestamp for camparison. While running the query in hive cli it was able to compare dtshipment_date(date type) with thedate(timestamp) and give the records on join but through spark sql it was not giving same output until I converted both to timestamp. ... View more

Can you please share what exact known issues you are referring to? ... View more

I am getting the error regarding specifying connection manager even though I have added the jar file at /usr/hdp/current/sqoop_client/lib Can anyone help? I have used the same command as given above. Error- 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. 17/06/20 11:28:48 INFO manager.SqlManager: Using default fetchSize of 1000 17/06/20 11:28:48 INFO tool.CodeGenTool: Beginning code generation 17/06/20 11:28:48 ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.RuntimeException: Could not load db driver class: com.microsoft.jdbc.sqlserver.SQLServerDriver ... View more

Hi, Were you able to find a solution to this? We have a similar setup and I can't seem to find any examples of that. ... View more