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.

SQL

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:

screencast.png

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:

persistence_cfg.png

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!

Comments:

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 #

真的很厉害,关注 oh wow! what a colours! so beautiful!

Posted by teurawitchten1989 on July 20, 2019 at 05:32 PM UTC #

Nice vector! Love your choise color! amazing job where did you take these pictures?

Posted by lalilehos1986 on July 20, 2019 at 05:58 PM UTC #

Really very cool looking, I like it. Sexy colors!

Posted by tifatihe1983 on July 20, 2019 at 07:58 PM UTC #

Great work. Love the concept and beautifully executed!

Posted by erseimascons1971 on July 20, 2019 at 11:37 PM UTC #

Great skills, congrats Great presentation. This feels clean and well balanced. nice!

Posted by paytomtiotrav1970 on July 21, 2019 at 12:28 AM UTC #

Yang Yang Shu is so funny Such a nice and refreshing presentation.

Posted by piemaperto1983 on July 21, 2019 at 01:34 AM UTC #

This is inspiring :) Wow! It’s very exquisite! I’m very love it ! You are very talanted!

Posted by liofirtito1983 on July 21, 2019 at 03:14 AM UTC #

Eso es fuego amigos! So nice! I really like colors!

Posted by speedmesirleng1979 on July 21, 2019 at 04:54 AM UTC #

Oh WOW! I love these abstract shapes. Do have an online shop where to buy the patch and the pin? excellent work

Posted by ceaulaliso1980 on July 21, 2019 at 05:27 AM UTC #

I love the idea Hermoso hermoso hermosooo!

Posted by treasweimime1976 on July 21, 2019 at 06:40 AM UTC #

amazingly impressive немножко часть души там осталась

Posted by wogibunnay1989 on July 21, 2019 at 07:13 AM UTC #

Good style !!--!!

Posted by nireedolink1987 on July 21, 2019 at 07:45 AM UTC #

Original! I LOVE IT. I'm impressed !

Posted by keitwinarat1975 on July 21, 2019 at 08:17 AM UTC #

IMPRESSIVE Looking at your work brings me to idea's. Thanks man!

Posted by apdaneli1989 on July 21, 2019 at 08:49 AM UTC #

WOW! No words Fun!!

Posted by amfatmahyd1970 on July 21, 2019 at 09:22 AM UTC #

Stunning photos of children, our future generations :) Oh my God!

Posted by healthscumnonme1989 on July 21, 2019 at 09:55 AM UTC #

Lovely paintings! Congrats. Stunning work! Keep it up : )

Posted by tiatiadeedsynch1981 on July 21, 2019 at 10:27 AM UTC #

This is completely cool!!!⚡️⚡️⚡️ 你們的作品氣質 喜歡~

Posted by johnfroneasze1986 on July 21, 2019 at 11:00 AM UTC #

Thank you for sharing. hey check this out <a href="http://www.luckypatcher.club">www.luckypatcher.club</a>

Posted by Lucky patcher apk on July 22, 2019 at 06:14 PM UTC #

Thank you for sharing. hey check this out, Download lucky patcher at www.luckypatcher.club

Posted by Lucky patcher apk on July 22, 2019 at 06:15 PM UTC #

Cyberflix is one of the best app you get from https://cyberflix.info/ and enjoy lots of movies and TV series

Posted by Cyberflix on August 05, 2019 at 02:17 PM UTC #

I just joined the forum so there are so many things I don't know yet, I hope to have the help of the boards, and I really want to get to know you all on the forum.

Posted by run 3 on August 06, 2019 at 08:53 AM UTC #

Android launchersDownload

Posted by bestlaunchers.com on September 08, 2019 at 05:28 PM UTC #

Thank you for sharing

Posted by nha trang today on September 19, 2019 at 02:37 AM UTC #

For years Mr. Sayed Jumaa Salam has defrauded the community and violated California Labor and Employment Law. After consulting with California Law Firms, We suggest that he should resign from Islamic Center of Reseda immediately. https://www.icrwatch.com/

Posted by Chen50 on October 05, 2019 at 04:43 PM UTC #

Post a Comment:
Comments are closed for this entry.

Calendar

Search

Hot Blogs (today's hits)

Tag Cloud

Categories

Feeds

Links

Navigation