.from(table) .where(eq("b", 2)) .groupBy("a", "b") .allowFiltering())) .containsExactly(row(1, 2, 6, 2L, 12), row(2, 2, 6, 1L, 6)); .from(table) .where(eq("a", 1)) .groupBy("a", "b", "c"))) .containsExactly(row(1, 2, 6, 1L, 6), row(1, 2, 12, 1L, 12), row(1, 4, 12, 2L, 24)); session() .execute( select("a", count("a")).distinct().from(table).where(eq("a", 1)).groupBy("a"))) .containsExactly(row(1, 1L)); .from(table) .where(eq("a", 1)) .groupBy("a", "b", "c") .limit(2))) .containsExactly(row(1, 2, 6, 1L, 6), row(1, 2, 12, 1L, 12)); .from(table) .where(eq("a", 1)) .groupBy("a", "b", "c") .perPartitionLimit(2))) .containsExactly(row(1, 2, 6, 1L, 6), row(1, 2, 12, 1L, 12)); .from(table)
.from(table) .where(eq("b", 2)) .groupBy("a", "b") .allowFiltering())) .containsExactly(row(1, 2, 6, 2L, 12), row(2, 2, 6, 1L, 6)); .from(table) .where(eq("a", 1)) .groupBy("a", "b", "c"))) .containsExactly(row(1, 2, 6, 1L, 6), row(1, 2, 12, 1L, 12), row(1, 4, 12, 2L, 24)); session() .execute( select("a", count("a")).distinct().from(table).where(eq("a", 1)).groupBy("a"))) .containsExactly(row(1, 1L)); .from(table) .where(eq("a", 1)) .groupBy("a", "b", "c") .limit(2))) .containsExactly(row(1, 2, 6, 1L, 6), row(1, 2, 12, 1L, 12)); .from(table) .where(eq("a", 1)) .groupBy("a", "b", "c") .perPartitionLimit(2))) .containsExactly(row(1, 2, 6, 1L, 6), row(1, 2, 12, 1L, 12)); .from(table)