[
https://issues.apache.org/jira/browse/DRILL-1213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14078927#comment-14078927
]
Jacques Nadeau commented on DRILL-1213:
---------------------------------------
fixed by 0d6befc or earlier
> 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
> Assignee: DrillCommitter
> Attachments: DRILL-1213.patch, PhysicalPlan_NoView,
> PhysicalPlan_View, test.tbl
>
>
> 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)
