Re: Text file with ctrl chat as delimiter

2012-06-21 Thread Sam William
rover wrote: >> >>> Sam, >>> If you can please post a row or two of your data along with any errors you >>> are getting, that would be helpful. >>> >>> Mark >>> - Original Message - >>> From: "Mapred Learn" >&

Re: Text file with ctrl chat as delimiter

2012-06-20 Thread Mapred Learn
;> - Original Message - >> From: "Mapred Learn" >> To: user@hive.apache.org >> Cc: user@hive.apache.org >> Sent: Tuesday, June 19, 2012 8:34:22 PM >> Subject: Re: Text file with ctrl chat as delimiter >> >> >> Did

Re: Text file with ctrl chat as delimiter

2012-06-20 Thread Sam William
ting, that would be helpful. > > Mark > - Original Message - > From: "Mapred Learn" > To: user@hive.apache.org > Cc: user@hive.apache.org > Sent: Tuesday, June 19, 2012 8:34:22 PM > Subject: Re: Text file with ctrl chat as delimiter > > > Did

Re: Text file with ctrl chat as delimiter

2012-06-20 Thread Mark Grover
Sam, If you can please post a row or two of your data along with any errors you are getting, that would be helpful. Mark - Original Message - From: "Mapred Learn" To: user@hive.apache.org Cc: user@hive.apache.org Sent: Tuesday, June 19, 2012 8:34:22 PM Subject: Re: Text file

Re: Text file with ctrl chat as delimiter

2012-06-19 Thread Mapred Learn
Did you add the word external in create table I.e. Create external table(...blah...blah...) Sent from my iPhone On Jun 19, 2012, at 4:15 PM, Sam William wrote: > Hi, > I have a data file that is exactly equivalent to a CSV , except that the > field delimiter is a control character specifi

Text file with ctrl chat as delimiter

2012-06-19 Thread Sam William
Hi, I have a data file that is exactly equivalent to a CSV , except that the field delimiter is a control character specifically '\u0001' . How can I create an external table in hive for this data ? For instance . create table ... blah .blah ... row format delimited fields terminated b