sqoopt import --incremental lastmodifed with --merge-key

PHOTO

Sun Apr 10 2022 11:09:37 GMT+0000 (Coordinated Universal Time)

Saved by @irfan309

# with --merge-key 

sqoop-import --connect \
jdbc:mysql://quickstart.cloudera:3306/retail_db \
--username retail_dba --password cloudera \
--table orders \
--warehouse-dir /data \
--incremental lastmodified \
--check-column order_date \
--last-value '2022-04-10 03:21:14.0' --merge-key order_id

Save snippets that work from anywhere online with our extensions

Available in the Chrome Web Store

Get Firefox Add-on

Get VS Code extension

Comments

More like this

BIGDATA_SQOOP

@irfan309

sqoop --incremental lastmodified mode wiht date sqoopt import --incremental lastmodifed with --merge-key CREATING SQOOP JOB (FOR INCREMENTAL IMPORT append) LIST THE SQOOP JOBS to execute the sqoopt jobs #create a passowrd alias in sqoop TO USE THE PASSWORD-ALIAS IN OUR SQOOP COMMANDs LOAD DATA FROM CSV FILE IN MYSQL

Browse more snippets >>