You are viewing a plain text version of this content. The canonical link for it is here.
Posted to reviews@spark.apache.org by GitBox <gi...@apache.org> on 2020/06/23 03:00:30 UTC
[GitHub] [spark] beliefer commented on pull request #26875: [SPARK-30245][SQL] Add cache for Like and RLike when pattern is not static
beliefer commented on pull request #26875:
URL: https://github.com/apache/spark/pull/26875#issuecomment-647877651
@ulysses-you I'm sorry! I lost some thing.
---- test 1 ----
```
val df1 = spark.range(0, 20000, 1, 200).selectExpr("uuid() as c1")
val df2 = spark.range(0, 20000, 1, 200).selectExpr("uuid() as c2")
val start = System.currentTimeMillis
df1.join(df2).where("c2 like c1").count()
// 3 times test
// before 159228, 157541, 157721
// after 14378, 11545, 11498
println(System.currentTimeMillis - start)
```
---- test3 ----
```
val df1 = spark.range(0, 20000, 1, 200).selectExpr("uuid() as c1")
val df2 = spark.range(0, 20000, 1, 200).selectExpr("uuid() as c2")
val start = System.currentTimeMillis
df1.join(df2).where("c1 like c2").count()
// 3 times test
// before 159226, 159147, 159587
// after 159641, 160960, 160091
println(System.currentTimeMillis - start)
```
Why is test1 and test3 so different in time?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org