Cassandra filter with ordering query modeling

[Behroz Sikander]

Hi,own vote
favorite
<https://stackoverflow.com/questions/49049760/cassandra-filter-with-ordering-query-modeling#>

I am new to Cassandra and I am trying to model a table in Cassandra. My
queries look like the following

Query #1: select * from TableA where Id = "123"Query #2: select * from
TableA where name="test" orderby startTime DESCQuery #3: select * from
TableA where state="running" orderby startTime DESC

I have been able to build the table for Query #1 which looks like

    val tableAStatement = SchemaBuilder.createTable("tableA").ifNotExists.
    addPartitionKey(Id, DataType.uuid).
    addColumn(Name, DataType.text).
    addColumn(StartTime, DataType.timestamp).
    addColumn(EndTime, DataType.timestamp).
    addColumn(State, DataType.text)

    session.execute(tableAStatement)

but for Query#2 and 3, I have tried many different things but failed.
Everytime, I get stuck in a different error from cassandra.

Considering the above queries, what would be the right table model? What is
the right way to model such queries.
Regards,
Behroz