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?

Reply via email to