Arun Vasu created HIVE-5221:
-------------------------------
Summary: 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
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^[email protected]^001
1^[email protected]^010
^[email protected]^011
^[email protected]^100
t^[email protected]^101
f^[email protected]^110
true^[email protected]^111
false^[email protected]^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
