[jira] [Created] (DRILL-1213) Casting to decimal on text files is not working

["Rahul Challapalli (JIRA)" <ji...@apache.org>]

Rahul Challapalli created DRILL-1213:
----------------------------------------

             Summary: Casting to decimal on text files is not working
                 Key: DRILL-1213
                 URL: https://issues.apache.org/jira/browse/DRILL-1213
             Project: Apache Drill
          Issue Type: Bug
          Components: Functions - Drill, Storage - Text & CSV
            Reporter: Rahul Challapalli


git.commit.id.abbrev=caa8b78

USING DECIMAL :
create view cast_dec as select cast(columns[0] as decimal(10,5)) from `temp.tbl`;

select * from cast_dec;
+------------+
|   EXPR$0   |
+------------+
| 0          |
| 0          |
+------------+


USING DOUBLE :
create view cast_dbl as select cast(columns[0] as double) from `temp.tbl`;

select * from cast_dbl;
+------------+
|   EXPR$0   |
+------------+
| 0.01       |
| 0.05       |
+------------+


I attached the text file used. 



--
This message was sent by Atlassian JIRA
(v6.2#6252)