Mark, I did not get any errors, but it seemed like the splitting was happening with u,0,1 as delimiters. My temporary fix is to define a table with one field and create a view split function on top . I dont want this additional overheard, if I can make the input format work with the ctrl char as the delimiter. Mapred Learn,
Yes I did have the word 'external' in the create table statement. Thanks, Sam On Jun 20, 2012, at 6:24 AM, Mark Grover 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" <mapred.le...@gmail.com> > 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 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 < sa...@stumbleupon.com > wrote: > > > > > > > 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 by '\u0001' stored as textfile > location '/tmp/myloc'; > > > did not work . > > > Thanks > > > > > Sam William > sa...@stumbleupon.com > > > Sam William sa...@stumbleupon.com
