[DRILL-1213] Casting to decimal on text files is not working

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Component/s: Functions - Drill, Storage - Text & CSV
• Assignee: DrillCommitter
• Reporter: Rahul Kumar Challapalli
• Created: 28/Jul/14 20:21
• Updated: 31/Jul/14 06:31
• Resolved: 30/Jul/14 05:32

Description

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.