Legacy Worker Capabilities

ThemeCapabilityLegacyNotes
Open or closed?Closed, commercial software
Data in / data outRead Live Deephaven Format Tables from Data Import Server
Read Parquet or Deephaven Format Historical Tables
Partitions & hierarchical groups, reading & writing
Non-clustered single column indexesSingle-column indices on static tables.
Clustered-indexes (groups)Single-column clustered indices on static tables.
Live data indexesLive data indexes that can be added to any table at runtime.
Multi-column indexesSome 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 producerA custom protocol built on top of Simple Binary Encoding. No authentication is provided.
SBE consumerA custom protocol built on top of Simple Binary Encoding. No authentication is provided.
Data mesh (connecting workers to workers)Barrage consumer
Preemptive TablesPreemptive 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 & approachGroovy / 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
ClientsJupyter kernelThe 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 ClientThe Legacy client relies on jpy.
UI/UX and workflowWebUI / 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 PQsGrizzly. A PQ type that can have N identical workers + M hot backups, with support for consumers' round-robin.