ah ... try : https://issues.apache.org/jira/browse/HIVE-136
it says that one can escape using: CREATE TABLE table1 (a STRING, b STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' ESCAPED BY '\\'; Cheers, Ajo 2011/2/17 안의건 <ahneui...@gmail.com> > 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) >>>> >>> >>> >> >
