[jira] [Created] (IGNITE-5886) Ignite SQL Getting Started

["Denis Magda (JIRA)" <ji...@apache.org>]

Denis Magda created IGNITE-5886:
-----------------------------------

             Summary: Ignite SQL Getting Started 
                 Key: IGNITE-5886
                 URL: https://issues.apache.org/jira/browse/IGNITE-5886
             Project: Ignite
          Issue Type: Task
            Reporter: Denis Magda
            Priority: Critical
             Fix For: 2.2


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.  

[1] https://apacheignite.readme.io/v2.1/docs/distributed-ddl
[2] https://apacheignite.readme.io/v2.1/docs/jdbc-driver#jdbc-thin-driver
[3] https://apacheignite.readme.io/v2.1/docs/odbc-driver



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)