A hands-on guide to using UUID as a document ID in Manticore Search 28.5.0. Covers table creation with `id uuid`, all CRUD operations via SQL and the JSON API, batch loading via `/bulk`, UUID validation rules and common errors, columnar RT table support, and replication. Key points include: UUIDs must be strings in single quotes for SQL, Manticore normalizes UUIDs to lowercase, automatic UUID generation is available by omitting the `id` field, and range comparisons on UUID IDs are not supported. Limitations such as no ALTER TABLE migration from numeric to UUID IDs and no range filtering on UUID are also documented.
Table of contents
Table for all examplesWorking with UUID through SQLThe same operations through the JSON APIWhere to generate UUIDBatch loading through /bulkValidation and common errorsColumnar RT and replicationWhat to consider before rollout868 Impressions