Tuesday, September 16, 2014

Sqoop EOD Imports based on script in Cron Jobs

#!/bin/ksh

today="$(date +'%d/%m/%Y')" >/dev/null 2>&1

sqoop import 
--connect "jdbc:mysql://localhost:1337/mysql_db" 
--query 'SELECT currentdate FROM mytable WHERE currentdate=$today
--target -dir /user/sqoop_op/

No comments:

Post a Comment