[SPARK-29760] Document VALUES statement in SQL Reference.

• Type: Sub-task
• Status: Resolved
• Priority: Minor
• Resolution: Won't Fix
• Affects Version/s: 2.4.4
• Component/s: Documentation, SQL
• Assignee: Unassigned
• Reporter: jobit mathew
• Created: 05/Nov/19 12:49
• Updated: 02/Jan/20 16:41
• Resolved: 16/Nov/19 20:36

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.