Splunk Search

What are the differences between join and lookup?

changwoo
Communicator

What are the big differences?

Labels (1)
Tags (2)
1 Solution

MuS
SplunkTrust
SplunkTrust

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
SplunkTrust
SplunkTrust

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!

Observe and Secure All Apps with Splunk

  Join Us for Our Next Tech Talk: Observe and Secure All Apps with SplunkAs organizations continue to innovate ...

Splunk Decoded: Business Transactions vs Business IQ

It’s the morning of Black Friday, and your e-commerce site is handling 10x normal traffic. Orders are flowing, ...

Fastest way to demo Observability

I’ve been having a lot of fun learning about Kubernetes and Observability. I set myself an interesting ...