[jira] [Issue Comment Deleted] (SPARK-29760) Document VALUES statement in SQL Reference.

["Ankit Raj Boudh (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/SPARK-29760?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ankit Raj Boudh updated SPARK-29760:
------------------------------------
    Comment: was deleted

(was: @Sean R. Owen , i will raise PR for this.)

> 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
>            Priority: Minor
>
> 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