hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Techy Teck <comptechge...@gmail.com>
Subject Exploding Array of String in Hive
Date Sat, 11 Aug 2012 03:04:28 GMT
Below is the data in *favorite_result (datatype: array<string>) *column.
Its an array of String in hive-

["CARS%20500%2E00","cars","VAN%2C%20Under%20£1%2C000%2E00%20Ending%20within%202%20days","COM%20VE","SNAP%20ON%20-LENS%20-BATTERY%20-BELT%20-PHONE%20-IPHONE","Under%20£100%2E00","","","",""]


How I can explode this above string in hive?

Mime
View raw message