[jira] [Created] (SPARK-29760) Document VALUES statement in SQL Reference.

["jobit mathew (Jira)" <ji...@apache.org>]

jobit mathew created SPARK-29760:
------------------------------------

             Summary: Document VALUES statement in SQL Reference.
                 Key: SPARK-29760
                 URL: https://issues.apache.org/jira/browse/SPARK-29760
             Project: Spark
          Issue Type: Sub-task
          Components: Documentation, SQL
    Affects Versions: 2.4.4
            Reporter: jobit mathew


spark-sql also supports *VALUES *.

{code:java}
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>
{code}
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.



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

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