Details
-
Sub-task
-
Status: Resolved
-
Major
-
Resolution: Duplicate
-
3.4.0
-
None
-
None
Description
https://github.com/apache/spark/runs/6912247429?check_suite_focus=true
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
Attachments
Issue Links
- duplicates
-
-
- Resolved
-