[
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 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.
> 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.
