[
https://issues.apache.org/jira/browse/IGNITE-5886?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Denis Magda updated IGNITE-5886:
--------------------------------
Description:
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.
[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
was:
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
> 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.
> 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.
> [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)
