Splunk Search

What are the differences between join and lookup?

changwoo
Communicator

What are the big differences?

Labels (1)
Tags (2)
1 Solution

MuS
Legend

Hi changwoo,

A join is used to combine the results of a search and subsearch if specified fields are common to each. You can also join a table to itself using the selfjoin command.

Use the lookup command to manually invoke field lookups from a lookup table that you've defined in transforms.conf. For more information, see "Lookup fields from external data sources," in the Knowledge Manager manual.

hope this helps ...

cheers, MuS

View solution in original post

bing_wu_mash
Explorer

Also - if you are from DB/SQL background, keep in mind LOOKUP is like LEFT OUTER JOIN whereas JOIN is like INNER JOIN. The results are quite different

highsplunker
Contributor

excellent. this is exactly what's important.

i'd also add this: there's No difference between "left join" and "left OUTER join".

ref. https://stackoverflow.com/questions/406294/left-join-vs-left-outer-join-in-sql-server

0 Karma

bing_wu_mash
Explorer

Also - if you are from DB/SQL background, keep in mind LOOKUP is like LEFT OUTER JOIN whereas JOIN is like INNER JOIN

MuS
Legend

Hi changwoo,

A join is used to combine the results of a search and subsearch if specified fields are common to each. You can also join a table to itself using the selfjoin command.

Use the lookup command to manually invoke field lookups from a lookup table that you've defined in transforms.conf. For more information, see "Lookup fields from external data sources," in the Knowledge Manager manual.

hope this helps ...

cheers, MuS

changwoo
Communicator

thanks for your help

0 Karma
Get Updates on the Splunk Community!

.conf25 Community Recap

Hello Splunkers, And just like that, .conf25 is in the books! What an incredible few days — full of learning, ...

Splunk App Developers | .conf25 Recap & What’s Next

If you stopped by the Builder Bar at .conf25 this year, thank you! The retro tech beer garden vibes were ...

Congratulations to the 2025-2026 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...