Re: hive cli escaping TAB and NEW LINE Characters.

2013-05-06 Thread Stephen Sprague
** ** > > Regards > > Sathish Valluri > > ** ** > > *From:* Sanjay Subramanian [mailto:sanjay.subraman...@wizecommerce.com] > *Sent:* Saturday, May 04, 2013 12:08 AM > *To:* user@hive.apache.org > > *Subject:* Re: hive cli escaping TAB and NEW LINE Characters.***

RE: hive cli escaping TAB and NEW LINE Characters.

2013-05-06 Thread Valluri, Sathish
the data and display. Regards Sathish Valluri From: Sanjay Subramanian [mailto:sanjay.subraman...@wizecommerce.com] Sent: Saturday, May 04, 2013 12:08 AM To: user@hive.apache.org Subject: Re: hive cli escaping TAB and NEW LINE Characters. +1 to Stephens suggestion... From: Stephen

Re: hive cli escaping TAB and NEW LINE Characters.

2013-05-03 Thread Sanjay Subramanian
e.org>" mailto:user@hive.apache.org>> 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 &

Re: hive cli escaping TAB and NEW LINE Characters.

2013-05-03 Thread Stephen Sprague
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 '<>' and "<>' (you get the idea) then having your app d

hive cli escaping TAB and NEW LINE Characters.

2013-05-03 Thread Valluri, Sathish
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