[
https://issues.apache.org/jira/browse/HIVE-163?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12655556#action_12655556
]
Zheng Shao commented on HIVE-163:
---------------------------------
I would suggest to first add a JSONField function that extracts an JSON field:
{code}
class UDFJsonField {
/** Extracts a field of a JSON object.
* @param jsonObject The main JSON Object in string format
* @param field The field expression, e.g. "[1]a.b[3].c"
* @return the JSON Object that represents the field in string format
*/
String evaluate(String jsonObject, String field) {
...
}
}
{code}
This function will support most of the requests.
> support loading json data into hive
> -----------------------------------
>
> Key: HIVE-163
> URL: https://issues.apache.org/jira/browse/HIVE-163
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: Serializers/Deserializers
> Reporter: Hao Liu
> Original Estimate: 168h
> Remaining Estimate: 168h
>
> The JSON format is commonly used for transmitting structured data over a
> network, especially for ajax web applications. People also choose json format
> to store log data.
> Support loading and query json format data will be a desirable features in
> Hive.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
