Sqoop export to SQL Server: schemas?
provide schema in connection string:
jdbc:sqlserver://MY-SERVER-DNS;databaseName=my_db;schema=my_schema;
so your export sqoop command should be:
sqoop export \--libjars /opt/mapr/sqoop/sqoop-1.4.6/lib/sqljdbc4.jar \--connect "jdbc:sqlserver://MY-SERVER-DNS;databaseName=my_db;schema=my_schema;" \--table "my_table" \--export-dir /path/to/my/hdfs/dirALSO:
Custom schemas are supported for both import and export job - from syntax in sqoop guide, --schema should be passed as -- --schema:
so your export sqoop command should be:
sqoop export \--libjars /opt/mapr/sqoop/sqoop-1.4.6/lib/sqljdbc4.jar \--connect "jdbc:sqlserver://MY-SERVER-DNS;databaseName=my_db;" \--export-dir /path/to/my/hdfs/dir--table "my_table" \-- --schema my_schema \