sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From yogesh kumar <yogeshsq...@gmail.com>
Subject Sqoop Incremental pull
Date Mon, 30 Dec 2013 14:33:20 GMT
Hello all,

I have done sqoop import for a particluar table first time say table
Employee..

sqoop import -libjars .....
--query "select empno, name, date, loc from table Employee where
\$CONDITIONS ..  "
*--split-by empno*
--fields-terminated-by ','
.
.
.
.

I have created an external table on hive,

*Now I want to pull data on daily basis by using incremental pull.  can I
spsecy fy the diffrent column for --split-by*

like

 sqoop import -libjars .....
--query "select empno, name, date, loc from table Employee where
\$CONDITIONS ..  "
--check-column date
--incremental append
--last-value 2013-05-01
*--split-by date*
--split-by empno


Can I change the column for *split by in incremental sqoop*, if not then
how to do it.

Pls suggest

Thanks & Regards
Yogesh

Mime
View raw message