Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.4.0
    • Component/s: Functions - Drill
    • Labels:
      None

      Description

      Drill fails to parse query with ROUND function:
      0: jdbc:drill:schema=dfs> select round(10.34) as col from dfs.`voter` where rownum = 10;
      Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "b098032a-6b6c-4720-8326-08f69210ec08"
      endpoint

      { address: "qa-node57.qa.lab" user_port: 31010 control_port: 31011 data_port: 31012 }

      error_type: 0
      message: "Failure while parsing sql. < ValidationException:[ org.eigenbase.util.EigenbaseContextException: From line 1, column 8 to line 1, column 19 ] < EigenbaseContextException:[ From line 1, column 8 to line 1, column 19 ] < SqlValidatorException:[ No match found for function signature round(<NUMERIC>) ]"
      ]
      Error: exception while executing query (state=,code=0)

        Activity

        Hide
        Krystal added a comment -

        Verified that round function no longer fails with parse error.

        Show
        Krystal added a comment - Verified that round function no longer fails with parse error.
        Hide
        Mehant Baid added a comment -

        Seems its fixed as part of p1 functions.
        select round(10.34) from dfs.`/tmp/input.json`;
        ------------

        EXPR$0

        ------------

        10.0

        ------------

        Show
        Mehant Baid added a comment - Seems its fixed as part of p1 functions. select round(10.34) from dfs.`/tmp/input.json`; ------------ EXPR$0 ------------ 10.0 ------------

          People

          • Assignee:
            Krystal
            Reporter:
            Krystal
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development