Known Limitations

This document applies to Materialize v0.5.2.

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)

Syntax & Semantics

• Column names generated in returned column set are not available to GROUP BY (#1673)

Performance

• ANY and ALL queries generate suboptimal plans (#744)

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.