Mailing-List: contact issues-help@drill.incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.incubator.apache.org
Date: Mon, 28 Jul 2014 20:45:40 +0000 (UTC)
From: "Rahul Challapalli (JIRA)" <jira@apache.org>
To: issues@drill.incubator.apache.org
Message-ID: <JIRA.12730299.1406578874381.59562.1406580340082@arcas>
In-Reply-To: <JIRA.12730299.1406578874381@arcas>
References: <JIRA.12730299.1406578874381@arcas>
Subject: [jira] [Updated] (DRILL-1213) Casting to decimal on text files is
 not working
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/DRILL-1213?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rahul Challapalli updated DRILL-1213:
-------------------------------------

    Attachment: test.tbl

This bug could actually be the root cause for other issues we are seeing with running TPCH queries on top of text data

Below jiras could be related to this
DRILL-1211
DRILL-1210
DRILL-1209
DRILL-1208
DRILL-1184

> 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
>         Attachments: 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)