Getting Data In

join is skipping rows

jiaqya
Builder

csv files has 70k entries and when i join it with index which has 30k rows, it fails to join random records even when data is available.

when i specify the record before and after join it picks up the value.

any idea if this is due to any kind of limitation.

0 Karma

woodcock
Esteemed Legend

Join is subject to subsearch and RAM limits. Do not use it. Use ... | stats values(*) AS * BY <joinerfield here> instead.

0 Karma

Vijeta
Influencer

@jiaqya It may be due to subsearch limitation of 10K records, hence your join subsearch is not returning all records. You should try avoiding the join and use lookup command instead.

0 Karma

richgalloway
SplunkTrust
SplunkTrust

Which form of join are you using? Please share your query.

---
If this reply helps you, Karma would be appreciated.
0 Karma

jiaqya
Builder

join type=left [|inputlookup

0 Karma

koshyk
Super Champion

You need to put the "KEY" which are you joining upon

so
| join type=left COMMONKEY [|inputlookup ..

0 Karma

jiaqya
Builder

yes correct, i have used it the same same.
i get results for some records from the file and some i do not..

0 Karma
Get Updates on the Splunk Community!

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...

Let’s Get You Certified – Vegas-Style at .conf24

Are you ready to level up your Splunk game? Then, let’s get you certified live at .conf24 – our annual user ...