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

Drill query does not return all results from HBase when the Hbase contains more than 6 columns

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Critical
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:

      Drill 1.4, HBase 1.0.0, CDH 5.4

      Description

      Hbase `test1` contains 1 column family & 5 columns, 10000000 rows
      Hbase `test2` contains 1 column family & 6 columns, 10000000 rows

      Query: select count ( * ) from `hbase`.`test1`
      Result: 10000000 rows

      Query: select count ( * ) from `hbase`.`test2`
      Result: 6724 rows

      Note:
      Correct row count returned with the hbase table with 1 column family 5 or less columns

        Attachments

        1. table4.png
          39 kB
          Kumiko Yada
        2. table3.png
          30 kB
          Kumiko Yada
        3. Table2.png
          41 kB
          Kumiko Yada
        4. table1.png
          30 kB
          Kumiko Yada
        5. Incorrect.drill
          6 kB
          Kumiko Yada
        6. Correct.drill
          6 kB
          Kumiko Yada

          Issue Links

            Activity

              People

              • Assignee:
                adityakishore Aditya Kishore
                Reporter:
                kyada Kumiko Yada
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: