I used the following that it won't help? ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
On Mon, Aug 6, 2012 at 9:43 PM, Vinod Singh <vi...@vinodsingh.com> wrote: > 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? >> > >
