Yep, CrateDB is not ACID but has eventual consistency at the row level.
I think for some use cases it's fine that some inserts are not visible in search results immediately. Also, once could tweak refresh_interval or use explicit refresh for "must be visible" inserts.
Another potential of to use zombodb (haven't tried it myself).