Lookup creation via druid console and lookup query

Good afternoon, I’m somewhat new to druid and have been these past days viewing options on how to replace a dimension value for another one on a lookup table.

I created this lookup via druids console with the following spec:

{

“__default”: {

“action”: {

“type”: “map”,

“map”: {

“1”: “CREATE”,

“2”: “UPDATE”,

“3”: “DELETE”

}

}

}

}

I then tried to issue a query:

SELECT action,

REPLACE(action,action,LOOKUP(action,“action”)) AS action2

FROM test

And got an exception:

Unknown exception / Error while applying rule DruidQueryRule(SELECT_PROJECT), args [rel#3950:LogicalProject.NONE.(input=RelSubset#3949,action=$2,action2=REPLACE($2, $2, LOOKUP($2, $2))), rel#3960:DruidQueryRel.NONE.(query={“queryType”:“scan”,“dataSource”:{“type”:“table”,“name”:“test”},“intervals”:{“type”:“intervals”,“intervals”:["-146136543-09-08T08:23:32.096Z/146140482-04-24T15:36:27.903Z"]},“virtualColumns”:,“resultFormat”:“compactedList”,“batchSize”:20480,“limit”:9223372036854775807,“order”:“none”,“filter”:null,“columns”:[“ID”,"__time",“action”,“entity”,“operationID”,“parentEntity”,“user”],“legacy”:false,“context”:{“sqlOuterLimit”:100,“sqlQueryId”:“acb22cda-641b-42c4-9575-2b2cc85b1c00”},“descending”:false,“granularity”:{“type”:“all”}},signature={ID:LONG, __time:LONG, action:STRING, entity:STRING, operationID:LONG, parentEntity:STRING, user:STRING})] / java.lang.RuntimeException

I went and checked that lookup status was:

{"__default":{"action":{"loaded":false}}}

I repeated the same process and the lookup didnt get loaded again what might be happening?

Seeking some guidance for someone that might have a had similar problem.

Kind regards.