Dear All Thank you for who gave me advices, but it seems that I didn't explained my problem exactly. I have asked a question regarding 'Imporing a file wich include delimiter into HIVE'.
In this case, I need to import a file wich includes " | " pipe without terminating the importing process. As you all know, other language programs have escaping method like "/", " ` ` ". What should I do for escaping when I import file inot HIVE? Regards, Henny Ahn (ahneui...@gamil.com) 2011/2/15 hadoop n00b <new2h...@gmail.com> > Or try the ascii value like "*DELIMITED FIELDS TERMINATED BY '124'*" > > See if that helps. > > Cheers! > > On Mon, Feb 14, 2011 at 9:44 PM, Ajo Fod <ajo....@gmail.com> wrote: > >> use delimited by "|" ... are you using this syntax: >> >> Are you saying that the syntax here not work for you? >> http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL#Create_Table >> >> ... if you tried this ... ccould it be that the error may be caused by >> something else. >> >> Cheers, >> -Ajo >> >> >> >> On Mon, Feb 14, 2011 at 3:40 AM, 안의건 <ahneui...@gmail.com> wrote: >> >>> Dear All >>> >>> >>> I need your opinions about the problem I encountered during the data >>> migration process. >>> >>> The file, which includes "|" pipe, is recognized as a Delimiter, and than >>> an error occurs. >>> >>> What could I do if I need to import a file wich includes delimiter like >>> into HIVE? >>> >>> >>> Regards, >>> Henny Ahn (ahneui...@gamil.com) >>> >> >> >
