Apache Ignite

Wednesday November 01, 2017

Apache Ignite 2.3 - More SQL and Persistence Capabilities

Putting aside the regular bug fixes and performance optimizations, the Apache Ignite 2.3 release brings new SQL capabilities and Ignite persistence improvements that are worth mentioning.


Let's start with SQL first.

Apache Ignite users have consistently told us that despite all of Ignite’s SQL capabilities, it’s been at times challenging trying to figure out how to start using Ignite as an SQL database.

This was mostly caused by scattered documentation pages, lack of “getting started” guides and tutorials. We’ve remedied this oversight! All related SQL knowledge has been curated in a single documentation domain.

Are you curious about the SQL scope? Go to the new SQL Reference Overview section!

Cannot wait to learn how the Ignite SQL engine runs internally? We’ve prepared an Architectural Overview section for you.

Simply need to know how to connect to an Ignite cluster from an SQL tool? Here is a tooling section for you.

Let’s take a look at some specific SQL features released in Ignite 2.3.

First, we’re proud to deliver support of ALTER TABLE command. Presently, the command allows adding new columns to an SQL schema in runtime -- avoiding any cluster restarts. Once a new column is added, it can be turned into an index. Again, in runtime. No restarts!

Another significant addition seen in Ignite 2.3 is the integration with SQLLine tool that is bundled with every Apache Ignite release and can be used as a default command line tool for SQL based interactions.

To prove that it's fairly simple to work with Ignite as with an SQL database using the tool, we recorded a short screencast for you:


Ignite Persistence

Ignite native persistence keeps getting more attention and installs -- which is why the community released a feature requested by at least a dozen users. The feature allows enabling the persistence for specific data sets. Before Ignite version 2.3, the persistence could be enabled globally only.

Now, it's up to you to decide which data to persist and which to store in RAM only. The persistence can be configured via data regions as shown below:


This data region will consume up to 500 MB of RAM and will store a superset of data on disk ensuring that no data loss happens in case of a crash or even if there is no more space left in RAM.

Anything else?

Flip through our release notes to see all the changes and improvements available in Apache Ignite 2.3 -- and, for sure, download and use this version in production.

Questions, comments? Let us know!


Is apache ignite planned to work with NOSQL nodes in the future? I will appreciate your response, Moses.

Posted by Metrics Meaning on November 13, 2017 at 09:56 PM UTC #

Such the great blog i really like to visit here and read this post many many thanks for the share update for solve the code and error process in windows version must be web users have access in commend for repair the all version easily.

Posted by error code 0x80072ee7 on June 08, 2018 at 10:30 AM UTC #

Posted by dich vu seo web on November 04, 2018 at 12:29 PM UTC #

Posted by dao tao seo on December 26, 2018 at 04:09 PM UTC #

Posted by khoa hoc seo on December 26, 2018 at 04:10 PM UTC #

Cho thuê căn hộ Mường Thanh tại Nha Trang

Posted by Nha Trang Apartment on January 14, 2019 at 02:55 AM UTC #

Posted by dịch vụ seo uy tin chuyên nghiệp on January 14, 2019 at 05:29 AM UTC #

Cho thuê căn hộ mường thanh tại Nha Trang

Posted by Cho thuê căn hộ on January 17, 2019 at 09:53 AM UTC #

Great website for Roblox hack tool. I love roblox robux and I need them.There is no doubt everyone need these Roblox hack and Roblox Robux but everyone could not get them. I have few ways by which everyone can Roblox robux and can enjoy the game a lot.

Posted by Roblox Hack on February 02, 2019 at 06:42 AM UTC #

Taking a shot at Apache isn't as simple as individuals think since it required a great deal of training. You did yet you buckle down for it.

Posted by collegemoka on February 06, 2019 at 10:02 AM UTC #

Very helpful advice in this particular post! It’s the little changes that make the largest changes. Thanks for sharing!

Posted by bullet force on June 10, 2019 at 07:14 AM UTC #

http://www.subway-game.blogspot.com http://www.gtagame100.com

Posted by zain on June 21, 2019 at 07:09 PM UTC #

Posted by ảnh chế haivl on July 01, 2019 at 05:46 PM UTC #

This is an informative article on Apache Ignite 2.3. It implements several Java EE specifications including http://www.emeraldcutengagmentrings.com/emerald-cut-engagement-rings/things-to-consider-when-choosing-a-captivating-emerald-diamond-ring/ Java Servlet, JavaServer Pages, Java EL, and WebSocket, and provides a pure Java HTTP web server environment in which Java code can run. Generally, Apache is an HTTP Server, serving HTTP whereas Tomcat is a Servlet and JSP Server serving Java technologies.

Posted by Dona on July 06, 2019 at 10:46 AM UTC #

Post a Comment:
  • HTML Syntax: NOT allowed



Hot Blogs (today's hits)

Tag Cloud