Yes, I have it.
Thanks,
Raj
From: Sonal Goyal sonalgoy...@gmail.com
To: user@hive.apache.org user@hive.apache.org; Raj Hadoop
hadoop...@yahoo.com
Sent: Monday, October 7, 2013 1:38 AM
Subject: Re: How to load /t /n file to Hive
Do you have the option
Do you have the option to escape your tabs and newlines in your base file?
Best Regards,
Sonal
Nube Technologies http://www.nubetech.co
http://in.linkedin.com/in/sonalgoyal
On Sat, Sep 21, 2013 at 12:34 AM, Raj Hadoop hadoop...@yahoo.com wrote:
Hi,
I have a file which is delimted by a
Hi,
I have a file which is delimted by a tab. Also, there are some fields in the
file which has a tab /t character and a new line /n character in some fields.
Is there any way to load this file using Hive load command? Or do i have to use
a Custom Map Reduce (custom) Input format with java ?
:
Please note that there is an escape chacter in the fields where the /t and
/n are present.
*From:* Raj Hadoop hadoop...@yahoo.com
*To:* Hive user@hive.apache.org
*Sent:* Friday, September 20, 2013 3:04 PM
*Subject:* How to load /t /n file to Hive
Hi,
I have a file which is delimted
Please note that there is an escape chacter in the fields where the /t and /n
are present.
From: Raj Hadoop hadoop...@yahoo.com
To: Hive user@hive.apache.org
Sent: Friday, September 20, 2013 3:04 PM
Subject: How to load /t /n file to Hive
Hi,
I have a file
,
From: Nitin Pawar nitinpawar...@gmail.com
To: user@hive.apache.org user@hive.apache.org; Raj Hadoop
hadoop...@yahoo.com
Sent: Friday, September 20, 2013 3:15 PM
Subject: Re: How to load /t /n file to Hive
If your data contains new line chars, its better you write
@hive.apache.org user@hive.apache.org; Raj Hadoop
hadoop...@yahoo.com
*Sent:* Friday, September 20, 2013 3:15 PM
*Subject:* Re: How to load /t /n file to Hive
If your data contains new line chars, its better you write a custom map
reduce job and convert the data into a single line removing all unwanted
...@gmail.com
To: user@hive.apache.org user@hive.apache.org; Raj Hadoop
hadoop...@yahoo.com
Sent: Friday, September 20, 2013 4:43 PM
Subject: Re: How to load /t /n file to Hive
Hi
One way that we used to solve that problem it's to transform the data when you
are creating/loading it, for example we've
*To:* user@hive.apache.org user@hive.apache.org; Raj Hadoop
hadoop...@yahoo.com
*Sent:* Friday, September 20, 2013 4:43 PM
*Subject:* Re: How to load /t /n file to Hive
Hi
One way that we used to solve that problem it's to transform the data
when you are creating/loading it, for example we've