list1 = spark.sql("""
select
name
, id
from aaa
""").collect()
for k in range(0,len(list1)):
name = list1[k][0]
id = list1[k][1]
print('id:' + id)
list1 = spark.sql("""
select
name
, id
from aaa
""").collect()
for k in range(0,len(list1)):
name = list1[k][0]
id = list1[k][1]
print('id:' + id)