Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support unnesting array of array dimension in group by query #4361

Open
navis opened this issue Jan 5, 2024 · 0 comments
Open

Support unnesting array of array dimension in group by query #4361

navis opened this issue Jan 5, 2024 · 0 comments
Assignees
Labels
@engine Issues related to engine

Comments

@navis
Copy link

navis commented Jan 5, 2024

  @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
    );
  }
@navis navis added the @engine Issues related to engine label Jan 5, 2024
@navis navis self-assigned this Jan 5, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
@engine Issues related to engine
Projects
None yet
Development

No branches or pull requests

1 participant