代码:
vol_union = vol_union.join(cons_data[['meter_id', 'cons_sort_code','tg_no','cons_id']],vol_union['ID'] == cons_data['meter_id'],how = 'left')
报错:
AnalysisException: u'Detected implicit cartesian product for LEFT OUTER join between logical plans
排查错误:数据表vol_union和表cons_data都有’meter_id’字段,把表vol_union中’meter_id’字段改为“meter_id1",再次运行代码,OK!