You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Akmal Chaudhri (JIRA)" <ji...@apache.org> on 2017/08/17 15:42:00 UTC

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

     [ https://issues.apache.org/jira/browse/IGNITE-5886?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Akmal Chaudhri resolved IGNITE-5886.
------------------------------------
    Resolution: Fixed

> Ignite SQL Getting Started 
> ---------------------------
>
>                 Key: IGNITE-5886
>                 URL: https://issues.apache.org/jira/browse/IGNITE-5886
>             Project: Ignite
>          Issue Type: Task
>            Reporter: Denis Magda
>            Assignee: Akmal Chaudhri
>            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)