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) >> > >
