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/"