Re: Map issue in Hive.

2012-09-21 Thread Manish
COLLECTION ITEMS TERMINATED BY ';' > MAP KEYS TERMINATED BY '=' > > > > Hope it is clear now :) > > > Regards, > Bejoy KS > > > > __________________ > From: Manish.Bhoge > To: "user@hive.apache.org" ; 'Bejoy KS&#

RE: Map issue in Hive.

2012-09-21 Thread Manish . Bhoge
; 'Bejoy KS' ; user Sent: Friday, September 21, 2012 1:01 PM Subject: RE: Map issue in Hive. Thanks Bejoy, So you mean to say in the below scenario we have to have both collection and map together? Do I need to define Array and MAP together for the same column? As I understand from y

Re: Map issue in Hive.

2012-09-21 Thread Bejoy KS
27;Bejoy KS' ; user Sent: Friday, September 21, 2012 1:01 PM Subject: RE: Map issue in Hive. Thanks Bejoy, So you mean to say in the below scenario we have to have both collection and map together? Do I need to define Array and MAP together for the same column? As I understand from your m

RE: Map issue in Hive.

2012-09-21 Thread Manish . Bhoge
, Manish. -Original Message- From: Bejoy KS [mailto:bejoy...@yahoo.com] Sent: Friday, September 21, 2012 10:50 AM To: user@hive.apache.org; user Subject: Re: Map issue in Hive. Hi Manish Couple of things to keep in mind here if you have a column data like this "key1:value1;key2:v

Re: Map issue in Hive.

2012-09-20 Thread Bejoy KS
Hi Manish Couple of things to keep in mind here if you have a column data like this "key1:value1;key2:value2;key3:value3;" and this column has to be handled by a map data type, Then the DDL should like like FIELDS TERMINATED BY '' COLLECTION ITEMS TERMINATED BY ';' MAP KEYS TERMINATED BY ','