I am using a join search command. What I noticed is that join only takes one row from the sub search result for the joining field though my subsearch has more than one row on the joining field.
In short it's not doing the Cartesian product as done by joins in SQL.
e.g. search result for the outer search is
host
host1
host2
and subsearch return the following
host instance status
host1, 1, ON
host1, 2, OFF
host2, 1, OFF
the join on host returns
host1,1,ON (or host1,2,OFF)
host2,1,OFF
Is there anyway to get the Cartesian product in splunk?
... View more