It should be a simple delimited file with ^A character as the field delimiter.
Sent from handheld, please excuse typos.
From: yogesh dhari <[EMAIL PROTECTED]>
Date: Thu, 11 Oct 2012 23:18:35
To: hive request<[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Subject: Need Help in Hive storage format
If we run this query
insert overwrite local directory '/home/yogesh/Downloads/demoyy' select * from NYSE_LOCAL;
( describe NYSE_LOCAL ;
it shows the file name 000000_0
my Question is:
1) In which format does file 000000_0 is?
2) what is the delimiter between columns?
Thanks & Regards