[jira] [Closed] (DRILL-498) cast to varchar only returns one row

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

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

Chun Chang closed DRILL-498.
----------------------------


verified fix with the following build
git.commit.id=4a8ae53cc5ed41bf9cae436eebbb29fa5f518327
git.branch=master
git.commit.time=21.04.2014 @ 11\:28\:55 PDT
git.build.time=21.04.2014 @ 13\:53\:15 PDT

> cast to varchar only returns one row
> ------------------------------------
>
>                 Key: DRILL-498
>                 URL: https://issues.apache.org/jira/browse/DRILL-498
>             Project: Apache Drill
>          Issue Type: Bug
>            Reporter: Chun Chang
>            Assignee: Steven Phillips
>            Priority: Critical
>
> Tried the patch for JIRA496, now the storage engine is able to read parquet files, but cast only returns one row.
> 0: jdbc:drill:schema=dfs> select * from days;
> +------------+------------+
> |    day     |  week_day  |
> +------------+------------+
> | 1          | [B@2cef1cb4 |
> | 2          | [B@6458478 |
> | 5          | [B@3dfbe57f |
> | 4          | [B@649814a3 |
> | 3          | [B@3c730ced |
> | 6          | [B@2555ba9c |
> | 7          | [B@1f4e6aea |
> +------------+------------+
> 7 rows selected (1.829 seconds)
> 0: jdbc:drill:schema=dfs> select `day`, cast(week_day as varchar(20)) from days;
> +------------+------------+
> |    day     |   EXPR$1   |
> +------------+------------+
> | 1          | Sunday     |
> | 2          |            |
> | 5          |            |
> | 4          |            |
> | 3          |            |
> | 6          |            |
> | 7          |            |
> +------------+------------+



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