是的,Spark区分大小写。对于字符串比较,大多数RDBMS默认区分大小写。如果您想要不区分大小写,请尝试rlike或将列转换为大写/小写。
scala> val df = Seq(("Active"),("Stable"),("Inactive")).toDF("status")
df: org.apache.spark.sql.DataFrame = [status: string]
scala> df.createOrReplaceTempView("tbl")
scala> df.show
status
Active
Stable
Inactive
scala> spark.sql(""" select status from tbl where status like '%Active%' """).show
status
Active
scala> spark.sql(""" select status from tbl where lower(status) like '%active%' """).show
status
Active
Inactive
scala>
2019-07-17 23:18:22
企业邮箱发送邮件时,若出现投递失败产生退信,内容提示包含如下: the mta server of * reply:550 failed to meet SPF requirements 或者 the mta server of 163.com — 163mx01.mxmail.netease.com(220.181.14.141) reply:550 MI:SPF mx14,QMCowECpA0qTiftVaeB3Cg—.872S2 1442548128 http://mail.163.com/help
302743