Looks like spark sql is case sensitive for "like" queries, right ?
spark.sql("select distinct status, length(status) from table")
Returns
Active|6
spark.sql("select distinct status from table where status like '%active%'")
Returns no value
spark.sql("select distinct status from table where status like '%Active%'")
Returns
Active