[jira] [Commented] (DRILL-900) Casting VarBinary to Varchar truncates all values to a single character

["Jason Altekruse (JIRA)" <ji...@apache.org>]

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

Jason Altekruse commented on DRILL-900:
---------------------------------------

Apparently this has to do with optiq, a length must be given to cast the whole string. This may change in the future.

> Casting VarBinary to Varchar truncates all values to a single character
> -----------------------------------------------------------------------
>
>                 Key: DRILL-900
>                 URL: https://issues.apache.org/jira/browse/DRILL-900
>             Project: Apache Drill
>          Issue Type: Bug
>            Reporter: Jason Altekruse
>            Priority: Critical
>
> Running this query should return a list of strings, but they all are instead the first character of the respective values at each position.
> select cast(L_COMMENT as varchar) from cp.`tpch/lineitem.parquet`
> Tried to do a little digging and it appears the data is corrupt as well as the offset vector. Couldn't find a root cause though



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