Details

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

      Description

      Ran the following query:
      select div(120,7) div from dfs.`voter` where rownum=10;

      Got the following error:
      0: jdbc:drill:schema=dfs> select div(120,7) div from dfs.`voter` where rownum=10;
      Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "40a9c83e-188a-4735-9a34-3675b320fd43"
      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 17 ] < EigenbaseContextException:[ From line 1, column 8 to line 1, column 17 ] < SqlValidatorException:[ No match found for function signature div(<NUMERIC>, <NUMERIC>) ]"
      ]
      Error: exception while executing query (state=,code=0)

        Activity

        Hide
        Krystal added a comment -

        Verified that div function no longer fails with parse error.

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

        Seems to be fixed as part of the work for p1 functions.

        0: jdbc:drill:zk=local> select div(120,7) from dfs.`/Users/mbaid/data/voter.parquet` limit 1;
        ------------

        EXPR$0

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

        17

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

        Show
        Mehant Baid added a comment - Seems to be fixed as part of the work for p1 functions. 0: jdbc:drill:zk=local> select div(120,7) from dfs.`/Users/mbaid/data/voter.parquet` limit 1; ------------ EXPR$0 ------------ 17 ------------

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development