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

Popular posts from this blog

python - Selenium remoteWebDriver (& SauceLabs) Firefox moseMoveTo action exception -

html - How to custom Bootstrap grid height? -

angular - Copying node modules to wwwroot AspNetCore -