> 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]> > >

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]

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

> > > 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]> > >

> 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]>> >> >>

Sam William[EMAIL PROTECTED]

NEW: Monitor These Apps!

All projects made searchable here are trademarks of the Apache Software Foundation.
Service operated by Sematext