pt拼接到字符串后是一个字符,正确写法应该为:
def updateDatabase(dbname,tbname,start_time,end_time,update_factor,symbol_name){
num_row = exec count(*) from loadTable(dbname,tbname) where tradetime>=start_time and tradetime<=end_time and symbol = symbol_name
script = "update loadTable("+'"'+dbname+'"'+','+'"'+tbname+'"'+')'+" set "+update_factor+" = rand(100.0,"+num_row+") where tradetime>= "+start_time+" and tradetime <= "+end_time+" and symbol = "+'"'+symbol_name+'"'
runScript(script)
}