You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Bruce Robbins (Jira)" <ji...@apache.org> on 2022/06/20 17:05:00 UTC

[jira] [Resolved] (SPARK-39523) JDBCV2Suite fails with Scala 2.13

     [ https://issues.apache.org/jira/browse/SPARK-39523?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Bruce Robbins resolved SPARK-39523.
-----------------------------------
    Resolution: Fixed

> 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 [info] JDBCV2Suite:
> 2022-06-16T05:17:07.8681328Z [info] - simple scan (683 milliseconds)
> 2022-06-16T05:17:08.0647041Z [info] - TABLESAMPLE (integer_expression ROWS) is the same as LIMIT (197 milliseconds)
> 2022-06-16T05:17:09.4767958Z [info] - simple scan with LIMIT (1 second, 410 milliseconds)
> 2022-06-16T05:17:11.7543330Z [info] - simple scan with top N (2 seconds, 278 milliseconds)
> 2022-06-16T05:17:12.0522529Z [info] - simple scan with top N: order by with alias (296 milliseconds)
> 2022-06-16T05:17:13.4407631Z [info] - scan with filter push-down (1 second, 387 milliseconds)
> 2022-06-16T05:17:14.2278955Z [info] - scan with filter push-down with ansi mode *** FAILED *** (771 milliseconds)
> 2022-06-16T05:17:14.2280193Z [info]   "== Parsed Logical Plan ==
> 2022-06-16T05:17:14.2281557Z [info]   'Filter ('ceil('dept) > 1)
> 2022-06-16T05:17:14.2282508Z [info]   +- Filter (FLOOR(cast(dept#x as double)) > cast(1 as bigint))
> 2022-06-16T05:17:14.2283876Z [info]      +- Filter (SQRT(cast(salary#x as double)) > cast(100 as double))
> 2022-06-16T05:17:14.2285029Z [info]         +- Filter (POWER(cast(dept#x as double), 2.0) > cast(4 as double))
> 2022-06-16T05:17:14.2286384Z [info]            +- Filter (EXP(cast(salary#x as double)) > cast(2000 as double))
> 2022-06-16T05:17:14.2287456Z [info]               +- Filter (ln(cast(dept#x as double)) > cast(1 as double))
> 2022-06-16T05:17:14.2288659Z [info]                  +- SubqueryAlias h2.test.employee
> 2022-06-16T05:17:14.2289800Z [info]                     +- RelationV2[DEPT#x, NAME#x, SALARY#x, BONUS#x, IS_MANAGER#x] test.employee
> 2022-06-16T05:17:14.2290906Z [info]   
> 2022-06-16T05:17:14.2291970Z [info]   == Analyzed Logical Plan ==
> 2022-06-16T05:17:14.2293406Z [info]   DEPT: int, NAME: string, SALARY: decimal(20,2), BONUS: double, IS_MANAGER: boolean
> 2022-06-16T05:17:14.2294514Z [info]   Filter (CEIL(cast(dept#x as double)) > cast(1 as bigint))
> 2022-06-16T05:17:14.2295824Z [info]   +- Filter (FLOOR(cast(dept#x as double)) > cast(1 as bigint))
> 2022-06-16T05:17:14.2296820Z [info]      +- Filter (SQRT(cast(salary#x as double)) > cast(100 as double))
> 2022-06-16T05:17:14.2298229Z [info]         +- Filter (POWER(cast(dept#x as double), 2.0) > cast(4 as double))
> 2022-06-16T05:17:14.2299375Z [info]            +- Filter (EXP(cast(salary#x as double)) > cast(2000 as double))
> 2022-06-16T05:17:14.2300675Z [info]               +- Filter (ln(cast(dept#x as double)) > cast(1 as double))
> 2022-06-16T05:17:14.2301769Z [info]                  +- SubqueryAlias h2.test.employee
> 2022-06-16T05:17:14.2303225Z [info]                     +- RelationV2[DEPT#x, NAME#x, SALARY#x, BONUS#x, IS_MANAGER#x] test.employee
> 2022-06-16T05:17:14.2304162Z [info]   
> 2022-06-16T05:17:14.2305235Z [info]   == Optimized Logical Plan ==
> {code}



--
This message was sent by Atlassian Jira
(v8.20.7#820007)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org