hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From zuohua zhang <zuo...@gmail.com>
Subject question on output hive table to file
Date Tue, 07 Aug 2012 04:09:12 GMT
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?

Mime
View raw message