Is it possible to update rows in Azure Data Explorer?
Is it a good choice for storing large inventory (100M items) that are updated frequently or it is mostly optimized to append-only data scenarios? My repository is updated around the clock and I need the changes visible immediately (near-real-time).
Assuming I need full-text search, faceting, and basic items queries/lookups and near real-time updates (which flows in around the clock). how does it compare to ElasticSearch? Assuming I consume both as managed service. I'm mostly concerned about the updates part.
The .update command is now GA and allows update of arbitrary number of records.