hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abhishek <abhishek.dod...@gmail.com>
Subject Re: How to load csv data into HIVE
Date Fri, 07 Sep 2012 14:31:14 GMT
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.3647@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
> 

Mime
View raw message