skip to main content
Supported SQL Functionality
  

Try DataDirect Drivers Now

Supported SQL Functionality

The driver supports Spark SQL and the core SQL grammar (primarily SQL-92). The following topics describe how the driver handles SQL queries in many circumstances.
Note: Spark SQL uses a subset of SQL and HiveQL. While it provides much of the functionality of SQL, the Spark SQL subset of SQL and HiveQL has some differences and limitations. For the latest information, refer to the Spark SQL and DataFrame Guide.
* Data Definition Language
* Selecting Data With the Driver
* From Clause
* Group By Clause
* Having Clause
* Order By Clause
* For Update Clause
* Set Operators
* Subqueries
* SQL Expressions