Re: Reliably duplicate SQL cache

2021-02-18 Thread Ilya Kasnacheev
Hello! It will be available in cache's Query Entities so you can try: ((CacheConfiguration)ignite.cache("SQL_PUBLIC_") .getConfiguration(CacheConfiguration.class)).getQueryEntities().iterator().next().getValueType() Regards, -- Ilya Kasnacheev чт, 18 февр. 2021 г. в 11:40, Courtney Robi

Re: Reliably duplicate SQL cache

2021-02-18 Thread Courtney Robinson
Hi Illya, Thanks for responding. That makes sense - I figured something like that but didn't know exactly what. Is it possible to get the existing key_type and value_type for tables? The reason is because we have tables in production and they were not created with key_type and value_type. We actual

Re: Reliably duplicate SQL cache

2021-02-15 Thread Ilya Kasnacheev
Hello! Two tables have different name of an indexed binary type by default. Try repo.query("create table page1(a varchar, b varchar, c varchar, PRIMARY KEY (a, b)) WITH \"cache_name=page1, key_type=PageKey, value_type=Page\"") repo.query("create table page2(a varchar, b varchar, c varchar, PRIMAR

Reliably duplicate SQL cache

2021-02-13 Thread Courtney Robinson
Due to an issue I posted about in a previous thread http://apache-ignite-users.70518.x6.nabble.com/Basic-SQL-pagination-returning-incorrect-results-td35443.html I've written a work around to use the streamer interface with a ScanQuery to duplicate a cache. Both are created from SQL using something