Hi team, I’m using lookup function according to this doc https://docs.pinot.apache.org/users/user-guide-query/lookup-udf-join. But query result shows No Record(s) found. I’ve set isDimTable=true and primaryKeyColumns(error_category) in my offline table config. Here is my query. select error_category ,lookUp(dim_table_name, insight_id, error_category, error_category) insight_id from fact_table_name I think I’m not using lookUp function correctly because query without lookUp function, like select error_category from fact_table_name, could return some records. Could somebody be aware of how to config lookUp?

can you paste the exact query string you used in code format?

@Rong R

select entity_id 
,lookup("entity_id_mapping_prod02", "sub_tenant_id", "entity_id", entity_id) as "subTenentId" 
from table_name where entity_id='1234' limit 1