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?