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 -- Thanks, Arun
