且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何使用Sparklyr过滤部分匹配

更新时间:2023-02-15 20:01:51

与标准Spark相同,您可以使用rlike(Java正则表达式):

The same as in standard Spark, you can use either rlike (Java regular expressions):

df <- copy_to(sc, iris) 

df %>% filter(rlike(Species, "osa"))

# or anchored
df %>% filter(rlike(Species, "^.*osa.*$")

like(简单的SQL正则表达式):

or like (simple SQL regular expressions):

df %>% filter(like(Species, "%osa%"))

这两种方法也都可以使用后缀表示法

Both methods can be also used with suffix notation as

df %>% filter(Species %rlike%  "^.*osa.*$")

df %>% filter(Species %like% "%osa%")

分别.

有关详细信息,请参见vignette("sql-translation").

For details see vignette("sql-translation").