Chun Chang created DRILL-498:
--------------------------------

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

Reply via email to