In my below query, I want to load sourcetypeA for last 13 weeks, however I want to restrict sourcetypeB for last 7 days without using earliest
The below trick now()-_time is not working for me. I'm getting " Comparator '<' has an invalid term on the left hand side. " error
index=my_index (sourcetype=sourcetypeA AND FILE_ID=100002 ) OR (sourcetype=sourcetypeB AND ((now()-_time)<691220) )
I don't want to filter after the base query, as the data in sourcetypeB is very huge and is drastically hindering the performance of the query
Using the second query (sourcetypeB) as sub query or Join is not an option currently for me
Is there a way I can achieve this?
Thanks,
Pradeep
... View more