Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-41281 Feature parity: SparkSession API in Spark Connect
  3. SPARK-44178

Positional parameters in sql()

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 3.5.0
    • 3.5.0
    • Connect
    • None

    Description

      As a follow-up to the parameterized query we added recently, we’d like to support positional parameters. This is part of the SQL standard and JDBC/ODBC protocol.

      Example: update COFFEES set TOTAL = TOTAL + ? where COF_NAME = ?

      Note that positional and named param marker cannot be used in the same query.

      Attachments

        Issue Links

          is a clone of

          Sub-task - The sub-task of the issue SPARK-42402 Support parameterized SQL by sql()

          • Major - Major loss of function.
          • Resolved
          is cloned by

          Sub-task - The sub-task of the issue SPARK-44189 Support positional parameters in sql() by python connect client

          • Major - Major loss of function.
          • Resolved
          is duplicated by

          New Feature - A new feature of the product, which has yet to be developed. SPARK-44068 Support positional parameters in Scala connect client

          • Major - Major loss of function.
          • Resolved

          Activity

            People

              maxgekk Max Gekk
              maxgekk Max Gekk
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: