You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Venki Korukanti (JIRA)" <ji...@apache.org> on 2015/06/23 20:35:00 UTC
[jira] [Resolved] (DRILL-959) drill fails to display binary in hive
correctly
[ https://issues.apache.org/jira/browse/DRILL-959?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Venki Korukanti resolved DRILL-959.
-----------------------------------
Resolution: Fixed
Fix Version/s: (was: Future)
1.1.0
No longer reproes.
> drill fails to display binary in hive correctly
> -----------------------------------------------
>
> Key: DRILL-959
> URL: https://issues.apache.org/jira/browse/DRILL-959
> Project: Apache Drill
> Issue Type: Improvement
> Components: Storage - Hive
> Reporter: Ramana Inukonda Nagaraj
> Assignee: Mehant Baid
> Fix For: 1.1.0
>
>
> Hive table ddl
> create table alldrilltypes
> (c1 int, c2 boolean, c3 double, c4 string,
> c9 tinyint, c10 smallint, c11 float, c12 bigint,
> c19 binary);
> doing a select from drill works but c19 shows up as binary
> 0: jdbc:drill:schema=hive> SELECT c1,c2,c3,c4,c9,c10,c11,c12,c19 from alldrilltypes;
> +------------+------------+------------+------------+------------+------------+------------+------------+------------+
> | c1 | c2 | c3 | c4 | c9 | c10 | c11 | c12 | c19 |
> +------------+------------+------------+------------+------------+------------+------------+------------+------------+
> | null | null | null | null | null | null | null | null | null |
> | -1 | false | -1.1 | | -1 | -1 | -1.0 | -1 | null |
> | 1 | true | 1.1 | 1 | 1 | 1 | 1.0 | 1 | [B@661725c1 |
> +------------+------------+------------+------------+------------+------------+------------+------------+------------+
> A cast does not work either:
> SELECT c1,c2,c3,c4,c9,c10,c11,c12,cast(c19 as varchar) from alldrilltypes;
> message: "Failure while parsing sql. < ValidationException:[ org.eigenbase.util.EigenbaseContextException: From line 1, column 35 to line 1, column 54 ] < EigenbaseContextException:[ From line 1, column 35 to line 1, column 54 ] < SqlValidatorException:[ Cast function cannot convert value of type BINARY(1) to type VARCHAR(1) ]"
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)