hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Evan Pollan <>
Subject Re: Delimiters for nested structures
Date Thu, 09 Feb 2012 13:54:16 GMT
+1. I've had good luck with json and get_json_object.

On Feb 9, 2012, at 7:39 AM, "Tucker, Matt" <<>>

What about creating a view that converts your data into JSON or XML?  You can then make use
of the get_json_object<>()
or xpath<>() functions.

Matt Tucker

From: Hao Cheng []
Sent: Thursday, February 09, 2012 1:15 AM
Subject: Delimiters for nested structures


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!

View raw message