You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by Bruce Packer <br...@gmail.com> on 2019/03/28 23:48:37 UTC

Re: When I use Ignite create table ddl，can I set the db schema instead of the schema name "PUBLIC"？

All,

I need to create a custom schema and then use SQL to create tables in that
schema. The 2.7 docs imply I can.  Is this now possible?  If so, how?  I
have spent many hours trying.

Questions:
    How do I create a custom schema?
         I attempted to add the custom schemas to the xml and it said I
couldn't because PUBLIC has already been defined.
    What is the Ignite JDBC property to specify the custom schema?  
         I then need to add JDBC parameters to use the custom schema from a
JDBC client. Is it SCHEMA=...?  CACHE_NAME=...?    

Thanks,

Bruce



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: When I use Ignite create table ddl，can I set the db schema instead of the schema name "PUBLIC"？

Posted by "kcheng.mvp" <kc...@gmail.com>.
Thank you very much! That's really what I want! Hope it will be released in
2.8.



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: When I use Ignite create table ddl，can I set the db schema instead of the schema name "PUBLIC"？

Posted by Ilya Kasnacheev <il...@gmail.com>.
Hello!

I guess you could watch https://issues.apache.org/jira/browse/IGNITE-5780

Regards,
-- 
Ilya Kasnacheev


сб, 30 мар. 2019 г. в 19:41, kcheng.mvp <kc...@gmail.com>:

> For the case describe in the thread
>
> http://apache-ignite-users.70518.x6.nabble.com/Re-Can-t-add-new-key-value-pair-to-existing-cache-via-sql-command-td25126.html#none
>
> <
> http://apache-ignite-users.70518.x6.nabble.com/file/t100/WX20190331-003651%402x.png>
>
>
>
>
> is there a jira trick it ? or when this limit will be removed? I have used
> ignite in production in a system. so far so good. I would like to use
> ignite
> in another big system.(more tables, more business changes) I just want to
> keep the tables in one business module in just one cache
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>

Re: When I use Ignite create table ddl，can I set the db schema instead of the schema name "PUBLIC"？

Posted by "kcheng.mvp" <kc...@gmail.com>.
For the case describe in the thread
http://apache-ignite-users.70518.x6.nabble.com/Re-Can-t-add-new-key-value-pair-to-existing-cache-via-sql-command-td25126.html#none

<http://apache-ignite-users.70518.x6.nabble.com/file/t100/WX20190331-003651%402x.png> 



is there a jira trick it ? or when this limit will be removed? I have used
ignite in production in a system. so far so good. I would like to use ignite
in another big system.(more tables, more business changes) I just want to
keep the tables in one business module in just one cache



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: When I use Ignite create table ddl，can I set the db schema instead of the schema name "PUBLIC"？

Posted by Ilya Kasnacheev <il...@gmail.com>.
Hello!

When using CacheConfiguration
<https://apacheignite.readme.io/docs/indexes#queryentity-based-configuration>
you can specify schema. Not sure it is possible for CREATE TABLE.

Regards,
-- 
Ilya Kasnacheev


пт, 29 мар. 2019 г. в 02:48, Bruce Packer <br...@gmail.com>:

> All,
>
> I need to create a custom schema and then use SQL to create tables in that
> schema. The 2.7 docs imply I can.  Is this now possible?  If so, how?  I
> have spent many hours trying.
>
> Questions:
>     How do I create a custom schema?
>          I attempted to add the custom schemas to the xml and it said I
> couldn't because PUBLIC has already been defined.
>     What is the Ignite JDBC property to specify the custom schema?
>          I then need to add JDBC parameters to use the custom schema from a
> JDBC client. Is it SCHEMA=...?  CACHE_NAME=...?
>
> Thanks,
>
> Bruce
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>