com.datastax.driver.core.querybuilder.Select.groupBy()方法的使用及代码示例

x33g5p2x  于2022-01-30 转载在 其他  
字(4.7k)|赞(0)|评价(0)|浏览(249)

本文整理了Java中com.datastax.driver.core.querybuilder.Select.groupBy()方法的一些代码示例,展示了Select.groupBy()的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。Select.groupBy()方法的具体详情如下:
包路径:com.datastax.driver.core.querybuilder.Select
类名称:Select
方法名:groupBy

Select.groupBy介绍

[英]Adds a GROUP BY clause to this statement.

Note: support for GROUP BY clause is only available from Cassandra 3.10 onwards.
[中]将GROUP BY子句添加到此语句中。
注:对GROUP BY子句的支持仅在Cassandra 3.10之后提供。

代码示例

代码示例来源:origin: com.datastax.cassandra/cassandra-driver-core

  1. /**
  2. * Adds a {@code GROUP BY} clause to this statement.
  3. *
  4. * <p>Note: support for {@code GROUP BY} clause is only available from Cassandra 3.10 onwards.
  5. *
  6. * @param columns the columns to group by.
  7. * @return the {@code SELECT} statement this {@code WHERE} clause is part of.
  8. * @throws IllegalStateException if a {@code GROUP BY} clause has already been provided.
  9. */
  10. public Select groupBy(Object... columns) {
  11. return statement.groupBy(columns);
  12. }

代码示例来源:origin: com.datastax.cassandra/cassandra-driver-core

  1. assertThat(select().all().from("foo").groupBy("c1", column("c2"), raw("c3")).toString())
  2. .isEqualTo("SELECT * FROM foo GROUP BY c1,c2,c3;");
  3. assertThat(
  4. .all()
  5. .from("foo")
  6. .groupBy("c1", column("c2"), raw("c3"))
  7. .orderBy(asc("c1"))
  8. .toString())
  9. .isEqualTo("SELECT * FROM foo WHERE x=42 GROUP BY c1,c2,c3 ORDER BY c1 ASC;");
  10. try {
  11. select().all().from("foo").groupBy("foo").groupBy("bar");
  12. fail("Should not allow GROUP BY twice");
  13. } catch (IllegalStateException e) {

代码示例来源:origin: com.datastax.cassandra/cassandra-driver-core

  1. select("a", "b", "e", count("b"), max("e"))
  2. .from(table)
  3. .groupBy("a", "b")
  4. .limit(2)))
  5. .containsExactly(row(1, 2, 6, 2L, 12), row(1, 4, 12, 2L, 24));
  6. select("a", "b", "e", count("b"), max("e"))
  7. .from(table)
  8. .groupBy("a", "b")
  9. .perPartitionLimit(1)))
  10. .containsExactly(row(1, 2, 6, 2L, 12), row(2, 2, 6, 1L, 6), row(4, 8, 24, 1L, 24));
  11. select("a", "b", "e", count("b"), max("e"))
  12. .from(table)
  13. .groupBy("a", "b")
  14. .perPartitionLimit(1)
  15. .limit(2)))
  16. assertThat(session().execute(select("a", count("a")).distinct().from(table).groupBy("a")))
  17. .containsExactly(row(1, 1L), row(2, 1L), row(4, 1L));
  18. session().execute(select("a", count("a")).distinct().from(table).groupBy("a").limit(2)))
  19. .containsExactly(row(1, 1L), row(2, 1L));
  20. session().execute(select().column("a").column("b").max("d").from(table).groupBy("a"));
  21. fail("Expecting IQE");
  22. } catch (InvalidQueryException e) {
  23. assertThat(session().execute(select("a", "b", max("d")).from(table).groupBy("a", "b")))

代码示例来源:origin: com.datastax.dse/dse-java-driver-core

  1. assertThat(select().all().from("foo").groupBy("c1", column("c2"), raw("c3")).toString())
  2. .isEqualTo("SELECT * FROM foo GROUP BY c1,c2,c3;");
  3. assertThat(
  4. .all()
  5. .from("foo")
  6. .groupBy("c1", column("c2"), raw("c3"))
  7. .orderBy(asc("c1"))
  8. .toString())
  9. .isEqualTo("SELECT * FROM foo WHERE x=42 GROUP BY c1,c2,c3 ORDER BY c1 ASC;");
  10. try {
  11. select().all().from("foo").groupBy("foo").groupBy("bar");
  12. fail("Should not allow GROUP BY twice");
  13. } catch (IllegalStateException e) {

代码示例来源:origin: com.datastax.dse/dse-java-driver-core

  1. select("a", "b", "e", count("b"), max("e"))
  2. .from(table)
  3. .groupBy("a", "b")
  4. .limit(2)))
  5. .containsExactly(row(1, 2, 6, 2L, 12), row(1, 4, 12, 2L, 24));
  6. select("a", "b", "e", count("b"), max("e"))
  7. .from(table)
  8. .groupBy("a", "b")
  9. .perPartitionLimit(1)))
  10. .containsExactly(row(1, 2, 6, 2L, 12), row(2, 2, 6, 1L, 6), row(4, 8, 24, 1L, 24));
  11. select("a", "b", "e", count("b"), max("e"))
  12. .from(table)
  13. .groupBy("a", "b")
  14. .perPartitionLimit(1)
  15. .limit(2)))
  16. assertThat(session().execute(select("a", count("a")).distinct().from(table).groupBy("a")))
  17. .containsExactly(row(1, 1L), row(2, 1L), row(4, 1L));
  18. session().execute(select("a", count("a")).distinct().from(table).groupBy("a").limit(2)))
  19. .containsExactly(row(1, 1L), row(2, 1L));
  20. session().execute(select().column("a").column("b").max("d").from(table).groupBy("a"));
  21. fail("Expecting IQE");
  22. } catch (InvalidQueryException e) {
  23. assertThat(session().execute(select("a", "b", max("d")).from(table).groupBy("a", "b")))

相关文章