Migrating data using Sqoop Migrating data using Sqoop topics. About Sqoop DSE Hadoop supports Sqoop for migrating data and supports password authentication for Sqoop operations. Running the Sqoop demo Run SQL commands to put the data from a CSV file into a MySQL table in a MySQL database. Then import the SQL data from MySQL to a CQL table in Cassandra. Importing SQL to a CQL table or CFS Steps for importing SQL into a CQL table or the Cassandra File System. Importing data into a CQL list or set Use the cql-import tool to map SQL columns to items in a collection set, list, or map. Importing data into a CQL map Use the cql-import tool to map SQL columns to items in a map, similar to importing data into list and set. Importing joined tables A common use case example imports multiple tables, which are joined in SQL, to Cassandra. Exporting CQL data to SQL Using Sqoop, you can export data of different data types from CQL to MySQL. Exporting selected CQL data to SQL Use export options to select columns for export and limit the page size of the export. You can conditionally filter the data to select for export. Exporting data from CQL collections The cql-export tool supports the export of data from list, set and map collection types. Automating a Sqoop operation Use the Sqoop metastore to save configuration information for an import or export as a job. Sqoop reference Use the dse sqoop command to import SQL data into CQL, export SQL data to SQL, and import Thrift/CLI data to CQL.