spark-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Felix Cheung <>
Subject Re: Static partitioning in partitionBy()
Date Wed, 08 May 2019 05:06:24 GMT
You could

df.filter(col(“c”) = “c1”).write().partitionBy(“c”).save

It could get some data skew problem but might work for you

From: Burak Yavuz <>
Sent: Tuesday, May 7, 2019 9:35:10 AM
To: Shubham Chaurasia
Cc: dev;
Subject: Re: Static partitioning in partitionBy()

It depends on the data source. Delta Lake ( allows you to do it with the
.option("replaceWhere", "c = c1"). With other file formats, you can write directly into the
partition directory (tablePath/c=c1), but you lose atomicity.

On Tue, May 7, 2019, 6:36 AM Shubham Chaurasia <<>>
Hi All,

Is there a way I can provide static partitions in partitionBy()?


Above code gives following error as it tries to find column `c=c1` in df.

org.apache.spark.sql.AnalysisException: Partition column `c=c1` not found in schema struct<a:string,b:string,c:string>;


View raw message