如何将pythonDataframe加载到cloudera impala?

jjhzyzn0  于 2021-06-26  发布在  Impala
关注(0)|答案(1)|浏览(344)

将dataframe数据加载到impala表时出错

DB = conn.cursor()
for row in fourth_set:
    SQL = ('''Insert into Boots_retailer(sale_date, product, Assessment, weekno, store_Number, volume, turnover, turnover_missing, Inv_Cubic, XGB, KNN) 
    values(?,?,?,?,?,?,?,?,?,?,?)''' )

    Values = row['Sale_date'], row['product'], row['Assessment'], row['weekno'],row['store_number'],
    row['volume'],row['turnover'],row['turnover_missing'],row['Inv_Cubic'],row['XGB'],row['KNN']

    har =  DB.execute(SQL, Values)
    connection.commit()

错误在线 Values = row['Sale_date'], ... :

TypeError: string indices must be integers, not str
vxbzzdmp

vxbzzdmp1#

得到typeerror是因为您在遍历行的标签,而不是行本身。将第二行替换为

for _, row in fourth_set.iterrows():

相关问题