[ https://issues.apache.org/jira/browse/IMPALA-376?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Work on IMPALA-376 started by 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-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org