Hi yeah Zheng,hadoop does not allowing other than \n. as i tried like this *create table test (xmlFile String)ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\001' ;*
but it giving me the error saying that *ERROR ql.Driver: FAILED: Error in semantic analysis: LINES TERMINATED BY only supports newline '\n' right now* Then what can be the solution???? ANY HELP????????????? On Fri, Jun 11, 2010 at 7:22 AM, Zheng Shao <[email protected]> wrote: > 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 > -- 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
