sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jarek Jarcec Cecho <jar...@apache.org>
Subject Re: Sqoop Incrementail import fails
Date Mon, 06 Jan 2014 09:33:24 GMT
Hi Yogesh,
would you mind sharing with us entire stack trace?

Jarcec

On Thu, Jan 02, 2014 at 01:00:02PM +0530, yogesh kumar wrote:
>   Hello All
> 
> I have used this sqoop incremental import ..  as the data is in huge volume
> 
> 
> 
> sqoop import -libjars
> --driver com.sybase.jdbc3.jdbc.SybDriver \
> --query "select * from
> from ${EMP} where \$CONDITIONS and SAL > ${AA} and SAL <= ${BB}" \
> --check-column feed_key \
> --incremental append \
> --last-value ${AA} \
> --split-by DEPT \
> --fields-terminated-by ',' \
> --target-dir ${TARGET_DIR}/${INC} \
> --username ${SYBASE_USERNAME} \
> --password ${SYBASE_PASSWORD} \
> 
> and the error I got is
> 
> *sqoop/01224054700null/_temporary/_attempt_201311150154_20546_m_000000_0/part-m-00000
> (Disk quota*
> 
> 
> 
> *While same issue I faced while 1st time import ( to import last 19 months
> data), I i get rid of easly by puttion it into a loop..  and changing the
> targed directry for every loop *
> 
> 
> for i in `seq 0 18`
> do
> sqoop import -libjars ${SQOOP_SYBASE_JAR} -D
> mapred.job.queue.name=${HADOOP_JOB_QUEUE} --verbose \
> --driver com.sybase.jdbc3.jdbc.SybDriver \
> --connect ${CONNECTION_STRING} \
> --query "select * from
> from ${EMP} where \$CONDITIONS and SAL > ${AA} and SAL <= ${BB}" \
> --split-by cycle_cd \
> --fields-terminated-by ',' \
> 
> *--target-dir ${TARGET_DIR}/${APAC_MONTHLY_HIST}/${i} \*
> 
> --username ${SYBASE_USERNAME} \
> --password ${SYBASE_PASSWORD} \
> 
> 
> 
> Pls Help and suggest.
> 
> Thanks
> Yogesh

Mime
View raw message