Known Limitations
This document applies to Materialize v0.7.0.
The following links describe features that Materialize does not yet support, but plans to in future releases. If any of these issues impact you, feel free to let us know on the linked-to GitHub issue.
For a complete and current overview, check out our known-limitations
tag.
SQL
Types
- Numeric precision is not always equivalent to PostgreSQL (#1824)
- Numeric to float conversions are susceptible to floating point errors (#1102)
Performance
ANYandALLqueries generate suboptimal plans (#744)
Common table expressions (CTEs)
- CTEs only support
SELECTqueries. (#4867) - Materialize inlines the CTE where it’s referenced, which could cause unexpected performance characteristics for especially complex expressions. (#4867)
WITH RECURSIVECTEs are not available yet. (#2516)
Sources & Sinks
Kafka
- Protobuf data for Kafka sinks is not supported (#1541)
- JSON-encoded data for Kafka sinks is not supported (#1540)
Kinesis
- Consistent Kinesis sources are not supported (#2191)
- Enhanced fan-out Kinesis consumers are not supported (#2192)
- Reading from a Kinesis stream as of a sequence number or timestamp is not supported (#2294)
- Kinesis sinks are not supported (#2372)
File sources
None right now!
Regex formatting
- Regex columns cannot be set as nullable (#1685)
Deployment
Performance
- Slow queries can impact other, unrelated queries (#1956)
Networking
- Hostnames that resolve to multiple addresses are not supported (#502)
Monitoring & Debugging
- No report exists to show memory usage for indexes (#1532)
Closed known limitations
The following issued used to be known limitations, but we’ve fixed them in the specified version.
| Fixed in | Known limitation |
|---|---|
| v0.4.0 | Column names generated in returned column set are not available to GROUP BY (#1673) |
| v0.3.0 | JSON-encoded streams are not supported (#207) |
| v0.3.0 | Connecting Kafka sinks back in as sources is not supported (#1665) |
| v0.3.0 | Progress tracking for Kafka sinks is not supported (#1442) |
| v0.3.0 | date_trunc for timestamp with time zone data (#1814) |
| v0.3.0 | Special date, time, and timestamp values from PostgreSQL are not supported (#1805) |
| v0.3.0 | Cannot cast from string to time-like types (#1378) |
| v0.3.0 | Using a non-existent namespace does not result in an error (#1684) |
| v0.3.0 | Connecting to Kafka brokers with SSL (client) authentication is not supported (#1785) |
| v0.3.0 | Kafka sources with more than one partition are not supported (#2169) |
| v0.3.0 | Formatting regular expression is not resurface-able through SHOW CREATE SOURCE (#1762) |
| v0.3.0 | EXPLAIN DATAFLOW does not include details about ORDER BY and LIMIT (#477) |
| v0.2.1 | Kinesis sources with more than one shard are not supported (#2222) |
| v0.2.0 | CSV files with header rows are not supported (#1982) |
| v0.1.3 | Intervals do not support addition or subtraction with other intervals (#1682) |