[ 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-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org