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

        Tony Stevenson made changes -
        Workflow no-reopen-closed, patch-avail, testing [ 12860027 ] Drill workflow [ 12933591 ]
        Jacques Nadeau made changes -
        Fix Version/s 0.4.0 [ 12324963 ]
        Krystal made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Mehant Baid made changes -
        Assignee Krystal [ knguyen ]
        Mehant Baid made changes -
        Component/s Functions - Drill [ 12322695 ]
        Jake Farrell made changes -
        Field Original Value New Value
        Workflow no-reopen-closed, patch-avail [ 12856053 ] no-reopen-closed, patch-avail, testing [ 12860027 ]
        Krystal created issue -

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development