[PHOENIX-628] Support native JSON data type

• Type: Task
• Status: In Progress
• Resolution: Unresolved
• Affects Version/s: 5.1.4
• Fix Version/s: 4.4.1, 5.3.0
• Labels: JSON Java SQL
• old issue number: 497
• Assignee: Ranganath Govardhanagiri
• Reporter: James R. Taylor
• Created: 10/Mar/14 23:47
• Updated: 5 days ago 02:19

Description

MongoDB and Postgres do some interesting things with JSON. We should look at adding similar support. For a detailed description, see JSONB support in Postgres:
http://www.craigkerstiens.com/2014/03/24/Postgres-9.4-Looking-up
http://www.depesz.com/2014/03/25/waiting-for-9-4-introduce-jsonb-a-structured-format-for-storing-json/
http://michael.otacoo.com/postgresql-2/manipulating-jsonb-data-with-key-unique/

Issue Links

• links to: GitHub Pull Request #1667
• links to: GitHub Pull Request #1769
• links to: GitHub Pull Request #1780

Sub-Tasks

• Add JSON type to Phoenix: Resolved
• Implement the json_extract_path_text built-in function: Closed
• Implement built-in functions for JSON: Closed
• Implement JSON operators: Closed
• Support Index on a generated column that extracts a scalar value from the JSON column: Resolved
• Implement json_query function on the json object: Resolved
• Implement json_value function on the json object: Resolved
• Implement json_modify function on the json object: Resolved
• Parse JSON columns on the server side: Resolved
• Document JSON functionality on the Phoenix Site: Patch Available
• Implement JSON_EXISTS function on json object: Resolved
• Validate Partial Index support with JSON: Resolved