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