[ https://issues.apache.org/jira/browse/CASSANDRA-1088?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Frank Du updated CASSANDRA-1088: -------------------------------- Description: 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 keyRangeExpression limitClause? keyRangeExpression: columnFamilyName[ startKey : endKey ] ( [ 'superCoumnName' ] )? limitClause: LIMIT count (OFFSET offset)? \| LIMIT offset, count The limit clause is the same with MySql. Examples: ========================= // list all the 3 rows in CF1 list CF1[ '' : '' ] // list all rows, offset from index 1. So it will show 2 rows list CF1[ '' : '' ] limit 1, 10 // show the rows 'fdu2' and 'fdu3' list CF1[ 'fdu2' : '' ] limit 10 was: 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 keyRangeExpression limitClause? keyRangeExpression: columnFamilyName[ startKey : endKey ] ( [ 'superCoumnName' ] )? limitClause: LIMIT count (OFFSET offset)? | LIMIT offset, count The limit clause is the same with MySql. Examples: ========================= // list all the 3 rows in CF1 list CF1[ '' : '' ] // list all rows, offset from index 1. So it will show 2 rows list CF1[ '' : '' ] limit 1, 10 // show the rows 'fdu2' and 'fdu3' list CF1[ 'fdu2' : '' ] limit 10 > 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 > > Attachments: patch.txt > > > 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 keyRangeExpression limitClause? > keyRangeExpression: > columnFamilyName[ startKey : endKey ] ( [ 'superCoumnName' ] )? > limitClause: > LIMIT count (OFFSET offset)? > \| LIMIT offset, count > The limit clause is the same with MySql. > Examples: > ========================= > // list all the 3 rows in CF1 > list CF1[ '' : '' ] > // list all rows, offset from index 1. So it will show 2 rows > list CF1[ '' : '' ] limit 1, 10 > // show the rows 'fdu2' and 'fdu3' > list CF1[ 'fdu2' : '' ] limit 10 -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.