Legacy Worker Capabilities

Warning

Legacy documentation: This documentation applies to Legacy Deephaven Enterprise only and does not apply to Core+.

Theme	Capability	Legacy	Notes
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.