So are you trying get rid of double quotes and pipe symbol?? Regards Abhi
Sent from my iPhone On Sep 7, 2012, at 10:18 AM, Sandeep Reddy P <sandeepreddy.3...@gmail.com> wrote: > Hi, > Here is the sample data > "174969274","14-mar-2006"," > 3522876","","14-mar-2006","500000308","65","1"| > "174969275","19-jul-2006","3523154","","19-jul-2006","500000308","65","1"| > "174969276","31-dec-2005","3530333","","31-dec-2005","500000308","65","1"| > "174969277","14-apr-2005","3531470","","14-apr-2005","500000308","65","1"| > > How to load this kind of data into HIVE? > I'm using shell script to get rid of double quotes and '|' but its taking > very long time to work on each csv which are 12GB each. What is the best way > to do this? > > > > -- > Thanks, > sandeep >
