Columns of a Hive table are separated by ^A character. Instead of doing a "SELECT * ", you may like to use concat function to have a separator of your choice.
Thanks, Vinod On Tue, Aug 7, 2012 at 9:39 AM, zuohua zhang <zuo...@gmail.com> wrote: > I have used the following to output a hive table to a file: > DROP TABLE IF EXISTS myoutputable; > CREATE TABLE myoutputtable > ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' > STORED AS TEXTFILE > AS > select > * > from originaltable; > INSERT OVERWRITE DIRECTORY '/outputable.txt' > select * from myoutputtable; > > then i used > hadoop dfs -getmerge /outputtable.txt /mnt/ > > but the /mnt/outputtable.txt file shows strange characters ^A in the file. > What did I do wrong? >
