hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Grover <mgro...@oanda.com>
Subject Re: Delimiters for nested structures
Date Thu, 09 Feb 2012 14:44:33 GMT
That's correct. See this for reference: https://issues.apache.org/jira/browse/HIVE-365

Mark Grover, Business Intelligence Analyst
OANDA Corporation 

www: oanda.com www: fxtrade.com 
e: mgrover@oanda.com 

"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" <aniket486@gmail.com>
To: user@hive.apache.org, "Hao Cheng" <haoc.cheng@yahoo.com>
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); 

} 

Thanks, 

Aniket 

On Wed, Feb 8, 2012 at 10:15 PM, Hao Cheng < haoc.cheng@yahoo.com > wrote: 





Hi, 


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! 



Regards, 
Hao 



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

Mime
View raw message