Hive2Oracle
#!/bin/sh sqoop export --table dw result_final --connect jdbc:oracle:thin:@//10.0.0.1:1521/testdb -username oracle_user --password oracle_password --export-dir /user/hive/warehouse/ads_hive.db/ads_result_final --columns dt,city,code,cname,loaddate --input-fields-terminated-by ' 01' --input-lines-terminated-by 'n' --input-null-string '\N' --input-null-non-string '\N'
Oracle2Hive
#!/bin/sh export HADOOP_CLASSPATH=/app/java/1ib/ojdbc6.jar:/app/cloudera/CDH-6.3.2/yarn-conf ConDITIONS='$CONDITIONS'; sqoop-import --connect jdbc:oracle:thin:@//10.0.0.1:1521/testdb -username oracle_user -password oracle_password -query " select dt ,code ,cname ,batchno ,loaddate from rep_excle.mp_input_tmp where $ConDITIONS " -m1 --null-string 'null' --null-non-string 'null' --fields-terminated-by ' 01' --lines-terminated-by'n' --target-dir /user/hive/warehouse/dim_hive.db/dim_mp_input_tmp --hive-database dim_hive --hive-table dim_mp_input_tmp --delete-target-dir;
Hive2MySQL
#!/bin/sh export HADOOP_CLASSPATH=/app/java/lib/mysql-connector-java-5.1.44.jar; --table order_data --connect jdbc:mysql://10.0.0.1:3306/testdb --username sys_user --password sys_password --hcatalog-database tmp_hive --hcatalog-table tmp_order_df --columns dt,code,number --input-fields-terminated-by ' 01' --input-lines-terminated-by 'n' --input-null-string '\N' --input-null-non-string '\N'
