[
https://issues.apache.org/jira/browse/IGNITE-5159?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16072977#comment-16072977
]
Denis Magda commented on IGNITE-5159:
-------------------------------------
[~al.psc], please consider the following:
* {{Person}} table needs to be created in person's cache and not in the
organization cache. As far as I remember, in the future there will be only one
table (sql schema) to cache mapping.
* please use a unique name for the primary keys and use them instead of
{{_key}}. Do the same for {{_val}} if any.
> Create DDL Example
> ------------------
>
> Key: IGNITE-5159
> URL: https://issues.apache.org/jira/browse/IGNITE-5159
> Project: Ignite
> Issue Type: Task
> Components: examples, sql
> Reporter: Denis Magda
> Assignee: Alexander Paschenko
> Priority: Blocker
> Labels: important
> Fix For: 2.1
>
>
> We need to create a DDL example(s) that will demonstrate the following:
> - caches creation and removal using CREATE and DROP table commands.
> - indexes creation and removal using CREATE and DROP index commands.
> If CREATE SCHEME is supported by 2.1 then its usage should be demonstrated as
> well.
> The example(s) has to be placed into new "sqlgrid" directory of the examples.
> `CacheQueryExample` and `CacheQueryDmlExample` have to be moved there as
> well.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)