@Lester Martin What are the algorithms are used in sqoop while importing data? Thanks in Advance! Dada Karade ... View more

Hi @Roberto Sancho sqoop import -D oraoop.disabled=true \ --connect jdbc:oracle:thin:@HOSTNAME:2521/CIP_BATCH \ --username=U029550 \ --password=Mayo2016 \ --query "SELECT ID_INTERNO_PE,MI_FECHA_FIN_MES,COD_NRBE_EN,COD_LINEA,ID_GRP_PD,MI_NUM_TOT_AC_ACT,MI_NUM_AC_SUS,MI_SDO_AC_P,MI_NUM_AC_P,MI_DIA_AC_P,MI_INT_DEV_ACR_D,MI_INT_DEV_DEU_D,MI_COMIS_APL_D,MI_TOT_MOV_D,MI_TOT_MOV_H,MI_TOT_IMP_MOV_D,MI_TOT_IMP_MOV_ FROM RDWC01.MI_CLTE_ECO_GEN WHERE \$CONDITIONS AND COD_RL_PERS_AC = 01 AND COD_LINEA in ('01','03','04','05') AND COD_NRBE_EN = '3159' AND TRUNC(MI_FECHA_FIN_MES) >=TO_DATE('2010-01-01', 'YYYY-MM-DD')" \ --split-by MI_NUM_TOT_AC_ACT \ --fetch-size=50000 This query works fine 🙂 ... View more

@Lester Martin Hi Lester, Thank you so much for your quick response. I liked your last line "Good luck and happy Hadooping!" will keep doing. Regards, Dada Karade ... View more