Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-28588 Build a SQL reference doc
  3. SPARK-29760

Document VALUES statement in SQL Reference.

    XMLWordPrintableJSON

    Details

    • Type: Sub-task
    • Status: Resolved
    • Priority: Minor
    • Resolution: Won't Fix
    • Affects Version/s: 2.4.4
    • Fix Version/s: None
    • Component/s: Documentation, SQL
    • Labels:
      None

      Description

      spark-sql also supports *VALUES *.

      spark-sql> VALUES (1, 'one'), (2, 'two'), (3, 'three');
      1       one
      2       two
      3       three
      Time taken: 0.015 seconds, Fetched 3 row(s)
      spark-sql>
      
      spark-sql> VALUES (1, 'one'), (2, 'two'), (3, 'three') limit 2;
      1       one
      2       two
      Time taken: 0.014 seconds, Fetched 2 row(s)
      spark-sql>
      spark-sql> VALUES (1, 'one'), (2, 'two'), (3, 'three') order by 2;
      1       one
      3       three
      2       two
      Time taken: 0.153 seconds, Fetched 3 row(s)
      spark-sql>
      

      or even *values *can be used along with INSERT INTO or select.
      refer: https://www.postgresql.org/docs/current/sql-values.html

      So please confirm VALUES also can be documented or not.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              jobitmathew jobit mathew
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: