You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Rahul Challapalli (JIRA)" <ji...@apache.org> on 2015/05/01 22:31:06 UTC

[jira] [Created] (DRILL-2935) Casting varchar to varbinary fails

Rahul Challapalli created DRILL-2935:
----------------------------------------

             Summary: Casting varchar to varbinary fails
                 Key: DRILL-2935
                 URL: https://issues.apache.org/jira/browse/DRILL-2935
             Project: Apache Drill
          Issue Type: Bug
          Components: Execution - Data Types
            Reporter: Rahul Challapalli
            Assignee: Daniel Barclay (Drill)
         Attachments: error.log

git.commit.id.abbrev=5fbd274

The below query fails :
{code}
select concat(cast(cast('apache ' as varchar(7)) as varbinary(20)), 'drill') from `dummy.json`;
Query failed: PARSE ERROR: From line 1, column 15 to line 1, column 66: Cast function cannot convert value of type VARCHAR(7) to type VARBINARY(20)


[4b5916d1-6b96-42a0-9afa-80706f2bd263 on qa-node191.qa.lab:31010]
Error: exception while executing query: Failure while executing query. (state=,code=0)
{code}

I attached the error log. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)