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

Hbase : When we select an individual column from hbase, drill is ignoring the rows with null values

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 0.8.0
    • Fix Version/s: Future
    • Component/s: Storage - HBase
    • Labels:
      None

      Description

      git.commit.id.abbrev=4d398ed

      select cast(cast(a.types.int_col as varchar(100)) as int) int_col from fewtypes_null a; 
      +------------+
      |  int_col   |
      +------------+
      | 1          |
      | 10         |
      | 12         |
      | 13         |
      | 14         |
      | 15         |
      | 16         |
      | 18         |
      | 20         |
      | 3          |
      | 4          |
      | 5          |
      | 6          |
      | 7          |
      | 8          |
      | 9          |
      +------------+
      

      Drill did not return the 4 rows where this column was null. This is inconsistent with rest of drill.

      I attached the csv text file and the dataload script that I used. Let me know if you have any questions

        Attachments

        1. fewtypes_null_hbase.tbl
          2 kB
          Rahul Kumar Challapalli
        2. dataload.hql
          1 kB
          Rahul Kumar Challapalli

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              rkins Rahul Kumar Challapalli
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: