def buildQuerySql(jsonobj,qp_dt):
importType = jsonobj["sqoop.import-type"]
if importType == "inc":
tableName=etl_utils.buildSrcTableName(jsonobj)
(colsStr,joinColumns,keyColumns) = etl_utils.buildComlunmnsStrForInit(jsonobj)
importType = jsonobj["sqoop.import-type"]
query_template = sqoop_import_sqlDic[importType]
qp_dtStr = "'%s'"%(qp_dt,)
query_sql = query_template%(qp_dtStr,colsStr,tableName)
print "query_sql:" + query_sql
return query_sql
def buildQuerySql(jsonobj):
importType = jsonobj["sqoop.import-type"]
if importType == "inc":
tableName=jsonobj["db.table_name"]
(colsStr,joinColumns,keyColumns) = etl_utils.buildComlunmnsStrForInit(jsonobj)
importType = jsonobj["sqoop.import-type"]
query_template = sqoop_import_sqlDic[importType]
query_sql = query_template%(colsStr,tableName)
print "query_sql:" + query_sql
return query_sql
def buildQuerySql(jsonobj):
importType = jsonobj["sqoop.import-type"]
if importType == "inc":
tableName = jsonobj["db.table_name"]
(colsStr, joinColumns,
keyColumns) = etl_utils.buildComlunmnsStrForInit(jsonobj)
importType = jsonobj["sqoop.import-type"]
query_template = sqoop_import_sqlDic[importType]
query_sql = query_template % (colsStr, tableName)
print "query_sql:" + query_sql
return query_sql