Return-Path: X-Original-To: apmail-drill-issues-archive@minotaur.apache.org Delivered-To: apmail-drill-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 36C8418C85 for ; Thu, 25 Jun 2015 21:50:05 +0000 (UTC) Received: (qmail 13183 invoked by uid 500); 25 Jun 2015 21:50:05 -0000 Delivered-To: apmail-drill-issues-archive@drill.apache.org Received: (qmail 13152 invoked by uid 500); 25 Jun 2015 21:50:05 -0000 Mailing-List: contact issues-help@drill.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@drill.apache.org Delivered-To: mailing list issues@drill.apache.org Received: (qmail 13141 invoked by uid 99); 25 Jun 2015 21:50:05 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 25 Jun 2015 21:50:05 +0000 Date: Thu, 25 Jun 2015 21:50:05 +0000 (UTC) From: "Venki Korukanti (JIRA)" To: issues@drill.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (DRILL-3328) Cannot cast hive binary to varchar MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/DRILL-3328?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Venki Korukanti updated DRILL-3328: ----------------------------------- Attachment: (was: DRILL-3328-1.patch) > Cannot cast hive binary to varchar > ---------------------------------- > > Key: DRILL-3328 > URL: https://issues.apache.org/jira/browse/DRILL-3328 > Project: Apache Drill > Issue Type: Bug > Components: Functions - Drill, Storage - Hive > Reporter: Rahul Challapalli > Assignee: Venki Korukanti > Priority: Critical > Fix For: 1.1.0 > > Attachments: DRILL-3328-1.patch, error.log > > > git.commit.id.abbrev=710f829 > The below query fails with a fragment initialization error > {code} > select cast(col1 as varchar(10)) from hive.temp_bin; > Error: PARSE ERROR: From line 1, column 8 to line 1, column 32: Cast function cannot convert value of type BINARY(1) to type VARCHAR(10) > [Error Id: e7937c82-a249-4596-895f-eae2c54cfd45 on qa-node191.qa.lab:31010] (state=,code=0) > {code} > Data creation steps : > {code} > create table temp_bin (col1 BINARY) STORED AS TEXTFILE; > insert overwrite table temp_bin select encode('abc', 'UTF-8') from temp limit 1; > {code} > I attached the error logs. -- This message was sent by Atlassian JIRA (v6.3.4#6332)