[
https://issues.apache.org/jira/browse/IMPALA-376?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16624444#comment-16624444
]
Quanlong Huang commented on IMPALA-376:
---------------------------------------
Thanks, [~grahn]! Based on the discussion in the email list, we'll support both
Hive's get_json_object function and the ANSI JSON functions. I create
IMPALA-7609 to track the support of ANSI JSON functions.
> 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: [email protected]
For additional commands, e-mail: [email protected]
