https://pinot.apache.org/ logo
#general
Title
# general
t

troywinter

01/18/2021, 6:33 AM
Hi, I’m getting an error when using lookup on a local cluster, does anyone know how to solve it?
Copy code
[
  {
    "errorCode": 200,
    "message": "QueryExecutionError:\norg.apache.pinot.core.query.exception.BadQueryRequestException: Caught exception while initializing transform function: lookup\n\tat org.apache.pinot.core.operator.transform.function.TransformFunctionFactory.get(TransformFunctionFactory.java:207)\n\tat org.apache.pinot.core.operator.transform.TransformOperator.<init>(TransformOperator.java:56)\n\tat org.apache.pinot.core.plan.TransformPlanNode.run(TransformPlanNode.java:52)\n\tat org.apache.pinot.core.plan.SelectionPlanNode.run(SelectionPlanNode.java:83)\n\tat org.apache.pinot.core.plan.CombinePlanNode.run(CombinePlanNode.java:100)\n\tat org.apache.pinot.core.plan.InstanceResponsePlanNode.run(InstanceResponsePlanNode.java:33)\n\tat org.apache.pinot.core.plan.GlobalPlanImplV0.execute(GlobalPlanImplV0.java:45)\n\tat org.apache.pinot.core.query.executor.ServerQueryExecutorV1Impl.processQuery(ServerQueryExecutorV1Impl.java:294)\n\tat org.apache.pinot.core.query.executor.ServerQueryExecutorV1Impl.processQuery(ServerQueryExecutorV1Impl.java:215)\n\tat org.apache.pinot.core.query.executor.QueryExecutor.processQuery(QueryExecutor.java:60)\n\tat org.apache.pinot.core.query.scheduler.QueryScheduler.processQueryAndSerialize(QueryScheduler.java:157)\n\tat org.apache.pinot.core.query.scheduler.QueryScheduler.lambda$createQueryFutureTask$0(QueryScheduler.java:141)\n\tat java.util.concurrent.FutureTask.run(FutureTask.java:266)\n\tat java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)"
  }
]
k

Kishore G

01/18/2021, 6:35 AM
whats the query
t

troywinter

01/18/2021, 6:54 AM
select who, lookup(‘mango_company’, ‘name’, ‘company_id’, company_id) from fetrace_biz limit 10
k

Kishore G

01/18/2021, 7:16 AM
whats the name of the table that contains the company_id column
l

Lvszn Peng

01/18/2021, 7:42 AM
Lookup
function work with dimTable. But we found table could not be created successful with
isDimTable
= true.
The condition of create dim table successful with
idDimTable
is that schema need primary key.
x

Xiang Fu

01/18/2021, 9:25 AM
@balci can you help here 🙂
t

troywinter

01/18/2021, 3:01 PM
got it, the DimTable need to have a primary key as @Lvszn Peng said, thanks everyone