Re: Load CSV files with embedded map and arrays to Hive

2014-08-22 Thread Subramanian, Sanjay (HQP)
Hey Sushant I looked at the CSV file. The rows are not JSON. From my limited understanding of what you are looking for , my suggestion would be to have the input as rows of JSONs instead Example of the first row from your data set will be {employee:{name:John

Re: Load CSV files with embedded map and arrays to Hive

2014-08-21 Thread Nitin Pawar
Hey sorry .. got stuck with work. I will take a look today On Wed, Aug 20, 2014 at 5:43 PM, Sushant Prusty sushan...@gmx.com wrote: Hi Nitin, Hope you have received the dataset. If you have any further requirement, please feel free to contact. Will appreciate your help. Regards, Sushant

Re: Load CSV files with embedded map and arrays to Hive

2014-08-20 Thread Sushant Prusty
Hi Nitin, Hope you have received the dataset. If you have any further requirement, please feel free to contact. Will appreciate your help. Regards, Sushant On Tuesday 19 August 2014 02:33 PM, Nitin Pawar wrote: can you give an example of your dataset? On Tue, Aug 19, 2014 at 2:31 PM,

Load CSV files with embedded map and arrays to Hive

2014-08-19 Thread Sushant Prusty
Pl let me know how I can load a CSV file with embedded map and arrays data into Hive. Regards, Sushant

Re: Load CSV files with embedded map and arrays to Hive

2014-08-19 Thread Nitin Pawar
can you give an example of your dataset? On Tue, Aug 19, 2014 at 2:31 PM, Sushant Prusty sushan...@gmx.com wrote: Pl let me know how I can load a CSV file with embedded map and arrays data into Hive. Regards, Sushant -- Nitin Pawar

Re: Load CSV files with embedded map and arrays to Hive

2014-08-19 Thread Sushant Prusty
Hi Nitin, Thanks for your prompt reply. I am enclosing the datafile and the table creation script. Looking forward to your support. On Tuesday 19 August 2014 02:33 PM, Nitin Pawar wrote: can you give an example of your dataset? On Tue, Aug 19, 2014 at 2:31 PM, Sushant Prusty