[IGNITE-5886] Ignite SQL Getting Started - ASF JIRA

XML

Word

Printable

JSON

The goal of the task is to create an Ignite SQL Getting Started with the following sections:

Connection to the cluster using JDBC and ODBC drivers. The content/description for both drivers will be the same. The only difference will be in the source code that can be shown in different tabs of "Code Sample" readme.io element. Take a look at the DDL doc [1] that incorporates the source code for Java API and JDBC.
SQL tables and indexes creation using DDL statements [1]. There should be at least two tables. Use the affinity collocation for them. CREATE TABLE command support AFFINITYKEY parameter that can be passed to WITH block.
Preload data using INSERT statements.
Show how to query data with SELECT statements including joins.
Show to update the data sets with UPDATE and DELETE statements.

Here is the page to document (presently it's hidden and visible only for documentation contributors):
https://apacheignite.readme.io/v2.1/docs/getting-started-sql

Use JDBC thin driver [2] for the JDBC connectivity. The ODBC is well documented here [3] and we have a lot of examples for it in Ignite deliverables.

Moreover, as a part of this activity, we will have the ready-to-use source code that should be shared on GitHub and mentioned in the documentation.