Hello! I don't think there's an obvious way to convert SQL between dialects. However, if you would use e.g. HQL it would just be a current_date() - 10 . Then it may be converted to many dialects. However, this is out of scope for GridGain, which ...

sorry for late, some examples as below, that is mysql queries. I should convert to ANSI99 queries. <mariadb> SELECT * FROM TO_RECORD WHERE RESULT NOT IN (9) AND reqdate > (curdate() - INTERVAL - 10 DAY) , STR_TO_DATE(msg_date, '%Y-%m-%d') as msg_date ...

Hello! Can you please provide some of these functions along with examples of their intended usage? Thanks, ------------------------------ Ilya Kasnacheev Community Support Specialist GridGain ------------------------------

Does Gridgain also have an Optimizer function that is used by general RDBMS for query optimization? (oracle_ex) analyze table table_name compute statistics ------------------------------ Kim Jinsu SE Olive ------------------------------

Hello! GridGain expects SQL statements to be in its specific dialect, as you have noted. If you were using some higher-level abstraction layer, such as Hibernate, it may convert your queries from higher-level query language or API (such as HQL) to a ...

Hi, Using Gridgain, we are conducting comparative tests with RDBMS (MariaDB). MySQL (MariaDB) has a dedicated function, but Gridgain (Apache Ignite) only supports ANSI-99 SQL based on H2 database engine, so we need to modify the existing application ...