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

CONVERT_FROM in where clause cause the query to fail in planning phase

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 0.8.0
    • Fix Version/s: 0.8.0
    • Component/s: Storage - HBase
    • Labels:
      None
    • Environment:

      MapR Sandbox 4.0.2

      Description

      CONVERT_FROM used in predicate results in error like mentioned under. The drill log file with error is attached.
      0: jdbc:drill:> select CONVERT_FROM(t.row_key, 'INT') rk from maprdb.myLittleHBaseTable t where CONVERT_FROM(t.row_key, 'INT')=1001 limit 1;
      Query failed: IndexOutOfBoundsException: writerIndex(4) + minWritableBytes(4) exceeds maxCapacity(4): UnpooledHeapByteBuf(ridx: 0, widx: 4, cap: 4/4)
      Error: exception while executing query: Failure while executing query. (state=,code=0)

        Attachments

        1. DRILL-2567-CONVERT_FROM-in-where-clause-cause-the-qu.patch
          5 kB
          Aditya Kishore
        2. drill.log
          1.18 MB
          Sudhakar Thota

          Activity

            People

            • Assignee:
              adityakishore Aditya Kishore
              Reporter:
              sthota Sudhakar Thota
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: