LOOKUP - question

Hi,

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.

Regards, Chari.

Hi Chari,

Yes, that’s correct, at this time the lookup system is restricted to string keys and values.

-Surekha