[jira] Commented: (HIVE-163) support loading json data into hive

["Zheng Shao (JIRA)" <ji...@apache.org>]

    [ 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.