You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@ignite.apache.org by liyuj <18...@163.com> on 2019/08/15 09:03:28 UTC

Will ignite support the CREATE SCHEMA statement?

Hi,

Will ignite support the CREATE SCHEMA statement?

Re: Will ignite support the CREATE SCHEMA statement?

Posted by Alexander Korenshteyn <al...@gmail.com>.

Hi,
   Ignite does not support CREATE SCHEMA at this time.
   You can create schemas via configuration:

<bean class="org.apache.ignite.configuration.IgniteConfiguration">
    <property name="sqlSchemas">
        <list>
            <value>MY_SCHEMA</value>
            <value>MY_SECOND_SCHEMA</value>
        </list>
    </property></bean>

then use it when connecting:
more info https://apacheignite-sql.readme.io/docs/schemas


via config or programmatically using CacheConfiguration.setSqlSchema
    <bean class="org.apache.ignite.configuration.CacheConfiguration">
    <property name="sqlSchema" value="mySchema" />

   more details here:
https://apacheignite-sql.readme.io/docs/schema-and-indexes
Thanks, Alex

On Thu, Aug 15, 2019 at 5:03 AM liyuj <18...@163.com> wrote:

> Hi,
>
> Will ignite support the CREATE SCHEMA statement?
>
>