[ 
https://issues.apache.org/jira/browse/SPARK-36698?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Apache Spark reassigned SPARK-36698:
------------------------------------

    Assignee:     (was: Apache Spark)

> Allow expand 'quotedRegexColumnNames' in all expressions when it’s expanded 
> to one named expression
> ---------------------------------------------------------------------------------------------------
>
>                 Key: SPARK-36698
>                 URL: https://issues.apache.org/jira/browse/SPARK-36698
>             Project: Spark
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 3.3.0
>            Reporter: Pablo Langa Blanco
>            Priority: Minor
>
> With
> {code:java}
> spark.sql.parser.quotedRegexColumnNames=true{code}
> regular expressions are not allowed in expressions like
> {code:java}
> SELECT `col_.*`/exp FROM (SELECT 3 AS col_a, 1 as exp){code}
>  I propose to improve this behavior and allow this regular expression when it 
> expands to only one named expression. It’s the same behavior in Hive.
> *Example 1:* 
> {code:java}
> SELECT `col_.*`/exp FROM (SELECT 3 AS col_a, 1 as exp){code}
>  col_.* expands to col_a: OK
> *Example 2:*
> {code:java}
> SELECT `col_.*`/col_b FROM (SELECT 3 AS col_a, 1 as col_b){code}
> col_.* expands to (col_a, col_b): Fail like now
>  
> Related with SPARK-36488



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

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

Reply via email to