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)
