[DRILL-2584] Hbase : When we select an individual column from hbase, drill is ignoring the rows with null values

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.8.0
• Fix Version/s: Future
• Component/s: Storage - HBase
• Assignee: Unassigned
• Reporter: Rahul Kumar Challapalli
• Created: 26/Mar/15 21:06
• Updated: 01/Oct/15 16:38

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