I have a query regarding LOOKUP.
Is it mandatory to have both keyColumn and valueColumn to be of type string?
I have a usecase where keyColumn and valueColumn both are of type long. Unfortunately, iam getting error.
I managed to get it work by casting the druid dimension column from long to string and lookup data(key and value) to be string.
Can somebody please confirm. Thanks in advance.