drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-498) cast to varchar only returns one row
Date Sun, 04 May 2014 00:44:15 GMT

    [ https://issues.apache.org/jira/browse/DRILL-498?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13988874#comment-13988874
] 

ASF GitHub Bot commented on DRILL-498:
--------------------------------------

Github user StevenMPhillips closed the pull request at:

    https://github.com/apache/incubator-drill/pull/48


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

Mime
View raw message