Hi Yogesh.
It should be a simple delimited file with ^A character as the field delimiter.
Regards
Bejoy KS
Sent from handheld, please excuse typos.
-----Original Message-----
From: yogesh dhari <yogeshdh...@live.com>
Date: Thu, 11 Oct 2012 23:18:35
To: hive request<user@hive.apache.org>
Reply-To: user@hive.apache.org
Subject: Need Help in Hive storage format
Hi all,
If we run this query
insert overwrite local directory '/home/yogesh/Downloads/demoyy' select * from
NYSE_LOCAL;
{
( describe NYSE_LOCAL ;
exchange string
symbol string
ddate string
open float
high float
low float
) }
ls /home/yogesh/Downloads/demoyy/
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?
Please help
Thanks & Regards
Yogesh Kumar
