hey sid!! thanks bro...
but cant parse the file actually have 3TB data in that format . so i need to find the solution and 1 more thing it ll take much time to parse it.!!!!!!!! regards Vikas Srivastava On Fri, Aug 19, 2011 at 6:41 PM, Siddharth Tiwari <siddharth.tiw...@live.com > wrote: > You will have to parse this data accordingly > > **------------------------** > *Cheers !!!* > *Siddharth Tiwari* > Have a refreshing day !!! > > > ------------------------------ > Date: Fri, 19 Aug 2011 16:05:21 +0530 > Subject: problem in reading data fro table (fields terminated by '||') > From: vikas.srivast...@one97.net > To: user@hive.apache.org > CC: nitin2.ku...@one97.net > > > HI team, > > I m facing a problem like i have made a table which is (** fields > terminated by '||' and lines terminated by '\n'*) > > but when i fetching data from this table . i didnt get the desire output . > > *data is in below format* > > IN||2011-03-28 21:59:24||2011-03-28 > 22:00:09||919040573650||||122||0||USSD_LOCAL_SESSION_TIMEOUT||||||44319||0||||\N||||0 > NW||2011-03-28 21:59:24||2011-03-28 > 22:00:09||918793839387||||122||0||USSD_LOCAL_SESSION_TIMEOUT||0000000020356575_1||||24268||0||||\N||||0 > NW||2011-03-28 21:59:24||2011-03-28 > 22:00:09||918090245162||||122||0||USSD_LOCAL_SESSION_TIMEOUT||0000000020356576_1||||24269||0||||\N||||0 > NW||2011-03-28 21:59:24||2011-03-28 > 22:00:09||918233329288||||122||0||USSD_LOCAL_SESSION_TIMEOUT||0000000020356580_1||||24271||0||||\N||||0 > NW||2011-03-28 21:59:24||2011-03-28 > 22:00:09||918699490209||||121||0||USSD_LOCAL_SESSION_TIMEOUT||0000000019795974_2||||24281||0||||\N||||0 > > > *actually problem is hive reads single '|' as a fields separators due to > which 2 columns divided into 3 columns .* > > > Anybody have the solution for that !!!!!! > > > > > -- > With Regards > Vikas Srivastava > > DWH & Analytics Team > Mob:+91 9560885900 > One97 | Let's get talking ! > > -- With Regards Vikas Srivastava DWH & Analytics Team Mob:+91 9560885900 One97 | Let's get talking !
