[
https://issues.apache.org/jira/browse/SPARK-50276?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Chenghao Lyu updated SPARK-50276:
---------------------------------
Description:
Support JSON path expression by adding COLON sign operator [1] and JSON path
expression [2]
[1]
[https://docs.databricks.com/en/sql/language-manual/functions/colonsign.html]
[2]
[https://docs.databricks.com/en/sql/language-manual/sql-ref-json-path-expression.html]
Syntax:
{code:java}
jsonExpr : jsonPath
{code}
jsonExpr can be either a VariantType or a valid JSON String.
* when jsonExpr is a valid JSON String, forward it to an inner function
`semi_structured_extract_json_multi`(to be added with a new RegaxParser)
* when jsonExpr is a VariantType, forward it to the built-in function
[variant_get|https://spark.apache.org/docs/4.0.0-preview1/api/sql/#variant_get]
was:
Support JSON path expression by adding COLON sign operator [1] and JSON path
expression [2]
[1]
[https://docs.databricks.com/en/sql/language-manual/functions/colonsign.html]
[2]
[https://docs.databricks.com/en/sql/language-manual/sql-ref-json-path-expression.html]
Syntax:
{code:java}
jsonExpr : jsonPath
{code}
jsonExpr can be either a VariantType or a valid JSON String.
* when jsonExpr is a valid JSON String, forward it to an inner function
`semi_structured_extract_json_multi`(to be added)
* when jsonExpr is a VariantType, forward it to the built-in function
[variant_get|https://spark.apache.org/docs/4.0.0-preview1/api/sql/#variant_get]
> Add JSON path expression using the COLON operator
> -------------------------------------------------
>
> Key: SPARK-50276
> URL: https://issues.apache.org/jira/browse/SPARK-50276
> Project: Spark
> Issue Type: New Feature
> Components: SQL
> Affects Versions: 4.0.0
> Reporter: Chenghao Lyu
> Priority: Major
>
> Support JSON path expression by adding COLON sign operator [1] and JSON path
> expression [2]
> [1]
> [https://docs.databricks.com/en/sql/language-manual/functions/colonsign.html]
> [2]
> [https://docs.databricks.com/en/sql/language-manual/sql-ref-json-path-expression.html]
>
> Syntax:
> {code:java}
> jsonExpr : jsonPath
> {code}
> jsonExpr can be either a VariantType or a valid JSON String.
> * when jsonExpr is a valid JSON String, forward it to an inner function
> `semi_structured_extract_json_multi`(to be added with a new RegaxParser)
> * when jsonExpr is a VariantType, forward it to the built-in function
> [variant_get|https://spark.apache.org/docs/4.0.0-preview1/api/sql/#variant_get]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
