metatron-discovery
metatron-discovery copied to clipboard
Support multi-value filtering for group-by dimensions
@Test
public void test3993() throws Exception
{
walker.getQueryConfig().getGroupBy().setGroupedUnfoldDimensions(true);
walker.getQueryConfig().getGroupBy().setMultiValueDimensionFiltering(true);
testQuery(
"SELECT age_group, bks_event_d0, bks_event_d1, bks_event_d2, count(*) as cnt FROM cdis "
+ "WHERE svc_mgmt_num = '10000497' AND bks_event_d0 = 'APP' GROUP BY age_group, bks_event_d0, bks_event_d1, bks_event_d2",
new Object[]{"10", "APP", "IT", "티월드다이렉트(tworlddirect.com)", 1L},
new Object[]{"10", "APP", "생활", "도미노피자(Dominopizza)", 1L}
);
walker.getQueryConfig().getGroupBy().setMultiValueDimensionFiltering(false);
testQuery(
"SELECT age_group, bks_event_d0, bks_event_d1, bks_event_d2, count(*) as cnt FROM cdis "
+ "WHERE svc_mgmt_num = '10000497' AND bks_event_d0 = 'APP' GROUP BY age_group, bks_event_d0, bks_event_d1, bks_event_d2",
new Object[]{"10", "APP", "IT", "티월드다이렉트(tworlddirect.com)", 1L},
new Object[]{"10", "APP", "생활", "도미노피자(Dominopizza)", 1L},
new Object[]{"10", "T114", "금융", "신용카드사", 1L},
new Object[]{"10", "T114", "음식", "치킨", 1L}
);
}
Only supported by IN and SELECTOR filter, currently