Raijin has announced the release of version 1.2 of its powerful, schemaless SQL-like database engine. This version introduces significant performance improvements and usability enhancements.
Faster data ingestion and query performance
This release optimizes data ingestion by introducing partial parallelization. Raijin Database now parses and inserts batches of data simultaneously, resulting in up to 15% faster ingestion.
The team also addressed bottlenecks in the SELECT and COPY statements and implemented several optimizations to improve overall query performance.
Support for SQL views
Raijin Database now supports saving SQL queries as views for later use. You can reference a saved view from a SQL query in place of a subquery. Using saved views allows you to reuse recurring queries to reduce complexity and improve manageability.
Enhanced table partitioning
Table partitioning now supports updating the partitioning expression of a table, including tables that were previously not partitioned or tables already manually or dynamically partitioned. Other enhancements include:
-
The partition name and path have been updated to include a user-friendly name and the partitioning expression.
-
The
PARTITION BYclause now supports theINoperator when creating a table. -
The root partition is now the default partition.
-
The default partition will only be created if necessary, i.e., if data is inserted without a partition name and the table does not contain a partitioning expression.
Improved Ingestion API error reporting
The Raijin Ingestion API has been updated to provide a detailed error report when it fails to process ingested records. The Ingestion API response now includes the raw data, the record position in the batch, and the reason for each failure, in addition to the total failed records. This information allows for client-side error handling and reporting to ensure no log records are lost.
Collect logs with NXLog
As a database engine, Raijin is geared towards semi-structured data, making it a perfect solution for log storage. Log data is notoriously unstructured, making it hard to store in rigid table structures like traditional SQL systems.
Raijin complements NXLog’s powerful log collection and centralization solutions. With NXLog Enterprise Edition’s Raijin integration, you can seamlessly and easily send logs from NXLog Enterprise Edition to a Raijin database instance. The two fit hand in glove, providing the methods of capturing, processing, and storing log data for a complete log management solution.
Check out the Raijin release notes for a full breakdown of the features and improvements.
