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. Correct.drill
          6 kB
          Kumiko Yada
        2. Incorrect.drill
          6 kB
          Kumiko Yada
        3. table1.png
          30 kB
          Kumiko Yada
        4. Table2.png
          41 kB
          Kumiko Yada
        5. table3.png
          30 kB
          Kumiko Yada
        6. table4.png
          39 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: