我可以将dataframe join语句与single-on条件一起使用(在pyspark中),但是,如果我尝试添加多个条件,则它将失败。
代码:summary2 = summary.join(county_prop, ["category_id", "bucket"], how = "leftouter").
以上代码有效。但是,如果我为list添加一些其他条件,比如summary.bucket==9或其他内容,那么它将失败。请帮我解决这个问题。The error for the statement
summary2 = summary.join(county_prop, ["category_id", (summary.bucket)==9], how = "leftouter")
ERROR : TypeError: 'Column' object is not callable
编辑:
添加完整的工作示例。schema = StructType([StructField("category", StringType()), StructField("category_id", StringType()), StructField("bucket", StringType()), StructField("prop_count", StringType()), StructField("event_count", StringType()), StructField("accum_prop_count",StringType())])
bucket_summary = sqlContext.createDataFrame([],schema)
temp_county_prop = sqlContext.createDataFrame([("nation","nation",1,222,444,555),("nation","state",2,222,444,555)],schema)
bucket_summary = bucket_summary.unionAll(temp_county_prop)
county_prop = sqlContext.createDataFrame([("nation","state",2,121,221,551)],schema)
要在上进行联接:
category_id和bucket列,我想替换country_prop on bucket_summary的值。cond = [bucket_summary.bucket == county_prop.bucket, bucket_summary.bucket == 2]
bucket_summary2=bucket_summary.join(country_prop,cond,how=“leftouter”)1. It works if I mention the whole statement with cols, but if I list conditions like ["category_id", "bucket"] --- THis too works.
2. But, if I use a combination of both like cond =["bucket", bucket_summary.category_id == "state"]
它不起作用。这两种说法有什么问题?