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
signature.asc
Description: Digital signature
