Spark SQL DML

Data Manipulation Language in Spark SQL

Some DML statements (like the ever-present SELECT) may appear to be standard across SQL flavors, but the manipulation done in a database can vary widely based on the characteristics of that database. Some statements can be pretty tricky.

Here's a quick look at an initial set of some DML statements to consider:

• MERGE

• SELECT

Let's dig in on each of these.