Spark SQL - 类似忽略大小写 [英] Spark SQL - rlike ignore case

问题描述

我正在使用 spark SQL 并尝试使用 rlike 比较字符串它工作正常，但是想了解如何忽略大小写.

I am using spark SQL and trying to compare a string using rlike it works fine, however would like to understand how to ignore case.

这个返回true

select "1 Week Ending Jan 14, 2018" rlike "^\\d+ Week Ending [a-z, A-Z]{3} \\d{2}, \\d{4}"

然而，这返回 False，

select "1 Week Ending Jan 14, 2018" rlike "^\\d+ week ending [a-z, A-Z]{3} \\d{2}, \\d{4}"

推荐答案

Spark 使用标准 Scala 正则表达式库，因此您可以在模式中内联处理标志，例如 (?i)不区分大小写:

Spark is using the standard Scala regex library, so you can inline the processing flags in the pattern, for example (?i) for case-insensitive:

spark.sql("""select "1 Week Ending Jan 14, 2018" rlike "(?i)^\\d+ week ending [a-z, A-Z]{3} \\d{2}, \\d{4}"""").show()
+--------------------------------------------------------------------------------+
|1 Week Ending Jan 14, 2018 RLIKE (?i)^\d+ week ending [a-z, A-Z]{3} \d{2}, \d{4}|
+--------------------------------------------------------------------------------+
|                                                                            true|
+--------------------------------------------------------------------------------+

这篇关于Spark SQL - 类似忽略大小写的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！