Documentation
Analysts
Gain new insights to your data with fast, responsive graphics and SQL queries.
Administrators
Install and configure your OmniSci instance, then load data for analysis.
Developers
Extend OmniSci with custom charts and interfaces. Contribute
to the OmniSci Core Open Source project.
What's New?
Version 5.0
- The new filter panel in Immerse enables the ability to toggle
filters on and off, and introduces Filter Sets to provide quick
access to different sets of filters in one dashboard.
- Immerse now supports using global and cross-filters to
interactively build cohorts of interest, and the ability to apply
a cohort as a dashboard filter, either within the existing filter
set or in a new filter set.
- Data Catalog, located within Data Import, is a repository of
datasets that users can use to enhance existing analyses.
- To see these new features in action, please watch this
video from Converge 2019, where Rachel Wang demonstrates how
you can use them.
- Added support for binary dump and restore of database tables.
- Added support for compile-time registered user-defined functions
in C++, and experimental support for runtime user-defined SQL
functions and table functions in Python via the Remote Backend Compiler.
- Support for some forms of correlated subqueries.
- Support for update via subquery, to allow for updating a
table based on calculations performed on another table.
- Multistep queries that generate large, intermediate result
sets now execute up to 2.5x faster by leveraging new JIT code
generator for reductions and optimized columnarization of
intermediate query results.
- Frontend-rendered choropleths now support the selection of
base map layers.
Version 4.8
- Added support to log the user roles during login, and the
ability to use encrypted communication among distributed system
components.
- SpatioTemporal enhancements, including support for the ST_POINT
geo constructor and performance improvements for ST_CONTAINS.
- Performance and memory management improvements including
certain high-cardinality GROUP-BY queries, and
support for the OPTIMIZE command for sharded tables.
- Immerse now integrates with JupyterLab. You can
send SQL queries to Jupyter from SQL Editor, or access it
directly from top level navigation. See
Jupyter Integration for setup instructions.
- Combo chart now supports zooming and panning on large time
series measures down to millisecond-level granularity.
- New Immerse features include the new Dark Mode theme, the
ability to duplicate charts within dashboards, and export and
import of dashboard metadata.
Version 4.7
- Added support for Window functions in OmniSciDB. This is an
early iteration of an often-requested SQL feature allowing for
analytic computations over rolling windows. See the release notes
and documentation for details and known limitations.
- Added support for Visual Data Fusion, the ability to add
measures on a combo chart from more than one source table,
and also crossfilter across these sources. This is a natural
complement to multi-layer geospatial chart.
- Distributed Rendering support for polygons supporting much
larger shape datasets within analytical workflows.
- Filters on aggregates in Pointmap and Scatter Plot, equivalent
to applying a HAVING filter on SQL aggregate queries.
- INSERT TABLE AS SELECT (ITAS) support in both single-node and
Distributed modes, allowing for easier ELT (Extract/Load/Transform)
type workflows in OmniSciDB, typically combined with CTAS
(CREATE TABLE AS SELECT).
- Data import status within Immerse for time estimation and import
success information.
Read more at the OmniSci Blog
Version 4.6
- CTAS (CREATE TABLE AS SELECT) on distributed installations.
- Import Parquet format data files.
- Updates on variable length columns.
- Single Sign-on with SAML for compatibility with Okta and
other providers.
- Extended NULL support for variable length arrays. The full
array can now be null, in addition to individual elements.
- Support for high-precision timestamps, up to nanosecond precision.
- Improved performance loading String Dictionary from storage.
- Significantly more scalable rendering from projection (non-aggregate) queries.
- Immerse Data Manager:
- Delete, Append, and Truncate
(delete all rows from) tables.
- Auto-detect header rows on import, manually
indicate whether the first row is a header row.
- Immerse:
- Improved performance for non-aggregated Choropleth/Pointmap/Scatterplot charts.
- Non-aggregated Choropleth now cross-filters on zoom.
Read more at the OmniSci Blog
Version 4.5
- Enterprise trial version is now available.
- Better memory handling through improved estimation of GPU
memory requirements. Automatically run query on CPU if not enough
GPU memory is estimated to be available.
- Better handling of NULL values.
- DECIMAL/NUMERIC fields can be downcast to different scales and precisions.
- Dictionary size increased to 2.15 billion entries.
- Add support for the lasso filter on Linemap chart.
- Added clarity to formatting options and created a new option
to represent billions as B.
- Default ports changed from 9090-9094 to 6273-6280 to avoid collisions.
- Renamed key components from MapD to OmniSci. See the Release Notes.
Version 4.4
- Improved geospatial function support.
- Support for pct/blend accumulation rendering modes in distributed configurations.
- Improved error tracking.
- Support for SAML authentication with Okta.
- Improved performance on String Dictionary import for multiple
String Dictionary-encoded columns.
Version 4.3
- More robust joins between different types.
- Better compression on DECIMAL/NUMERIC types.
- More efficient rendering of lines using the GPU rather than
first copying results to the CPU.
Version 4.2
Version 4.1
Version 4.0
Read more at the OmniSci Blog.
This sitemap link is for the benefit of the search crawler.