Support unnesting array of array dimension in group by query
navis opened this issue · 0 comments
navis commented
@Test
public void testGroupByOnArrayOfArray() throws Exception
{
Object[][] expected = {
{"SK텔레콤", 0.7694457769393921D},
{"두산에너빌리티", 0.09346485882997513D},
{"삼성전자", 2.0D},
{"세토피아", 0.08069273829460144D},
{"카카오", 0.2178327590227127D},
{"하이닉스", 0.8178327679634094D}
};
testQuery(
String.format(
"SELECT \"adot_usage.entity.entity_preferences.apollo_samsungstock.preferences.name\", " +
"sum(\"adot_usage.entity.entity_preferences.apollo_samsungstock.preferences.score\") from %s group by 1", params2),
expected
);
}