Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-501

Drill fails to parse absolute value "@" in query

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Invalid
    • 1.0.0
    • 0.4.0
    • Functions - Drill
    • None

    Description

      Ran the following query:
      select @(gpa - rownum) from student where rownum=10;

      Got the following error:
      Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "727a0a12-44b5-4d51-aeb2-533543029e6b"
      endpoint {
      address: "qa-node57.qa.lab"
      user_port: 31010
      control_port: 31011
      data_port: 31012
      }
      error_type: 0
      message: "Failure while parsing sql. < SqlParseException:[ Lexical error at line 1, column 8. Encountered: \"@\" (64), after : \"\" ] < TokenMgrError:[ Lexical error at line 1, column 8. Encountered: \"@\" (64), after : \"\" ]"
      ]

      Attachments

        1. student.parquet
          63 kB
          Krystal

        Activity

          People

            jnadeau Jacques Nadeau
            knguyen Krystal
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: