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

SUBSTRING function with regex pattern fails to parse.

    Details

    • Type: New Feature
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: Future
    • Component/s: Functions - Drill
    • Labels:
      None

      Description

      SUBSTRING(string from pattern) function fails to execute. For example:

      select substring(name from '^.....') from voter where age < 20;

      message: "Failure while parsing sql. < ValidationException:[ org.eigenbase.util.EigenbaseContextException: From line 1, column 8 to line 1, column 36 ] < EigenbaseContextException:[ From line 1, column 8 to line 1, column 36 ] < SqlValidatorException:[ Cannot apply 'SUBSTRING' to arguments of type 'SUBSTRING(<ANY> FROM <CHAR(6)>)'. Supported form(s): 'SUBSTRING(<CHAR> FROM <INTEGER>)'
      'SUBSTRING(<CHAR> FROM <INTEGER> FOR <INTEGER>)'
      'SUBSTRING(<VARCHAR> FROM <INTEGER>)'
      'SUBSTRING(<VARCHAR> FROM <INTEGER> FOR <INTEGER>)'
      'SUBSTRING(<BINARY> FROM <INTEGER>)'
      'SUBSTRING(<BINARY> FROM <INTEGER> FOR <INTEGER>)'
      'SUBSTRING(<VARBINARY> FROM <INTEGER>)'
      'SUBSTRING(<VARBINARY> FROM <INTEGER> FOR <INTEGER>)' ]"
      ]

      Same error for the following test queries:
      select substring(name from 's.n$') from student where rownum=105;
      select substring(name from '^[A-Z].*$') from voter where rownum=15;

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated: