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)
