Ganesha S created SPARK-58686:
---------------------------------

             Summary: Support ANSI SQL/JSON functions
                 Key: SPARK-58686
                 URL: https://issues.apache.org/jira/browse/SPARK-58686
             Project: Spark
          Issue Type: Umbrella
          Components: SQL
    Affects Versions: 4.3.0
            Reporter: Ganesha S


Umbrella for the ANSI SQL:2016 scalar/constructor JSON functions, which Spark 
does not yet provide: JSON_VALUE, JSON_QUERY, JSON_EXISTS (query/inspect) and 
JSON_OBJECT, JSON_ARRAY (construct). These standard names are supported by 
Oracle, SQL Server, PostgreSQL, Trino, BigQuery, and others; adding them lets 
migrated queries run unchanged with their intended NULL/error semantics.

Each function is tracked as a sub-task:
* JSON_VALUE  (SPARK-58685)
* JSON_EXISTS
* JSON_QUERY
* JSON_OBJECT
* JSON_ARRAY



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to