SQL Functionality for the Driver for Apache Spark SQL

The Progress DataDirect for ODBC for Apache Spark SQL Wire Protocol driver support an extended set of SQL 92, in addition to the syntax for Apache Spark SQL, which is a subset of SQL 92.

This chapter describes the supported functionality and restrictions for the SQL statements and SQL extensions.

Refer to the Spark SQL Programming Guide for information about using Apache Spark SQL.

In this section:

Data Definition Language (DDL)

Selecting Data With the Driver

From Clause

Group By Clause

Having Clause

Order By Clause

For Update Clause

Set Operators

Subqueries

SQL Expressions