[
https://issues.apache.org/jira/browse/IGNITE-5159?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16072983#comment-16072983
]
Alexander Paschenko commented on IGNITE-5159:
---------------------------------------------
[~dmagda]
* We don't create a table *"in"* any cache just as long as {{CREATE TABLE}}
actually creates a cache of its own, no exceptions. Organizations' cache is
used just for the sake of API entry point, nothing else.
* In 2.1, there are following changes: addition of {{PUBLIC}} schema and
possibility of making queries without referring to cache first. Still, we
currently don't have public API for "cacheless" queries, therefore, we are
bound to use some pre-existing cache for API entry point.
Bottom line:
* {{Organizations}} cache has only {{Organizations}} table, nothing else.
* All dynamic tables live in {{PUBLIC}} schema and can't live anywhere else.
* Currently public API entry point for the queries can be only associated with
a cache, no way around, but this does not imply where resulting table will
reside.
We are working on "cacheless" queries execution and public API for it, but for
the moment these things are WIP.
> 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)
