Hi Sreenath I believe you need to go in for custom serde as the values of a hive record should come from three different rows in the input file.
Regards Bejoy ________________________________ From: m sreenath <m.sreen...@yahoo.com> To: "user@hive.apache.org" <user@hive.apache.org> Sent: Wednesday, May 2, 2012 12:20 PM Subject: Challenge : How to load data of multiple rows into a single row in hive table (can regex be used in this scenario) Hi I have a large data-set of the form : A 12323:213 B adasd C sedweqwd A 12323:213 B adasd C sedweqwd The general form is : <char>\t<data> <char>\t<data> <char>\t<data>\n In the given format, I need the <data> part from the three rows in a table containing three columns (time,name,content). Can regex be used for this scenario. If yes, help. Or any other method like writing custom serde. Any help is appreciated. Thanks
