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

    • Bug
    • Status: Resolved
    • Critical
    • Resolution: Fixed
    • 0.8.0
    • 0.8.0
    • Storage - HBase
    • None
    • 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

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

            Dates

              Created:
              Updated:
              Resolved: