Rahul Challapalli created DRILL-2584:
----------------------------------------
Summary: Hbase : When we select an individual column from hbase,
drill is ignoring the rows with null values
Key: DRILL-2584
URL: https://issues.apache.org/jira/browse/DRILL-2584
Project: Apache Drill
Issue Type: Bug
Components: Storage - HBase
Reporter: Rahul Challapalli
Assignee: Aditya Kishore
git.commit.id.abbrev=4d398ed
{code}
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 |
+------------+
{code}
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
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)