I have a field in my events that is a string (but does not translate to a number directly)
Is there a way to convert this string to an integer consistently (value does not matter), such as using a hash function? The functions available, such as md5 convert strings to strings, but is there a way to convert this back to an integer? An example is as follows:
user favorite_fruit fruit_number
bob Apple 1
jane Pear 2
pete Apple 1
Where user and favorite_fruit are known at index-time, and fruit_number is calculated at search-time. The actual value of fruit_number is arbitrary and doesn't need to be sequential.
I can't use a lookup, as the list of favorite_fruit 's is arbitrary.
... View more