Re: Create Table with Line Terminated other than '\n'

2010-06-12 Thread Zheng Shao
That patch basically throws an error if user specified a non-newline line terminator. Without the patch it will produce unexpected result, successfully. Sent from my iPhone On Jun 11, 2010, at 11:23 PM, Amr Awadallah wrote: Zheng, I thought that was fixed per you work here, no? https://i

Re: Create Table with Line Terminated other than '\n'

2010-06-12 Thread Shuja Rehman
ular expression that groups columns > in a row (in your case there will be only one > column). The output.format.string says that %1 grouping is the only column > in this row which is of type string. > > Ashish > > > > ________ > From: Shuja Rehman

Re: Create Table with Line Terminated other than '\n'

2010-06-11 Thread Amr Awadallah
Zheng, I thought that was fixed per you work here, no? https://issues.apache.org/jira/browse/HIVE-302 Then what did you fix? -- amr On 6/10/2010 10:22 PM, Zheng Shao wrote: Also, changing "LINES TERMINATED BY" probably won't work, because hadoop's TextInputFormat does not allow line terminato

RE: Create Table with Line Terminated other than '\n'

2010-06-11 Thread Namit Jain
[athu...@facebook.com] Sent: Friday, June 11, 2010 4:03 PM To: hive-user@hadoop.apache.org Subject: RE: Create Table with Line Terminated other than '\n' The other option is to write use the regular expression serde .. something on the lines... create table xyz(doc STRING) ROW FO

RE: Create Table with Line Terminated other than '\n'

2010-06-11 Thread Ashish Thusoo
lumn in this row which is of type string. Ashish From: Shuja Rehman [mailto:shujamug...@gmail.com] Sent: Friday, June 11, 2010 4:38 AM To: hive-user@hadoop.apache.org Subject: Re: Create Table with Line Terminated other than '\n' Zheng Shao Any other

Re: Create Table with Line Terminated other than '\n'

2010-06-11 Thread Shuja Rehman
Zheng Shao Any other solution??? On Fri, Jun 11, 2010 at 10:38 AM, Shuja Rehman wrote: > 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

Re: Create Table with Line Terminated other than '\n'

2010-06-11 Thread Shuja Rehman
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

Re: Create Table with Line Terminated other than '\n'

2010-06-10 Thread Zheng Shao
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 wrote: > Hi Shuja, > The grammar for Hive's CREATE TABLE statement is discussed > here: http://wiki.ap

Re: Create Table with Line Terminated other than '\n'

2010-06-10 Thread Carl Steinbach
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

Create Table with Line Terminated other than '\n'

2010-06-10 Thread Shuja Rehman
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