Apache Pinot Docs
Search…
release-0.10.0
Introduction
Basics
Concepts
Architecture
Components
Getting Started
Import Data
Indexing
Releases
Recipes
For Users
Query
Querying Pinot
Filtering with IdSet
Transformation Functions
Aggregation Functions
User-Defined Functions (UDFs)
Cardinality Estimation
Lookup UDF Join
Querying JSON data
Explain Plan
Grouping Algorithm
APIs
External Clients
Tutorials
For Developers
Basics
Advanced
Plugins
Design Documents
For Operators
Deployment and Monitoring
Command-Line Interface (CLI)
Configuration Recommendation Engine
Tutorials
Configuration Reference
Cluster
Controller
Broker
Server
Table
Schema
Ingestion Job Spec
Functions
RESOURCES
Community
Team
Blogs
Presentations
Videos
Integrations
Tableau
Trino
ThirdEye
Superset
Presto
Powered By GitBook
Lookup UDF Join
Lookup UDF is used to get dimension data via primary key from a dimension table allowing a decoration join functionality. Lookup UDF can only be used with a dimension table in Pinot. The UDF signature is as below:
1
lookUp('dimTableName', 'dimColToLookUp', 'dimJoinKey1', factJoinKeyVal1, 'dimJoinKey2', factJoinKeyVal2 ... )
Copied!
  • dimTableName Name of the dim table to perform the lookup on.
  • dimColToLookUp The column name of the dim table to be retrieved to decorate our result.
  • dimJoinKey The column name on which we want to perform the lookup i.e. the join column name for dim table.
  • factJoinKeyVal The value of the dim table join column for which we will retrieve the dimColToLookUp for the scope and invocation.
Return type of the UDF will be that of the dimColToLookUp column type. There can also be multiple primary keys and corresponding values.
Note: If the dimension table uses a composite primary key i.e multiple primary keys, then ensure that the order of keys appearing in the lookup() UDF is same as the order defined for "primaryKeyColumns" in the dimension table schema.
Previous
Cardinality Estimation
Next
Querying JSON data
Last modified 1mo ago
Copy link