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 >
