oracle - sqoop import works with one table, but doesn't with the other -
i have 2 tables vb_b2b_inn_201611_201705_7 import adhoc_mn_client_inn_201611_201705 , evkuzmin_b2b_churn_ban_segment should go evkuzmin_b2b_churn_ban_segment.
the script in both cases
sqoop import \ -dmapreduce.job.queuename=adhoc \ --connect jdbc:oracle:thin:secret/secret@//biistst1:1521/uatr15 \ --table table_name-m 1 \ --target-dir /apps/hive/warehouse/arstel.db/directory\ --delete-target-dir \ --fields-terminated-by '\t' here replace table name oracle table name , directory hdfs directory. checked both tables in oracle, have data in them. still, importing vb_b2b_inn_201611_201705_7 works , evkuzmin_b2b_churn_ban_segment doesn't.
i don't error second table. just
info mapreduce.importjobbase: transferred 0 bytes in 38.2422 seconds (0 bytes/sec) info mapreduce.importjobbase: retrieved 0 records. and empty file in evkuzmin_b2b_churn_ban_segment directory.
didn't know had run commit; after inserting data in evkuzmin_b2b_churn_ban_segment first. after did worked.
Comments
Post a Comment