Log workAgile BoardRank to TopRank to BottomAttach filesAttach ScreenshotBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersConvert to IssueMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete CommentsDelete
    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Duplicate
    • 3.4.0
    • None
    • SQL
    • None

    Description

      https://github.com/apache/spark/runs/6912247429?check_suite_focus=true

      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 ==
      

      Attachments

        Issue Links

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            bersprockets Bruce Robbins Assign to me
            gurwls223 Hyukjin Kwon
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment