[SPARK-31008] Support json_array_length function

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.1.0
• Fix Version/s: 3.1.0
• Component/s: SQL
• Assignee: Rakesh Raushan
• Reporter: Rakesh Raushan
• Created: 02/Mar/20 10:51
• Updated: 08/Apr/20 05:42
• Resolved: 07/Apr/20 22:35

Description

At the moment we don't support json_array_length function in spark.

This function is supported by

a.) PostgreSQL -> https://www.postgresql.org/docs/9.3/functions-json.html

b.) Presto -> https://prestodb.io/docs/current/functions/json.html

c.) redshift -> https://docs.aws.amazon.com/redshift/latest/dg/JSON_ARRAY_LENGTH.html

 

This allows naive users to directly get array length with a well defined json function.

Issue Links

• Blocked: SPARK-31103 Extend Support for useful JSON Functions
• links to: GitHub Pull Request #27759