[PHOENIX-1661] Implement built-in functions for JSON

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Labels: JSON Java SQL gsoc2015 mentor
• Assignee: LeiWang
• Reporter: James R. Taylor
• Created: 14/Feb/15 06:01
• Updated: 15/Mar/18 12:03

Description

Take a look at the JSON built-in functions that are implemented in Postgres (http://www.postgresql.org/docs/9.3/static/functions-json.html) and implement the same for Phoenix in Java following this guide: http://phoenix-hbase.blogspot.com/2013/04/how-to-add-your-own-built-in-function.html

Examples of functions include ARRAY_TO_JSON, ROW_TO_JSON, TO_JSON, etc. The implementation of these built-in functions will be impacted by how JSON is stored in Phoenix. See PHOENIX-628. An initial implementation could work off of a simple text-based JSON representation and then when a native JSON type is implemented, they could be reworked to be more efficient.

Issue Links

• is a clone of: PHOENIX-1660 Implement missing math built-in functions