from the docs on limits.conf
[searchresults] * This stanza controls search results for a variety of Splunk search commands. maxresultrows = <integer> * Configures the maximum number of events are generated by search commands which grow the size of your result set (such as multikv) or that create events. Other search commands are explicitly controlled in specific stanzas below. * This limit should not exceed 50000. Setting this limit higher than 50000 causes instability. * Defaults to 50000.
[subsearch] * This stanza controls subsearch results. maxout = <integer> * Maximum number of results to return from a subsearch. * This value cannot be greater than or equal to 10500. * Defaults to 100.
So it looks like you're hitting a limit somewhere. You'd probably get better help if you provided more info on the search you're running.
Thanks for your information, but what will happen if my results are more than 50,000 rows ?
Following query I am running to find the actual results :
|inputlookup "onefile.csv" | append [ |inputlookup "secondfile.csv" ] | append [ |inputlookup "thirdfile.csv" ] | lookup "Masterfile.csv" user_sso
Please let me know how to get rid of the above mentioned "Warning Message"