看起来 Spark SQL 对 "like" 查询是大小写敏感的,对吗?
spark.sql("select distinct status, length(status) from table")
返回
Active|6
spark.sql("select distinct status from table where status like '%active%'")
返回无值
spark.sql("select distinct status from table where status like '%Active%'")
返回
Active