metatron-app/metatron-discovery

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
    );
  }