1 results = ((1,2,3),(4,5,6)) 2 #因为hive insert 要求values 格式为 insert overwrite table term_dept_top_backup111 values(),()() 3 #所以我增加的其他代码是为了去除外面的“()” 4 n = 0 5 sql = "insert overwrite table term_dept_top_backup111 values " 6 for row in results: 7 n = n + 1 8 if n != len(results)+1: 9 sql = sql + "{}" 10 sql = sql.format(row) 11 if n != len(results): 12 sql = sql +‘,‘
原文:https://www.cnblogs.com/huangguoming/p/10482290.html