Enable cassandra-cli to list rows, and page through rows in a column family ---------------------------------------------------------------------------
Key: CASSANDRA-1088 URL: https://issues.apache.org/jira/browse/CASSANDRA-1088 Project: Cassandra Issue Type: New Feature Components: Tools Affects Versions: 0.6.1 Reporter: Frank Du Fix For: 0.6.2 I have been looking for showing rows and paging through rows. Finally I write this extension to cassandra-cli tool. Let's assume that we have the following data in column family named 'CF1': Row 1: key: fdu1, name: 'Frank Du', city: 'NYC' Row 2: key: fdu2, name: 'Jonathan Ellis' Row 3: key: fdu3, name: 'Eric Evans' ============================== Syntax: LIST columnFamilyName[ startKey : endKey ] ([ 'superCoumnName' ]) ( LIMIT count (OFFSET offset)? | LIMIT offset, count)? For example: list CF1[ '' : '' ] // list all the 3 rows in CF1 list CF1[ '' : '' ] limit 1, 10 // list all rows, offset from index 1. So it will show 2 rows list CF1[ 'fdu2' : '' ] limit 10 // show the rows 'fdu2' and 'fdu3' The limit clause have the same syntax with MySql. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.