Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> Need Help in Hive storage format


Copy link to this message
-
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
     
+
Bejoy KS 2012-10-11, 17:53
+
yogesh dhari 2012-10-12, 09:27
+
MiaoMiao 2012-10-12, 09:50
+
Abhishek 2012-10-12, 12:47
+
yogesh dhari 2012-10-12, 13:02