Re: Field delimiter in hive

try "~|~" as field delimiter. It normally works for most conditions Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw *

Re: Field delimiter in hive

I’ve been pretty successful with two pipes (||) or two carets (^^) based on my dataset even though they aren’t unicode. > On Mar 7, 2016, at 8:32 PM, mahender bigdata > wrote: > > Any help on this. > > On 3/3/2016 2:38 PM, mahender bigdata wrote: >> Hi, >> >>

Re: Field delimiter in hive

Any help on this. On 3/3/2016 2:38 PM, mahender bigdata wrote: Hi, I'm bit confused to know which character should be taken as delimiter for hive table generically. Can any one suggest me best Unicode character which doesn't come has part of data. Here are the couple of options, Im

Field delimiter in hive

Hi, I'm bit confused to know which character should be taken as delimiter for hive table generically. Can any one suggest me best Unicode character which doesn't come has part of data. Here are the couple of options, Im thinking off for Field Delimiter. Please let me know which is best one