Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Sqoop import some mappers not getting data

Sqoop import some mappers not getting data

New Contributor

I've the below sqoop import command

sqoop import \
--connect "jdbc:oracle:thin:@IP_ADDRESS:PORT:SERVICE" \
--username "username"  \
--password "password" \
--query "select  NAME,salary,to_char(BIRTHDATE
,'YYYY-MM-DD HH:MM:SS') 
 from EMPLOYEE where \$CONDITIONS" \
--split-by "to_number(to_char(BIRTHDATE,'YYYYMMDD'))" \
--boundary-query "SELECT 19600501,to_number(to_char( LAST_DAY( CAST( '01-MAY-1960' AS varchar2(30) )) ,'YYYYMMDD' ))  FROM DUAL" \
--num-mappers 31 \
--map-column-java NAME=String \
--target-dir "/EMPLOYEES_STAGING/" 

some of the mappers are getting empty data for name and birthdate but the salary is being written by all the mappers, how can I make all the mappers write the same results [name, salary and birthdate]?

 

1 REPLY 1
Highlighted

tRe: Sqoop import some mappers not getting data

Champion

Could you share if possible your mapreduce logs

and turn on  --verbose in your import