[
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)
