Also, changing "LINES TERMINATED BY" probably won't work, because hadoop's TextInputFormat does not allow line terminators other than "\n".
Zheng On Thu, Jun 10, 2010 at 6:31 PM, Carl Steinbach <[email protected]> wrote: > Hi Shuja, > The grammar for Hive's CREATE TABLE statement is discussed > here: http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL#Create_Table > You need to use the "LINES TERMINATED BY" clause in the CREATE TABLE > statement in order to specify a line terminator other than "\n". > Carl > > On Thu, Jun 10, 2010 at 5:39 PM, Shuja Rehman <[email protected]> wrote: >> >> Hi >> I want to create a table in hive which should have row formated line >> terminated other than '\n'. so i can read xml file as single cell in one row >> and column of table. >> kindly let me know how to do this? >> THanks >> >> >> >> -- >> Regards >> Shuja-ur-Rehman Baig >> _________________________________ >> MS CS - School of Science and Engineering >> Lahore University of Management Sciences (LUMS) >> Sector U, DHA, Lahore, 54792, Pakistan >> Cell: +92 3214207445 > > -- Yours, Zheng http://www.linkedin.com/in/zshao
