hive 到oracle,hive表增量抽取到oracle数据库的通用程序(二)

${jobTracker}

${nameNode}

${hive_site_path}

mapred.job.queue.name

${queueName}

tmp_table=tmp_dm_xxx_day

params_dt=${params_dt}

${jobTracker}

${nameNode}

mapred.job.queue.name

${queueName}

com.exe.Hive2RMDS

--hive_url

jdbc:hive2://xx.xx.xx.xx:10000/default

--hive_hql

select field1,field2,field3,dim,period,period_value from dw_dm.dm_xxx where period = 'day' and period_value = ${params_dt}

--rdms_driver

oracle.jdbc.driver.OracleDriver

--rdms_url

jdbc:oracle:thin:@xx.xx.xx.xx:1521:test001

--rdms_username

DW_test

--rdms_password

DW_test

--rdms_tableName

DW_DM.DM_xxx_TEST

--rdms_columnNames

field1,field2,field3,dim,period,period_value

--rdms_presql

delete from DW_DM.DM_xxx_TEST where period = 'day' and period_value = '${params_dt}'

xxx@qq.com

${job_name} log error in ${params_dt}

workflow: ${wf:id()}, error message[${wf:errorMessage(wf:lastErrorNode())}]