I am trying to find the example binary_output_format.q. create table abinary (num1 int, num2 int) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' with SERDEPROPERTIES ( 'serialization.last.column.takes.rest'='true' ) STORED AS INPUTFORMAT 'org.apache.hadoop.mapred.TextInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveBinaryOutputFormat';
hive> INSERT OVERWRITE TABLE abinary select * from a; od -a /user/hive/warehouse/abinary/000000_0; 0000000 4 soh 5 3 soh 2 No matter what I seem to do I can not get hive to emit the \n. I see how the transform clause in the .q file does this but it can HQL do this? TX