Hi@sinitcin ,

Thanks for checking out OpenObserve and for your message.

Yes, you can create a stream called "news" and search across titles, topics, authors, regions, and full content just like in Elasticsearch. O2 querying engine allows you to use SQL with full-text support, for example:
SELECT * FROM "news" WHERE match_all('title, content', 'election results') AND author = 'Jane Smith' AND region = 'Asia'.

One of the big advantages over ES is our dynamic schema evolution. When you ingest new documents, OpenObserve automatically detects and indexes new fields without any manual intervention or reindexing required. So if your team starts adding more parameters (like tags or timestamps) down the line, they'll just get picked up seamlessly.

Regarding scale: Handling around 50 million documents shouldn't be an issue, especially with our partitioning and indexing features to keep things performant. To boost it further, you can leverage options like:

Full-text search: For quick content and title searches.
Secondary indexes: To speed up queries on high-cardinality fields like authors or regions.
Key-Value partitions: Great for filtering on categorical data (e.g., topics or authors).
Hash partitions: For even distribution and faster lookups across large datasets.

These can be applied per field to reduce query scan time.

If you run into issues setting these up, feel free to share details in ourcommunity slack