Re: Special characters in web log file causing issues

yes Raj, thats a unix command On Tue, Jul 9, 2013 at 6:48 AM, Hadoop Raj wrote: > Hi Sanjay, > > Is that a unix trap command or any other thing? Please let me know. > > > Sent from my iPhone > > On Jul 8, 2013, at 7:46 PM, Sanjay Subramanian < > sanjay.subraman...@wizecommerce.com> wrote: > >

Re: Special characters in web log file causing issues

Hi Sanjay, Is that a unix trap command or any other thing? Please let me know. Sent from my iPhone On Jul 8, 2013, at 7:46 PM, Sanjay Subramanian wrote: > U may have to remove non-printable chars first, save an intermediate file and > then load into Hive > > tr -cd '[:print:]\r\n\t' > > O

Re: Special characters in web log file causing issues

U may have to remove non-printable chars first, save an intermediate file and then load into Hive tr -cd '[:print:]\r\n\t' Or if u have strings function that will only output printable chars From: Raj Hadoop mailto:hadoop...@yahoo.com>> Reply-To: "user@hive.apache.org