Posted On: Feb 25, 2020
The sqoop import/export parallel, data can split into multiple chunks to transfer. The Split by in sqoop selects the id_number to split a column of the table.
sqoop import --connect jdbc:mysql:// localhost/database_name --username user_name --password 1234
--query 'select * from table_name where id=3 AND $CONDITIONS' --split-by table.id_no --target-dir /dir
the split by helped to proper distribution to make a split of data.
Never Miss an Articles from us.