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!

Index This | Forward, I’m heavy; backward, I’m not. What am I?

April 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

A Guide To Cloud Migration Success

As enterprises’ rapid expansion to the cloud continues, IT leaders are continuously looking for ways to focus ...

Join Us for Splunk University and Get Your Bootcamp Game On!

If you know, you know! Splunk University is the vibe this summer so register today for bootcamps galore ...