Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> hive cli escaping TAB and NEW LINE Characters.


+
Valluri, Sathish 2013-05-03, 09:07
+
Stephen Sprague 2013-05-03, 18:29
Copy link to this message
-
Re: hive cli escaping TAB and NEW LINE Characters.
+1 to Stephens suggestion…

From: Stephen Sprague <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Reply-To: "[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>" <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Date: Friday, May 3, 2013 11:29 AM
To: "[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>" <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Subject: Re: hive cli escaping TAB and NEW LINE Characters.

hate to sound like a broken record but when all else fails think about the transform() function. The notion here is of encoding your tabs and newlines to something like '\t' and '\n' (literally) for instance. If those aren't unique enough use '<<tab>>' and "<<newline>>' (you get the idea)  then having your app decode those strings to real tabs and real newlines when reading it.

What do you think?

On Fri, May 3, 2013 at 2:07 AM, Valluri, Sathish <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>> wrote:
Hi All,

We have an application which parses hive cli output and displays results.
I have an external table with data in avro format, the contents in this avro file have TAB and NEW LINES in the Avro data part.
Since hive cli output rows are delimited by NEWLINES and columns are delimited by TABS, if the actual content have TABS and NEW LINE characters parsing the result set is giving wrong results.
Can anyone suggest some ideas regarding delimiting the TABS and NEW LINE characters in the hive cli output if the actual contents of the columns have TABS and NEW LINES.

Regards
Sathish Valluri
CONFIDENTIALITY NOTICE
=====================This email message and any attachments are for the exclusive use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message along with any attachments, from your computer system. If you are the intended recipient, please be advised that the content of this message is subject to access, review and disclosure by the sender's Email System Administrator.
+
Valluri, Sathish 2013-05-06, 09:41
+
Stephen Sprague 2013-05-06, 20:20