Hello,
I am currently have 2 tables:
Table-1
date, common-granularity, groupId-1, value-1
Table-2:
date, common-granularity, groupId-2 ,value-2
I want to do some intermediate stats_operations such as:
Table-1
|stats latest(value-1) as latest_value1 by date, common-granularity, groupId-1
|stats count(latest_value1) as count_value1, sum(inter_value1) as sum_value1 by date, common-granularity
Table-2:
|stats count(value-2) as count_value2 by date, common-granularity
Ideally, I want to do stats operation on Table-1 and Table-2 separately, and then combine the operation results based on date, common-granularity.
For example, the expected final result is like:
date, common-granularity, intermediate_result_from_table_1(count_value1, sum_value1), intermediate_result_from_table_2(count_value2)
I knew |join with sub-search can achieve this, but I am concern about the |join max-out limitation.
So I am looking for any possible other methodologies.
Thanks
... View more
