Open or closed? | Closed, commercial software | ✅ | |
Data in / data out | Read Live Deephaven Format Tables from Data Import Server | ✅ | |
| Read Parquet or Deephaven Format Historical Tables | ✅ | |
| Partitions & hierarchical groups, reading & writing | ✅ | |
| Non-clustered single column indexes | ✅ | Single-column indices on static tables. |
| Clustered-indexes (groups) | ✅ | Single-column clustered indices on static tables. |
| Live data indexes | ✅ | Live data indexes that can be added to any table at runtime. |
| Multi-column indexes | ✅ | Some operations take advantage of multi-column indexes. |
| Merge System Tables | ✅ | |
| Write user tables | ✅ | |
| Read user tables | ✅ | |
| Persistent Input Tables | ✅ | |
| Import-driven lastBy | ✅ | |
| Table loggers | ✅ | |
| Generated Row-by-Row Loggers | ✅ | |
| JDBC (in Java) | ✅ | |
| Kafka ingester | ✅ | |
| JSON Kafka Payloads | ✅ | |
| Avro Kafka Payloads | ✅ | |
| POJO Kafka Payloads | ✅ | |
| Solace Ingester | ✅ | |
| SBE producer | ✅ | A custom protocol built on top of Simple Binary Encoding. No authentication is provided. |
| SBE consumer | ✅ | A custom protocol built on top of Simple Binary Encoding. No authentication is provided. |
Data mesh (connecting workers to workers) | Barrage consumer | ✅ | |
| Preemptive Tables | ✅ | Preemptive Tables are a Java-serialization based protocol, which does not support clients in other languages. Barrage is a gRPC alternative, which is used by Deephaven Core workers. |
Query / Code / engine capabilities & approach | Groovy / Java interface | ✅ | |
| Legacy, Python syntax | ✅ | |
| Deephaven time library for dbDateTime , etc. | ✅ | |
| Calendar, businessTime support, etc. | ✅ | |
| TableMaps | ✅ | |
| Downsampler | ✅ | |
| Replay Query | ✅ | |
| ZipJoin | ✅ | |
| Basic multi-core map-reduce builder | ✅ | |
Clients | Jupyter kernel | ✅ | The Legacy Jupyter integration requires a "bootstrap" kernel, which then connects to a Deephaven worker. All Python evaluations must occur on the server. |
| Java Client | ✅ | |
| R Client | ✅ | The Legacy client relies on jpy. |
UI/UX and workflow | WebUI / Web-IDE / PQ workflow | ✅ | |
| Swing console | ✅ | |
| Plots: Deephaven plotting library supported (Groovy, Java) | ✅ | |
| Builder-driven UI Parameterized PQs | ✅ | |
| Builder-driven Pivot Widget | ✅ | |
| Column grouping | ✅ | |
| Column statistics viewable in WebUI | ✅ | |
| Replica PQs | ✅ | Grizzly. A PQ type that can have N identical workers + M hot backups, with support for consumers' round-robin. |