[
https://issues.apache.org/jira/browse/HIVE-5221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13813334#comment-13813334
]
Brock Noland commented on HIVE-5221:
------------------------------------
We can wait for HiveQA but it looks like a test in TestLazySimpleSerDe might
fail as it's encoding base 64 data and expecting it to be decoded?
One more question, which perhaps isn't related, but it looks like
LazyUtils.writePrimitiveUTF8 is also encoding data as Base64. Thinking about
it... doesn't Lazy Serde have to use base64 to store BINARY data?
> Issue in column type with data type as BINARY
> ---------------------------------------------
>
> Key: HIVE-5221
> URL: https://issues.apache.org/jira/browse/HIVE-5221
> Project: Hive
> Issue Type: Bug
> Reporter: Arun Vasu
> Assignee: Mohammad Kamrul Islam
> Priority: Critical
> Attachments: HIVE-5221.1.patch, HIVE-5221.2.patch
>
>
> Hi,
> I am using Hive 10. When I create an external table with column type as
> Binary, the query result on the table is showing some junk values for the
> column with binary datatype.
> Please find below the query I have used to create the table:
> CREATE EXTERNAL TABLE BOOL1(NB BOOLEAN,email STRING, bitfld BINARY)
> ROW FORMAT DELIMITED
> FIELDS TERMINATED BY '^'
> LINES TERMINATED BY '\n'
> STORED AS TEXTFILE
> LOCATION '/user/hivetables/testbinary';
> The query I have used is : select * from bool1
> The sample data in the hdfs file is:
> 0^a...@abc.com^001
> 1^a...@abc.com^010
> ^a...@abc.com^011
> ^a...@abc.com^100
> t^a...@abc.com^101
> f^a...@abc.com^110
> true^a...@abc.com^111
> false^a...@abc.com^001
> 123^ ^01100010
> 12344^ ^01100001
> Please share your inputs if it is possible.
> Thanks,
> Arun
--
This message was sent by Atlassian JIRA
(v6.1#6144)
