[Visualize] Offering terms-agg on timestamp fields is a footgun? OOM potential.

[markharwood]

We currently let users configure visualizations with a terms aggregation on a millisecond-resolution date field. This can cause memory problems given the number of unique values.

Is this analysis ever useful? I suspect the cluster-killing costs outweigh the number of edge cases where it is useful (it would need a very selective query to reduce the number of matches). Most of the time I imagine users actually want a date histogram rather than a terms agg.

Would it make sense to remove this sort of selection in the visualization config UI?

[elasticmachine]

Pinging @elastic/kibana-app (Team:KibanaApp)

[mbondyra]

Setting terms aggregation on a date field is not possible in Lens, so the problem can only happen for Visualize editors. Removing Lens label.

[stratoula]

We don't plan to male this change for the legacy visualizations so I am closing this