Re: Ignite H2 to Calcite issues

2024-08-16 Thread Alex Plehanov
Amit, Can you please show the output of "EXPLAIN PLAN FOR "? I've found the bug in index scan on binary object field (ticket [1]), but I can't reproduce it with select without "order by", or without forcing index scan. [1]: https://issues.apache.org/jira/browse/IGNITE-23004 ср, 14 авг. 2024 г. в

Re: Ignite H2 to Calcite issues

2024-08-16 Thread Amit Jolly
Hi Alex, Find below the details you requested. CacheConfiguration cacheConfiguration = new CacheConfiguration<>(); cacheConfiguration.setCacheMode(CacheMode.PARTITIONED); cacheConfiguration.setBackups(2); cacheConfiguration.setExpiryPolicyFactory(CreatedExpiryPolicy.factoryOf(new Duration(MINUTES

Re: Ignite H2 to Calcite issues

2024-08-16 Thread Amit Jolly
Hi Alex, Also looks like the query does work with this error/warning. But not sure what's the implication on the result or overall performance. Thanks, Amit Jolly On Fri, Aug 16, 2024 at 10:03 AM Amit Jolly wrote: > Hi Alex, > > Find below the details you requested. > > CacheConfiguration cac