Hi Sam, Could you try '\001' instead of '\u0001' ? Sent from my iPhone
On Jun 20, 2012, at 3:57 PM, Sam William <[email protected]> wrote: > > > 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" <[email protected]> >> To: [email protected] >> Cc: [email protected] >> 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 < [email protected] > 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 >> [email protected] >> >> >> > > Sam William > [email protected] > > >
