Table_Select.W always returns default cluster (1)

[RaAleks]

Hi @doanduyhai, i have a table such as below. So i want that Achilles returns me table with cluster2 in descending order. But Table_Select.W always returns W_Cluster1, that's why i can't see ability to set descending order for my second cluster. Also below code for test manager what i want to have.

@Table(table = "test_table") public class TestTable {

@PartitionKey
private String partition;

@ClusteringColumn
private String cluster1;

@ClusteringColumn(value = 2, asc = false)
private Date cluster2;

}

testTable_manager .dsl() .select() .allColumns_FromBaseTable() .where() .partition() .Eq("test") .orderByCluster2Descending() .groupBy() .cluster1_cluster2() .getList();

[doanduyhai]

It is not an issue. By design Cassandra only allow you to use ORDER BY on the 1st clustering column in your query

[RaAleks]

Oh, thanks for quick response, just tried query to cassandra in console, and you are absolutely right! Many thanks!

[RaAleks]

But if i write this request, cassandra allow me to make second clustering column in desc order. SELECT * FROM test WHERE partition= 'test' ORDER BY cluster1 DESC, cluster2 DESC;

But achilles not allows.

[doanduyhai]

Which version of Cassandra are you using ?

[doanduyhai]

Also please provide CREATE TABLE script

[RaAleks]

Here is create table CREATE TABLE test ( partition text, cluster1 text, cluster2 text, PRIMARY KEY (partition , cluster1 , cluster2 ) ); Version: [cqlsh 5.0.1 | Cassandra 3.11.3 | CQL spec 3.4.4 | Native protocol v4]