Databases
StackOverflow2013
Postsdbo
POCan you sort a GET on a Cassandra column family by the Timestamp value created for each column entry, rather than the column Keys?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCan you sort a GET on a Cassandra column family by the Timestamp value created for each column entry, rather than the column Keys?
    primarykey
    data
    text
    <p>Basically I have a 'thread line' where new threads are made and a TimeUUID is used as a key. Which obviously provides sorting of a new thread quite easily, espically when say making a query of the latest 20 threads etc. </p> <p>My problem is that when a new 'post' is made to a thread I want to be able to 'bump' that thread to the front of the 'thread line' which is where the problem comes in, how do I basically make this happen so I can still make queries that can still be selected in the right order without providing any kind of duplicates etc.</p> <p>The only way I can see this working is if rather than a column family sorting via a TimeUUID I need the column family to sort via the insertion Timestamp, therefore I can use the unique thread IDs for column keys and retrieve these in the order they are inserted or reinserted rather than by TimeUUID? Is this possible or am I missing a simple trick that allows for this? As far as I know you have to set a particular comparitor or otherwise it defaults to bytes?</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USPeter Fox
    1. USPeter Fox
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POCan you sort a GET on a Cassandra column family by the Timestamp value created for each column entry, rather than the column Keys?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POCan you sort a GET on a Cassandra column family by the Timestamp value created for each column entry, rather than the column Keys?
      1. USYuya Kitajima
      1. VTFavorite
    3. VO
      singulars
      1. POCan you sort a GET on a Cassandra column family by the Timestamp value created for each column entry, rather than the column Keys?
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload