Pushdown filter not working with Varchar datatype

[asethia]

Hi,

In our code

spark.read
.format("com.databricks.spark.redshift")
.option("url","<<jdbc url>>")
.option("user","user")
.option("password","password")
.option("forward_spark_s3_credentials" -> "true")
.option("tempdir","<<s3 bucket>>")
.option("dbtable","schema.tablename")
.load()
.select("*")
.filter("FIELDNAME='N'")

The physical plan shows PushedFilters: []

Library version: com.databricks:spark-redshift_2.11:2.0.1
Spark Version : 2.4.4

Thanks

[asethia]

@gpanda70