Serge Rielau created SPARK-42919:
------------------------------------
Summary: SELECT * LIKE 'pattern' FROM ....
Key: SPARK-42919
URL: https://issues.apache.org/jira/browse/SPARK-42919
Project: Spark
Issue Type: New Feature
Components: Spark Core
Affects Versions: 3.5.0
Reporter: Serge Rielau
SparkSQL supports *regex_column_names.*
[https://spark.apache.org/docs/latest/sql-ref-syntax-qry-select.html]
However, support depends on a config: spark.sql.parser.quotedRegexColumnNames
The reason is that it overloads proper identifier names.
Here we propose a cleaner, compatible API:
SELECT * LIKE 'pattern';
The semantic should follow common regular expression patterns used for the LIKE
operator with the caveat that it should obey identifier case insensitivity
setting.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
