Home >> Big Data Hadoop >> Sqoop Job in Big Data Hadoop

Sqoop Job in Big Data Hadoop

•Create

     sqoop job --create bill_fact -- import --connect jdbc:mysql://localhost:3306/telecom --driver com.mysql.jdbc.Driver --username root --password root --table billing_fact --incremental lastmodified -check-column call_duration --target-dir /test/billing_fact -m 1 --merge-key id

•Verify

  sqoop job --list

•Inspect:

    Sqoop job –show myjob

•Execute:

       sqoop job --exec myjob

 

 

Post Your Comment

Next Questions
Sqoop Codegen
Sqoop job scheduling
Sqoop cron Job
Sqoop cron job example
Hive Prerequisites
Hive Installation
What is Hive
Hive MapReduce Execution
Features of Hive
Hive Architecture
Configuring Metastore of Hive
Hive vs Hadoop
Hive Create Database
Hive Internal and External Table
Hive Internal Table
Drawback of Hive Internal/Managed Table
HIve External Table
Hive DDL
Hive CLI Options
Hive shell commands
Hive Logging & Resources
Hive Types Of Joins
Hive Joins
Hive Joins cont
Hive Built-in Operators

Copyright ©2022 coderraj.com. All Rights Reserved.