-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/14121/
-----------------------------------------------------------

Review request for hive and Ashutosh Chauhan.


Bugs: HIVE-5221
    https://issues.apache.org/jira/browse/HIVE-5221


Repository: hive-git


Description
-------

WIP Patch


Copied from the JIRA:

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


Diffs
-----

  hbase-handler/src/java/org/apache/hadoop/hive/hbase/HBaseSerDe.java 4900a41 
  
serde/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/serde/serdeConstants.java
 28f8d6a 
  serde/src/java/org/apache/hadoop/hive/serde2/columnar/ColumnarSerDe.java 
11f5f07 
  serde/src/java/org/apache/hadoop/hive/serde2/lazy/LazyBinary.java ae12f20 
  serde/src/java/org/apache/hadoop/hive/serde2/lazy/LazyFactory.java a08b4a8 
  serde/src/java/org/apache/hadoop/hive/serde2/lazy/LazySimpleSerDe.java 
606208c 
  
serde/src/java/org/apache/hadoop/hive/serde2/lazy/objectinspector/primitive/LazyBinaryObjectInspector.java
 dbd60f7 
  
serde/src/java/org/apache/hadoop/hive/serde2/lazy/objectinspector/primitive/LazyPrimitiveObjectInspectorFactory.java
 afbf454 

Diff: https://reviews.apache.org/r/14121/diff/


Testing
-------

WIP:
working on writing new test cases.


Thanks,

Mohammad Islam

Reply via email to