[jira] [Created] (DRILL-1430) sum(cast(columns[0] as int)) fails if column contains empty value

["Chun Chang (JIRA)" <ji...@apache.org>]

Chun Chang created DRILL-1430:
---------------------------------

             Summary: sum(cast(columns[0] as int)) fails if column contains empty value
                 Key: DRILL-1430
                 URL: https://issues.apache.org/jira/browse/DRILL-1430
             Project: Apache Drill
          Issue Type: Bug
          Components: Execution - Data Types
    Affects Versions: 0.6.0
            Reporter: Chun Chang


code base
#Fri Sep 12 14:08:02 PDT 2014
git.commit.id.abbrev=9e16466

I have a simple tsv file that contains an empty row in one of the columns:

[root@qa-node120 tmp]# hadoop fs -cat /user/root/mondrian/tmp.tbl
1|1
2|2
|3
4|4

0: jdbc:drill:schema=dfs> select * from `tmp.tbl`;
+------------+
|  columns   |
+------------+
| ["1","1"]  |
| ["2","2"]  |
| ["","3"]   |
| ["4","4"]  |
+------------+
4 rows selected (0.183 seconds)
0: jdbc:drill:schema=dfs> select columns[0], columns[1] from `tmp.tbl`;
+------------+------------+
|   EXPR$0   |   EXPR$1   |
+------------+------------+
| 1          | 1          |
| 2          | 2          |
|            | 3          |
| 4          | 4          |
+------------+------------+
4 rows selected (0.217 seconds)

sum over the column that is full works fine, but sum over the column that contains empty row fails:

0: jdbc:drill:schema=dfs> select sum(cast(columns[1] as int)) from `tmp.tbl`;
+------------+
|   EXPR$0   |
+------------+
| 10         |
+------------+
1 row selected (0.283 seconds)
0: jdbc:drill:schema=dfs> select sum(cast(columns[0] as int)) from `tmp.tbl`;
Query failed: Failure while running fragment.  [a9d8771f-aeb3-4226-9623-fc2b635365f8]

Error: exception while executing query: Failure while trying to get next result batch. (state=,code=0)
0: jdbc:drill:schema=dfs>

drillbit.log
11:44:19.450 [9d14d90c-128c-4549-b77f-9b0051bc3d5c:frag:0:0] DEBUG o.a.d.e.w.fragment.FragmentExecutor - Error while initializing or executing fragment
java.lang.NumberFormatException:
        at org.apache.drill.exec.test.generated.ProjectorGen18.doEval(ProjectorTemplate.java:40) ~[na:na]
        at org.apache.drill.exec.test.generated.ProjectorGen18.projectRecords(ProjectorTemplate.java:64) ~[na:na]





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)