You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Max Gekk (Jira)" <ji...@apache.org> on 2023/04/03 08:55:00 UTC

[jira] [Created] (SPARK-43009) Parameterized sql() with constants

Max Gekk created SPARK-43009:
--------------------------------

             Summary: Parameterized sql() with constants
                 Key: SPARK-43009
                 URL: https://issues.apache.org/jira/browse/SPARK-43009
             Project: Spark
          Issue Type: Improvement
          Components: SQL
    Affects Versions: 3.4.0
            Reporter: Max Gekk
            Assignee: Max Gekk


Change Scala/Java/Python APIs to accept any language objects from which would be possible to construct literal columns.

The current implementation the parameterized sql() requires arguments as string values parsed to SQL literal expressions that causes the following issues:
* SQL comments are skipped while parsing, so, some fragments of input might be skipped. For example, 'Europe -- Amsterdam'. In this case, -- Amsterdam is excluded from the input.
* Special chars in string values must be escaped, for instance 'E\'Twaun Moore'



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

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org