Re: CTE and Recursive CTE support in SQL

H2 has limited support for Recursive CTE. http://h2database.com/html/advanced.html#recursive_queries Does Ignite supports all SQL features which H2 has ? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: CTE and Recursive CTE support in SQL

When is Recursive CTE planned ? Recursive CTE is super powerful. https://www.postgresql.org/docs/current/static/queries-with.html https://docs.microsoft.com/en-us/sql/t-sql/queries/with-common-table-expression-transact-sql?view=sql-server-2017 -- Sent from:

CTE and Recursive CTE support in SQL

When Common Table Expression (CTE) and Recursive CTE are planned to be part of supported SQL syntax ? It would be super productive to have Support for CTE as we can do Graph like Traversals and many complex queries. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Distributed Database as best choice for persistence

Thanks Dmitry -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Distributed Database as best choice for persistence

>> What's the point of scaling persistence manually over allowing Ignite to scale both RAM and disk layers for you? Why there exists an official plugin for Cassandra integration then ? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Distributed Database as best choice for persistence

>> May I ask why don't you want to go for Ignite persistence? To operate and scale the storage layer independently and process related to it like Compaction for example. I intent to bundle WebServer (Netty) + Application Server (Netty) + DB Engine (Ignite) + Cache in single deployable jar

Re: Distributed Database as best choice for persistence

cool. Does it maintain transactions ? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Distributed Database as best choice for persistence

which is best choice of distributed persistence for Ignite if we dont want to use native persistence ? Riak ? Cassandra ? Dynamo DB ? Has anyone tried this ? what was the experience ? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Ignite on Graal VM

Has anybody tried Ignite on GraalVM 1.0 ? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Intermittent Spikes in Response Time

It's hard to tell unless actual code written is known. Although try using this JVM parameters. -Xss256K ;; limit threadstack size -XX:MaxGCPauseMillis=25 ;; limit max GC pause to 25ms More tuning settings here

Re: Sorting or ranking TextQuery?

Is Ranking implemented in latest version 2.4 or at least in roadmap ? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Disk Persistence Performance

Thanks for relevant links. Just to be clear, When you say disk latency is (20 - 500 ms) did you mean microsecond or millisecond ? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Disk Persistence Performance

Thanks Denis. In my application I intend to allocated upto 25% of Data in RAM and rest (75%) on disk. Benchmark link given showcases data fetched from RAM. Are there any benchmarks around how fast is disk KV store which comes bundled as part of Ignite ? What's the average latency value we can

Re: Azul Zing JVM with Apache Ignite

Since Azul Zing promises less than 4-5ms pause on upto 8TB of heap, it's okay to store data on heap and that way you can also save some efforts which you cant when you use unsafe class with off memory. Please let me know if someone thinks otherwise on this. One other advantage I see is Azul

Re: Re: About Apache Ignite 2.4 with jdk

If possible dont rebuild the source, just use JDK8 instead of JDK7. According my observation in my project JDK8 performs lot better than JDK7 when it comes to lots of computing and dealing with GC and large Heap sizes. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Azul Zing JVM with Apache Ignite

Is anybody using Azul's Zing JVM with Ignite ? How was the experience ? Does it help in some way as they claim ? https://www.azul.com/products/zing/ -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Topic based messaging

thanks Dmitry. looks like i need to stick to distributed Queue as it supports replicated backup copy. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Topic based messaging

Thanks. Can it have extra backup copies in Ignite Cluster (for HA or fault tolerance) ? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Topic based messaging

Has anybody used this feature ? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: POSIX compliant NFS storage

Nobody tried NFS storage with Ignite ? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Graph Query Integration

Native Graph Db like Neo4J etc. are not distributed. All distributed Graph DBs like DGraph (with Badger), JanusGraph (with Cassandra/HBase) are all based on Key Value Database for a good reason that its a Key Value structure which provides best scaling Capabilities. I would go to the extent saying

Custom aggregate SQL function

https://apacheignite-sql.readme.io/docs/custom-sql-functions We can define the custom sql function as mentioned in the doc. Is it possible to define custom aggregate function ? An example would be great if possible. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Forcing indexes on heap

Thanks Mikael. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Graph Query Integration

Apache Ignite has SQL layer using H2 parser. is there any library which facilitates Graph Layer over Ignite's KV store. For example in java community we have Gremlin and Tinkerpop. Is the integration of such libraries exist or planned in future ? -- Sent from:

POSIX compliant NFS storage

Is Apache ignite tested with any POSIX compliant Network File System Storage ? For example, AWS has EFS: https://docs.aws.amazon.com/efs/latest/ug/whatisefs.html If we mount NFS disk for each node in Ignite cluster, will data have to be replicated or we can have single copy on NFS ? -- Sent

Topic based messaging

With Regards to "Topic Based Messaging" mentioned in official doc here https://apacheignite.readme.io/docs/messaging Can it be a distributed alternative to Apache Kafka ? Can it have extra backup copies ? Can it use disk persistence with extra backup copies on another node just like tables ?

Re: Disk Persistence Performance

Thanks Stanislav. I didnt know we could define multiple data regions and attach them to different cache region. Can you give a short an example for it or perhaps link for Document/blog which does the same ? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Disk Persistence Performance

Cache is based on hit or miss ratio or simple LRU But as I mentioned in point #3 there might be services which hit multiple times but good latency is not the requirement. I dont want cache to evict any records when querying to such few Tables. -- Sent from:

Re: Disk Persistence Performance

Thanks Stanislav. About the use case of certain tables to be Disk only is that: 1. OLAP Report queries on Tables for which access patterns are rare or time bound and minimum e.g. creating management report from my web application 2. Materialized view tables which are created by listening to

Disk Persistence Performance

In my case, config of application will be1. 3 Nodes with 24GB RAM and up to 1TB of disk data 2. Ignite is embedded in Java web application server 3. Azul Zing JVM with on heap Ignite cache of 16GB4. 100mbps network speed or better5. each node will have to serve at least 10K req/sec. each request