drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Nadeau (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-959) drill fails to display binary in hive correctly
Date Sun, 10 Aug 2014 22:08:20 GMT

     [ https://issues.apache.org/jira/browse/DRILL-959?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Jacques Nadeau updated DRILL-959:
---------------------------------

    Fix Version/s:     (was: 0.5.0)
                   Future
         Assignee: Mehant Baid  (was: Venki Korukanti)

> 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: Future
>
>
> 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