Description
Is your feature request related to a problem?
We are doing the Elasticsearch migration to Opensearch, Elasticsearch Transform support cardinality aggregation, but opensearch not.
What solution would you like?
I would like Opensearch's transform feature to support cardinality aggregation. This would allow users to calculate unique counts directly within transforms, streamlining the data processing workflow and reducing the need for external calculations. And our Opensearch migration job could be continued.
What alternatives have you considered?
I've considered using scripts or external tools to perform cardinality aggregation outside of Opensearch transforms. While these methods work, they add complexity to the workflow and can be time-consuming. Additionally, these alternatives require additional infrastructure and maintenance, which is not ideal.
Do you have any additional context?
Incorporating cardinality aggregation into transforms would be highly beneficial for users dealing with large datasets where unique count calculations are essential. It would improve the overall user experience and expand the functionality of Opensearch. If possible, I would appreciate any guidance or timeline on when this feature might be considered for development.