zip

{
  "source": [
  {
      "type": "oracle",
      "host": "oraqboprpt.qcyf01.ie.intuit.net",
      "port": "1521",
      "database": "qborpt",
      "user": "ds_ued_app",
      "password": "",
      "url": "jdbc:oracle:thin:@//oraqboprpt.qcyf01.ie.intuit.net:1521/qboprpt",
      "driver": "oracle.jdbc.OracleDriver"
    }
],
  "target": [
    {
      "type": "hive 2",
      "host": "pprdda1hg303.corp.intuit.net",
      "user": "sys_bio_replicator@CORP.INTUIT.NET",
      "password": "",
      "database": "ued_qborpt_kb_r3d3_dwh",
      "url": "jdbc:hive2://pprdda2hn302.corp.intuit.net:10000/ued_qborpt_kb_r3d3_dwh;principal=hive/pprdda2hn302.corp.intuit.net@CORP.INTUIT.NET?mapred.job.queue.name=exp_dsa"
    }
  ],
  "testName": "R3D3_Oracle_Hive_Comparision",
  "tests": [
    "count",
    "data"
  ],
  "fetchAmount": 10,
  "testType": "adhoc",
  "adhoc": [
    {
      "source" : "SELECT EXPERIMENT_ID AS AAAA_EXPERIMENT_ID,ACTIVATION_DATE AS ACTIVATION_DATE,CELL_COUNT AS CELL_COUNT,CELL_RATES AS CELL_RATES,CELL_SELECTOR AS CELL_SELECTOR,CONFIG_PROPERTY_IDENTIFIER AS CONFIG_PROPERTY_IDENTIFIER,CREATE_DATE AS CREATE_DATE,DATACENTER_ID AS DATACENTER_ID,DEFERRED AS DEFERRED,DESCRIPTION AS DESCRIPTION,EXPERIMENT_GROUP AS EXPERIMENT_GROUP,EXPERIMENT_NAME AS EXPERIMENT_NAME,EXPIRY_DATE AS EXPIRY_DATE,FILTER_CRITERIA AS FILTER_CRITERIA,LAST_MODIFY_DATE AS LAST_MODIFY_DATE,PARTICIPATION_RATE AS PARTICIPATION_RATE,STATUS AS STATUS FROM qborpt.experimentconfig WHERE REC_MOD_DBTIME_UTC >= to_timestamp('__ORACLE_FROM_DATE__', 'dd-mm-yyyy hh24:mi:ss') and REC_MOD_DBTIME_UTC <= to_timestamp('__ORACLE_TO_DATE__', 'dd-mm-yyyy hh24:mi:ss')",
      "target" : "SELECT experiment_id AS AAAA_EXPERIMENT_ID,activation_date AS activation_date,cell_count AS cell_count,cell_rates AS cell_rates,cell_selector AS cell_selector,config_property_identifier AS config_property_identifier,create_date AS create_date,datacenter_id AS datacenter_id,deferred AS deferred,description AS description,experiment_group AS experiment_group,experiment_name AS experiment_name,expiry_date AS expiry_date,filter_criteria AS filter_criteria,last_modify_date AS last_modify_date,participation_rate AS participation_rate,status AS status FROM ued_qborpt_kb_r3d3_dwh.experimentconfig WHERE unix_timestamp(REC_MOD_DBTIME_UTC) >= unix_timestamp('__HIVE_FROM_DATE__')  and unix_timestamp(REC_MOD_DBTIME_UTC) <= unix_timestamp('__HIVE_TO_DATE__')"
    }
  ]
}