[
https://issues.apache.org/jira/browse/SPARK-39523?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17556468#comment-17556468
]
Bruce Robbins edited comment on SPARK-39523 at 6/20/22 5:03 PM:
----------------------------------------------------------------
As with the GeneratorFunctionsSuite and AdaptiveQueryExecSuite issues, when I
apply the propose fix for SPARK-39520 ([this
PR|https://github.com/apache/spark/pull/36925]), the issue resolves on my
laptop.
was (Author: bersprockets):
As with the GeneratorFunctionsSuite and AdaptiveQueryExecSuite issues, when I
apply the propose fix for SPARK-39520 (this PR), the issue resolves on my
laptop.
> JDBCV2Suite fails with Scala 2.13
> ---------------------------------
>
> Key: SPARK-39523
> URL: https://issues.apache.org/jira/browse/SPARK-39523
> Project: Spark
> Issue Type: Sub-task
> Components: SQL
> Affects Versions: 3.4.0
> Reporter: Hyukjin Kwon
> Priority: Major
>
> https://github.com/apache/spark/runs/6912247429?check_suite_focus=true
> {code}
> 2022-06-16T05:17:06.6922310Z [0m[[0m[0minfo[0m]
> [0m[0m[32mJDBCV2Suite:[0m[0m
> 2022-06-16T05:17:07.8681328Z [0m[[0m[0minfo[0m] [0m[0m[32m- simple
> scan (683 milliseconds)[0m[0m
> 2022-06-16T05:17:08.0647041Z [0m[[0m[0minfo[0m] [0m[0m[32m-
> TABLESAMPLE (integer_expression ROWS) is the same as LIMIT (197
> milliseconds)[0m[0m
> 2022-06-16T05:17:09.4767958Z [0m[[0m[0minfo[0m] [0m[0m[32m- simple
> scan with LIMIT (1 second, 410 milliseconds)[0m[0m
> 2022-06-16T05:17:11.7543330Z [0m[[0m[0minfo[0m] [0m[0m[32m- simple
> scan with top N (2 seconds, 278 milliseconds)[0m[0m
> 2022-06-16T05:17:12.0522529Z [0m[[0m[0minfo[0m] [0m[0m[32m- simple
> scan with top N: order by with alias (296 milliseconds)[0m[0m
> 2022-06-16T05:17:13.4407631Z [0m[[0m[0minfo[0m] [0m[0m[32m- scan with
> filter push-down (1 second, 387 milliseconds)[0m[0m
> 2022-06-16T05:17:14.2278955Z [0m[[0m[0minfo[0m] [0m[0m[31m- scan with
> filter push-down with ansi mode *** FAILED *** (771 milliseconds)[0m[0m
> 2022-06-16T05:17:14.2280193Z [0m[[0m[0minfo[0m] [0m[0m[31m "== Parsed
> Logical Plan ==[0m[0m
> 2022-06-16T05:17:14.2281557Z [0m[[0m[0minfo[0m] [0m[0m[31m 'Filter
> ('ceil('dept) > 1)[0m[0m
> 2022-06-16T05:17:14.2282508Z [0m[[0m[0minfo[0m] [0m[0m[31m +- Filter
> (FLOOR(cast(dept#x as double)) > cast(1 as bigint))[0m[0m
> 2022-06-16T05:17:14.2283876Z [0m[[0m[0minfo[0m] [0m[0m[31m +-
> Filter (SQRT(cast(salary#x as double)) > cast(100 as double))[0m[0m
> 2022-06-16T05:17:14.2285029Z [0m[[0m[0minfo[0m] [0m[0m[31m +-
> Filter (POWER(cast(dept#x as double), 2.0) > cast(4 as double))[0m[0m
> 2022-06-16T05:17:14.2286384Z [0m[[0m[0minfo[0m] [0m[0m[31m
> +- Filter (EXP(cast(salary#x as double)) > cast(2000 as double))[0m[0m
> 2022-06-16T05:17:14.2287456Z [0m[[0m[0minfo[0m] [0m[0m[31m
> +- Filter (ln(cast(dept#x as double)) > cast(1 as double))[0m[0m
> 2022-06-16T05:17:14.2288659Z [0m[[0m[0minfo[0m] [0m[0m[31m
> +- SubqueryAlias h2.test.employee[0m[0m
> 2022-06-16T05:17:14.2289800Z [0m[[0m[0minfo[0m] [0m[0m[31m
> +- RelationV2[DEPT#x, NAME#x, SALARY#x, BONUS#x, IS_MANAGER#x]
> test.employee[0m[0m
> 2022-06-16T05:17:14.2290906Z [0m[[0m[0minfo[0m] [0m[0m [0m
> 2022-06-16T05:17:14.2291970Z [0m[[0m[0minfo[0m] [0m[0m[31m ==
> Analyzed Logical Plan ==[0m[0m
> 2022-06-16T05:17:14.2293406Z [0m[[0m[0minfo[0m] [0m[0m[31m DEPT: int,
> NAME: string, SALARY: decimal(20,2), BONUS: double, IS_MANAGER:
> boolean[0m[0m
> 2022-06-16T05:17:14.2294514Z [0m[[0m[0minfo[0m] [0m[0m[31m Filter
> (CEIL(cast(dept#x as double)) > cast(1 as bigint))[0m[0m
> 2022-06-16T05:17:14.2295824Z [0m[[0m[0minfo[0m] [0m[0m[31m +- Filter
> (FLOOR(cast(dept#x as double)) > cast(1 as bigint))[0m[0m
> 2022-06-16T05:17:14.2296820Z [0m[[0m[0minfo[0m] [0m[0m[31m +-
> Filter (SQRT(cast(salary#x as double)) > cast(100 as double))[0m[0m
> 2022-06-16T05:17:14.2298229Z [0m[[0m[0minfo[0m] [0m[0m[31m +-
> Filter (POWER(cast(dept#x as double), 2.0) > cast(4 as double))[0m[0m
> 2022-06-16T05:17:14.2299375Z [0m[[0m[0minfo[0m] [0m[0m[31m
> +- Filter (EXP(cast(salary#x as double)) > cast(2000 as double))[0m[0m
> 2022-06-16T05:17:14.2300675Z [0m[[0m[0minfo[0m] [0m[0m[31m
> +- Filter (ln(cast(dept#x as double)) > cast(1 as double))[0m[0m
> 2022-06-16T05:17:14.2301769Z [0m[[0m[0minfo[0m] [0m[0m[31m
> +- SubqueryAlias h2.test.employee[0m[0m
> 2022-06-16T05:17:14.2303225Z [0m[[0m[0minfo[0m] [0m[0m[31m
> +- RelationV2[DEPT#x, NAME#x, SALARY#x, BONUS#x, IS_MANAGER#x]
> test.employee[0m[0m
> 2022-06-16T05:17:14.2304162Z [0m[[0m[0minfo[0m] [0m[0m [0m
> 2022-06-16T05:17:14.2305235Z [0m[[0m[0minfo[0m] [0m[0m[31m ==
> Optimized Logical Plan ==[0m[0m
> {code}
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
