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!

Buttercup Games: Further Dashboarding Techniques (Part 2)

This series of blogs assumes you have already completed the Splunk Enterprise Search Tutorial as it uses the ...

Index This | What is the next number in the series? 7,645 5,764 4,576…

February 2025 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with this ...

Buttercup Games: Further Dashboarding Techniques

Hello! We are excited to kick off a new series of blogs from SplunkTrust member ITWhisperer, who demonstrates ...