We have a problem where a Drill query against HBase does not return all results. The following query should return over 100,000 rows, but we only get about 1,030 back.
SELECT row_key FROM `hbase`.`customer_staged` WHERE customer_number = 800 If we scan directly using the hbase shell we see over 100,000 rows, but the same Drill query does not return a fraction of the expected results. We have also run a count against the table and Drill returns the same 1,030 number, which is far less than expect. What could be going wrong? We are running Drill 1.2 on Ubuntu 14.04 against CDH 5.4.3 (HBase 1.0). We run HBase on six RegionServers, the table has about 1.3 billion rows. Thanks, Kevin
