Ramana Inukonda Nagaraj created DRILL-959:
---------------------------------------------
Summary: 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)
