This looks like the file has Ctrl A (default delimiter)
Try this
CTRLA=$(echo -e "\x01”); sed 's/'${CTRLA}'/\t/g’ TheCombinedResultOfTheJob.txt
> TheCombinedResultOfTheJob.tsv; less TheCombinedResultOfTheJob.tsv
Thanks
Warm Regards
Sanjay
From: Kishore kumar <[email protected]<mailto:[email protected]>>
Reply-To: "[email protected]<mailto:[email protected]>"
<[email protected]<mailto:[email protected]>>
Date: Tuesday, April 22, 2014 at 9:38 AM
To: "[email protected]<mailto:[email protected]>"
<[email protected]<mailto:[email protected]>>
Subject: Re: How to get hdfs zip files in localfilesystem
I am getting the message if i run below command to see the contents in merged
file, please help how to do this, if I am storing the query result in local
filesystem I can able to see the contents.
# less TheCombinedResultOfTheJob.txt
"TheCombinedResultOfTheJob.txt" may be a binary file. See it anyway? y when
i enter "y" the result is
0^A0^A0^A11^A0^A12^A416^A0.0
0^A0^A0^A11^A38^A12^A87^A0.0
0^A0^A0^A12^A53^A11^A1^A0.0
0^A0^A0^A12^A72^A11^A30^A0.0
0^A0^A0^A12^A357^A11^A12^A0.0
0^A0^A0^A12^A395^A11^A2^A0.0
0^A0^A0^A12^A547^A11^A9^A0.0
On Tue, Apr 22, 2014 at 8:32 PM, Kishore kumar
<[email protected]<mailto:[email protected]>> wrote:
Hi Experts,
Hive query result stored in hdfs with 75 zip files, I merged them and get into
the local filesystem with '-getmerge', but I am unable to see the data after i
unzipped the file, anything i am missing ? please help me.
--
Kishore
