[
https://issues.apache.org/jira/browse/IGNITE-6242?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Denis Magda updated IGNITE-6242:
--------------------------------
Description:
Once CREATE TABLE is executed Ignite:
* will create an IgniteCache naming it SQL_PUBLIC_\{TABLE\}. So, if a Person
table is created you’ll have SQL_PUBLIC_PERSON cache in the cluster.
* will use autogenerated names for the key and value types. For instance, this
is how the type name might look like
SQL_PUBLIC_CITY_3f4e9fbf_3464_4598_8394_1307b86dc4e7_KEY.
The goal of the ticket is to give a way to pass a custom cache name, key's type
name, value's type name into WITH clause.
Refer to this discussion for more details:
http://apache-ignite-developers.2346864.n4.nabble.com/Key-value-access-to-caches-created-with-DDL-td21622.html
http://apache-ignite-developers.2346864.n4.nabble.com/Override-cache-name-created-with-CREATE-TABLE-td21456.html
was:
CREATE TABLE automatically creates an IgniteCache naming it
SQL_PUBLIC_\{TABLE\}. So, if a Person table is created you’ll have
SQL_PUBLIC_PERSON cache in the cluster.
If we keep to SQL APIs the cache name is not a big deal but as soon as
key-value, compute, service grid APIs are needed the cache name will be used
here and there looking bizarre.
Let's give a way to pass the cache name into WITH clause parameters set
> Passing custom cache and type names to CREATE TABLE
> ---------------------------------------------------
>
> Key: IGNITE-6242
> URL: https://issues.apache.org/jira/browse/IGNITE-6242
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Affects Versions: 2.1
> Reporter: Denis Magda
> Assignee: Alexander Paschenko
> Priority: Critical
> Labels: usability
> Fix For: 2.3
>
>
> Once CREATE TABLE is executed Ignite:
> * will create an IgniteCache naming it SQL_PUBLIC_\{TABLE\}. So, if a Person
> table is created you’ll have SQL_PUBLIC_PERSON cache in the cluster.
> * will use autogenerated names for the key and value types. For instance,
> this is how the type name might look like
> SQL_PUBLIC_CITY_3f4e9fbf_3464_4598_8394_1307b86dc4e7_KEY.
> The goal of the ticket is to give a way to pass a custom cache name, key's
> type name, value's type name into WITH clause.
> Refer to this discussion for more details:
> http://apache-ignite-developers.2346864.n4.nabble.com/Key-value-access-to-caches-created-with-DDL-td21622.html
> http://apache-ignite-developers.2346864.n4.nabble.com/Override-cache-name-created-with-CREATE-TABLE-td21456.html
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
