O'Reilly logo

Microsoft SQL Server 2012 with Hadoop by Debarchan Sarkar

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The Sqoop export tool

As stated earlier, Sqoop is a bi-directional connector. Sqoop's export process will read a set of delimited text files from HDFS in parallel, parse them into records, and insert them as new rows in a target database table. The following examples export data from HDFS and Hive to SQL Server. The assumption is that you are running the commands from the $SQOOP_HOME directory on the master node of the Hadoop cluster, where Sqoop is installed.

When using the sqoop export command, you must specify the following mandatory arguments:

  • --connect argument specifying the connection string to the SQL Server database
  • --username and --password arguments to provide valid credentials to connect to the SQL Server database
  • --table or --call argument ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required