[SPARK-43139] Bug in INSERT INTO documentation

• Type: Documentation
• Status: Resolved
• Priority: Trivial
• Resolution: Fixed
• Affects Version/s: 3.3.2
• Fix Version/s: 3.4.1, 3.5.0
• Component/s: Documentation
• Assignee: Yuming Wang
• Reporter: Bjorn Olsen
• Created: 14/Apr/23 09:00
• Updated: 16/Apr/23 06:59
• Resolved: 16/Apr/23 06:59

Description

I think there is a bug in this page https://spark.apache.org/docs/3.1.2/sql-ref-syntax-dml-insert-into.html

The following SQL statement does not look valid based on the contents of the "applicants" table.

INSERT INTO students
     FROM applicants SELECT name, address, id applicants WHERE qualified = true; 

Specifically, "id applicants" should possibly be changed to "student_id"