I’m wondering if there is a SQL function that will perform the consistent hashing to determine the
partition_ident that’s used for table partitioning (or the reverse).
Example: I have partitioned my table using the
day column I’d like to somehow be able to translate
2023-03-03' to 04732dhn6ss30c9m60o30c1g
to avoid having to look this up on the CrateDB Admin UI for a script that works off thepartition_ident`.