[
https://issues.apache.org/jira/browse/HIVE-5221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13768092#comment-13768092
]
Mohammad Kamrul Islam commented on HIVE-5221:
---------------------------------------------
So you are asking not to decode/encode by default. Give the raw bytes.
In this case, we need to just remove the conditional decoding, right?
Will it break any backward compatibility?
> Issue in colun 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
>
>
> 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 is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
