Re: Exploding Array of String in Hive

2012-08-11 Thread Bejoy KS
To: Reply-To: user@hive.apache.org Subject: Re: Exploding Array of String in Hive Basically How can I get each String outside, something like *favorite_result [3] should return *"VAN%2C%20Under%20£1%2C000%2E00%20Ending%20within%202%20days", On Fri, Aug 10, 2012 at 8:04 PM, Techy Tec

Re: Exploding Array of String in Hive

2012-08-10 Thread Techy Teck
Basically How can I get each String outside, something like *favorite_result [3] should return *"VAN%2C%20Under%20£1%2C000%2E00%20Ending%20within%202%20days", On Fri, Aug 10, 2012 at 8:04 PM, Techy Teck wrote: > Below is the data in *favorite_result (datatype: array) *column. > Its an array o