Apache Drill
  1. Apache Drill
  2. DRILL-720

LENGTH(string bytea, encoding name) function fails to execute

    Details

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

      Description

      The LENGTH(string bytea, encoding name) function fails with the following error:

      select length('\x6170706c65','UTF8') from voter where voter_id=10;

      Query failed: org.apache.drill.exec.rpc.RpcException: [error_id: "92a9be62-c2a6-44aa-a0f6-c0185abde201"
      endpoint

      { user_port: 31010 control_port: 31011 data_port: 31012 }

      error_type: 0
      message: "Screen received stop request sent. < SchemaChangeException:[ Failure while trying to materialize incoming schema. Errors:

      Error in expression at index 1. Error: Missing function implementation: [lengthUtf8(VARCHAR-REQUIRED)]. Full expression: --UNKNOWN EXPRESSION-.. ]"

        Activity

        Hide
        Krystal added a comment -

        Postgres implicitly converts the string to bytea.

        Show
        Krystal added a comment - Postgres implicitly converts the string to bytea.
        Hide
        Jacques Nadeau added a comment -

        fixed at or before 4198a17

        Show
        Jacques Nadeau added a comment - fixed at or before 4198a17
        Hide
        Jacques Nadeau added a comment -

        fixed within 4198a17~21

        Show
        Jacques Nadeau added a comment - fixed within 4198a17~21
        Hide
        Krystal added a comment -

        git.commit.id.abbrev=894037a

        Verified that bug is fixed. Besides working with bytea string as parameter, a user can also enter plain text string.

        Show
        Krystal added a comment - git.commit.id.abbrev=894037a Verified that bug is fixed. Besides working with bytea string as parameter, a user can also enter plain text string.

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development