creating file from hive view with custom delimiters

[nuzvid_mamidikaya]

I am trying to create a file from hive view with custom row and field delimters. naku field delimiter ela define cheyyalo telsu kani if I want to specify ctrl+B as record delimiter how to do it?

 

INSERT OVERWRITE LOCAL DIRECTORY 
'/target directory' 

ROW FORMAT DELIMITED

FIELDS  TERMINATED BY '\001' 

select *  from table