[CASSANDRA-1088] Enable cassandra-cli to list rows, and page through rows in a column family

• Type: New Feature
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 0.7 beta 3
• Component/s: Legacy/Tools
• Labels: cassandra-cli
• Assignee: James P. Ancona
• Reporter: Frank Du

Authors

James P. Ancona

Reviewers

Jonathan Ellis

• Created: 13/May/10 20:03
• Updated: 16/Apr/19 09:33
• Resolved: 18/Oct/10 17:56

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

Issue Links

• relates to: CASSANDRA-1073 EOFException with Cassandra.Client.get_range_slices() API