[jira] [Assigned] (IMPALA-376) Built-in functions for parsing JSON

["Quanlong Huang (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IMPALA-376?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Quanlong Huang reassigned IMPALA-376:
-------------------------------------

    Assignee: Quanlong Huang

> Built-in functions for parsing JSON
> -----------------------------------
>
>                 Key: IMPALA-376
>                 URL: https://issues.apache.org/jira/browse/IMPALA-376
>             Project: IMPALA
>          Issue Type: New Feature
>          Components: Backend
>    Affects Versions: Product Backlog
>         Environment: All supported environments
>            Reporter: Zoltan Toth-Czifra
>            Assignee: Quanlong Huang
>            Priority: Minor
>              Labels: built-in-function
>
> Hi,
> Hive comes with some useful built-in UDFs to process JSON objects.
> https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF
> Namely:
> - get_json_object
> - json_tuple
> To make Impala and Hive tables and quieries more interchangable, I am proposing porting these UDFs to be part Impala's built in functions:
> http://www.cloudera.com/content/cloudera-content/cloudera-docs/Impala/latest/Installing-and-Using-Impala/ciiu_functions.html
> h4. Example
> Consider the following table *raw_log*
> ||action||parameters||
> |search|{"keyword":"hotel"}|
> |visit|{"url":"http://example.com"}|
> ...and the following query:
> {code}
> SELECT get_json_object(event_params, "$.keyword") AS keyword FROM raw_log WHERE action='search';
> {code}
> The query should return the following results:
> ||keyword||
> |hotel|



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org