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

    • Bug
    • Status: Resolved
    • Critical
    • Resolution: Duplicate
    • None
    • None
    • None
    • None
    • 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

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

              Dates

                Created:
                Updated:
                Resolved: