SQL Querying

Pricing
Chat
Contact
Overview

Use an Industry Standard for Querying Data

Hazelcast supports SQL querying to allow anyone familiar with the industry-standard language to interact with in-memory data. Leveraging the sophisticated query engine built into Hazelcast, the SQL support adds a well-known interface to run queries and offers:

  • The ability to query large amounts of data in an industry-standard way, with the same query specificity of the existing Hazelcast Predicate-based design
  • The option to make use of a new, high-performance concurrent off-heap B+ tree indexes
  • More advanced query optimization

Additional capabilities such as joins, sorting, and aggregations are on the roadmap for delivery in near-future releases. An upcoming release of Hazelcast Jet will take advantage of this SQL support to allow you to run SQL queries on streaming data.

Advantages

Advantages

Fast Fast

Take advantage of in-memory speeds, and also gain further performance via indexes and advanced query optimization.

Standards-Based Standards-Based

Initial support entails “select” queries; the roadmap includes the goal of extensive, standard SQL support for create/read/update/delete (CRUD) operations.

 

Fine-Grained Fine-Grained

Query fields (“attributes”) for more granular results, instead of only querying on the primary key.

Enterprise-Ready Enterprise-Ready

Leverage Hazelcast advantages around business continuity, scale, and security that have been a core part of Hazelcast IMDG.