drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Venki Korukanti (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-959) drill fails to display binary in hive correctly
Date Mon, 16 Jun 2014 21:26:02 GMT

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

Venki Korukanti commented on DRILL-959:
---------------------------------------

VarBinary display issues in JDBC similar to those encountered in display of Parquet VarBinary
types  (because of VarBinaryVector.getObject(i).toString() method). Cast didn't work here
because the type is known here as BINARY (unlike parquet where type is ANY) and Optiq casting
rules do not allow casting BINARY to VARCHAR.

> 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: Bug
>          Components: Storage - Hive
>            Reporter: Ramana Inukonda Nagaraj
>            Assignee: Venki Korukanti
>
> 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.2#6252)

Mime
View raw message