![]() connection-manager directive seems to be needed. Sqoop list-databases -driver .SQLServerDriver -connect jdbc:sqlserver://10.226.170.191\poc:1433 -username WHATEVERUSER -password WHATEVERPASSWORD This error is thrown after executing a command like this: Please specify explicitly which connection manager should be used next time. Any wrong character in the URL may make the database connectivity fail, therefore we recommend installing DbSchema and try to get connected. Sqoop is going to fall back to .GenericJdbcManager. JDBC Driver Download for Oracle, MySQL, SQL Server, PostgreSQL, Derby, SQLite and Microsoft Access. WARN sqoop.ConnFactory: Parameter -driver is set to an explicit driver however appropriate connection manager is not being set (via -connection-manager). ![]() Connectivity is ok.Įven you add it to /var/lib/sqoop/lib/ or /usr/lib/sqoop/lib folder, how do you get past that a connection-manager needs to be set to use a factory class in order to use the Microsoft driver? The error (even is shown as a WARN) is: ![]() I'm trying this in HDP 2.4 sandbox with SQL Server Express 2014. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |