hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Grover <>
Subject Re: Delimiters for nested structures
Date Thu, 09 Feb 2012 14:44:33 GMT
That's correct. See this for reference:

Mark Grover, Business Intelligence Analyst
OANDA Corporation 

www: www: 

"Best Trading Platform" - World Finance's Forex Awards 2009. 
"The One to Watch" - Treasury Today's Adam Smith Awards 2009. 

----- Original Message -----
From: "Aniket Mokashi" <>
To:, "Hao Cheng" <>
Sent: Thursday, February 9, 2012 2:34:29 AM
Subject: Re: Delimiters for nested structures

AFAIK, hive uses default delimiters nested data structures. There is no workaround for this
for now. 
for ( int i = 3; i < serdeParams. separators . length ; i++) { 

serdeParams. separators [i] = ( byte ) (i + 1); 




On Wed, Feb 8, 2012 at 10:15 PM, Hao Cheng < > wrote: 


My data have some map of map structures with customized delimiters. 

As per Hive documents, by default, '\001' is the field separator; starting from '\002', every
2 consecutive characters are the delimiters of 1 level. My data do not follow this rule in
term of delimiters. I mostly just need to handle map of map. I do not find a way in create
table statement to redefine delimiters for more than 1 level nested structures. I try not
to transform the data as it was produced by some other upstream process. 

Any ideas on how to do that in Hive? Thank you for your helps! 


"...:::Aniket:::... Quetzalco@tl" 

View raw message