return query_sql if __name__ == "__main__": if not get_argv(sys.argv): sys.exit(1) dbConfig = sys.argv[1] PROJECT_NAME = sys.argv[2] etlDate = sys.argv[3] businessReadyTime = sys.argv[4] whereCondition = sys.argv[5] qp_dt = etl_utils.setETLDate(etlDate) print qp_dt + "::::::::::::::::::::::::::::::" (sqoop_dic, hiveDic) = etl_utils.buildConfDics(dbConfig, "N", "etl_dt", qp_dt, buildQuerySql) now_time = datetime.datetime.now() run_time = now_time.strftime('%Y%m%d %H:%M:%S') etl_checkdata.check_data(dbConfig, qp_dt, run_time, "", "source", 1) flag = etl_utils.execimport(sqoop_dic) print "=========== sqoop flag :", flag if flag != 0: exit(flag) flag = etl_utils.loadData2HiveTable(hiveDic) if flag == 0: etl_checkdata.check_data(dbConfig, qp_dt, run_time, "", "target", "")
importType = jsonobj["sqoop.import-type"] query_template = sqoop_import_sqlDic[importType] qp_dtStr = "'%s'"%(qp_dt,) query_sql = query_template%(colsStr,tableName) print "query_sql:" + query_sql return query_sql if __name__ == "__main__": if not get_argv(sys.argv): sys.exit(1) dbConfig = sys.argv[1] PROJECT_NAME = sys.argv[2] etlDate = sys.argv[3] businessReadyTime = sys.argv[4] qp_dt=etl_utils.setETLDate(etlDate) print qp_dt+ "::::::::::::::::::::::::::::::" (sqoop_dic,hiveDic) = etl_utils.buildConfDics(dbConfig,"N","etl_dt",qp_dt,buildQuerySql) flag = etl_utils.execimport(sqoop_dic) print "=========== sqoop flag :", flag # if flag != 0: exit(flag) # flag = etl_utils.loadData2HiveTableAllDeleteAllInsert(hiveDic)