Re: Re[2]: Run sql query on key-value cache

[Ilya Kasnacheev]

Hello!

Yes, it does indeed seem that you can now enable indexing on a cache by
doing "CREATE TABLE ... WITH "cache_name=<existing cache>";

+ dev@

Do we have this documented anywhere? Updating CREATE TABLE docs and Schema
and Indexing would be nice.

https://ignite.apache.org/docs/latest/SQL/indexes#creating-indexes-with-sql
should also refer to CREATE TABLE btw.

Regards,
--
Ilya Kasnacheev


пт, 12 мар. 2021 г. в 13:40, Zhenya Stanilovsky <[hidden email]>:

> Ilya, seems you mistaken, check [1]
> Seems there is no additional documentation, but API is simple , check
> example [2].
>
> [1] https://issues.apache.org/jira/browse/IGNITE-12808
> [2]
> https://github.com/apache/ignite/pull/7627/files#diff-d0f1fdd4e070c92459cb4f1e600977bd4819216e658ff2114fe19bfeb2a93232R1000
>
>
> Hello!
>
> Once a cache is created, you can't add indexes. You will need to recreate
> cache / restart cluster with updated configuration.
>
> You can define caches with Query Entities in spring XML configuration,
> pass it to IgniteConfguration instance.
>
> Regards,
> --
> Ilya Kasnacheev
>
> пт, 12 мар. 2021 г. в 07:07, rakshita04 <[hidden email]
> <//e.mail.ru/compose/?mailto=mailto%[hidden email]>>:
>
> How can we create indexes on our existing <key,value> cache.
> As far as i could see on your portal no API support is available for C++
> for
> creating indexes.
> does Query Entity automatically takes care of creating indexes? or we need
> to explicitly create indexes on our <key,value> cache?
> if we need to explicitly create , can you please help us how to do that?
>
> regards,
> Rakshita Chaudhary
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>
>
>
>
>
>