Getting Data In

How to prevent large lookups from being replicated to Yarn / Hadoop from Hunk?

Path Finder

We have a user who has created a large csv lookup file (600 Mb). It seems that this file is being replicated to every Yarn server to it's /tmp directory (/tmp/splunk/nodename/splunk/var/run/searchpeers) apparently as every search is executed. There are multiple copies of this bundle. This is filling the /tmp directory and causing a major problem, it also slows every search as this file has to be copied before the search begins to execute.

We have specified the following in the hunk servers distsearch.conf to no effect:
Everything = Servers.csv

How do we block this file being copied with every search?
Can the file be moved into an HDFS directory instead?
Can it be cached so that it doesn't need to be replicated with every search?

Tags (2)
0 Karma

Esteemed Legend

Assuming that this is being used as a lookup file, you can specify that the lookup happens only on the Search Head by adding the local=t parameter as in ... | lookup local=t myLookup .... This will prevent it from being included in the bundle (replication). The downside is that if the output fields of the lookup are used to qualify the search at any point, you will lose the benefits of having this work being map-reduced and happening on the Indexers; instead it will all happen on the Search Head.

0 Karma

Splunk Employee
Splunk Employee

To make sure the Table is not being copied every time:
vix.splunk.setup.onsearch = 0 (default is 1)
** However, that means nothing will be copied to the data nodes. So you may want to turn it off only after the first run.

To make sure you have lots of copies of the table so that bundle replication happens fast:
vix.splunk.setup.bundle.replication = 20 (default 3)

0 Karma
Get Updates on the Splunk Community!

Tips & Tricks When Using Ingest Actions

Tune in to learn about:Large scale architecture when using Ingest ActionsRegEx performance considerations ...

Announcing Our Splunk MVPs

We are excited to announce the first cohort of the Splunk MVP program. Splunk MVPs are passionate members of ...

Dashboard Studio Challenge - Learn New Tricks, Showcase Your Skills, and Win Prizes!

Reimagine what you can do with your dashboards. Dashboard Studio is Splunk’s newest dashboard builder to ...