Data Manipulation Language (DML)
This section walks you through all data manipulation language (DML) commands supported by GridGain 9.0.
SELECT
Retrieves data from a table or multiple tables.
SELECT [ hintComment ] [ ALL | DISTINCT ]
{ * | projectItem [, projectItem ]* }
FROM tableExpression
[ WHERE booleanExpression ]
[ GROUP BY { groupItem [, groupItem ]* } ]
[ HAVING booleanExpression ]JOINs
GridGain supports colocated and non-colocated distributed SQL joins. Furthermore, if the data resides in different tables, GridGain allows for cross-table joins as well. Joins between partitioned and replicated data sets always work without any limitations. However, if you join partitioned data sets, then you have to make sure that the keys you are joining on are either colocated or make sure you switched on the non-colocated joins parameter for a query.
INSERT
Inserts data into a table.
{ INSERT } INTO tablePrimary
[ '(' column [, column ]* ')' ]
queryUPDATE
Updates data in a table.
UPDATE tablePrimary
SET assign [, assign ]*
[ WHERE booleanExpression ]DELETE
Deletes data from a table.
DELETE FROM tablePrimary [ [ AS ] alias ]
[ WHERE booleanExpression ]© 2024 GridGain Systems, Inc. All Rights Reserved. Privacy Policy | Legal Notices. GridGain® is a registered trademark of GridGain Systems, Inc.
Apache, Apache Ignite, the Apache feather and the Apache Ignite logo are either registered trademarks or trademarks of The Apache Software Foundation.