You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Aaron Turner (JIRA)" <ji...@apache.org> on 2011/08/10 18:35:26 UTC
[jira] [Created] (CASSANDRA-3012) cassandra-cli list limit
number of columns returned
cassandra-cli list <CF> limit number of columns returned
--------------------------------------------------------
Key: CASSANDRA-3012
URL: https://issues.apache.org/jira/browse/CASSANDRA-3012
Project: Cassandra
Issue Type: Improvement
Components: Core
Affects Versions: 0.8.3
Reporter: Aaron Turner
Priority: Minor
Right now in the CLI, running: list MyColumnFamily; will return the first 100 rows and quite easily the bazillion columns associated with those rows. Often times you're interested in just the row keys in the CF and less interested in all the columns or perhaps only a subset of columns.
Hence it would be nice to have the limit option take a second, optional parameter limiting the number of columns to return:
list MyCF[startkey:] limit 10, 30;
would limit the columns per row to 30 while limiting the number of rows to 10 and starting at key "startkey". It should also take values 0 (no columns) and -1 (all columns). -1 should also be acceptable as a row limit also denoting "all rows" rather then requiring the user to type a large positive number.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-3012) cassandra-cli list limit
number of columns returned
Posted by "Dave Brosius (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-3012?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13215171#comment-13215171 ]
Dave Brosius commented on CASSANDRA-3012:
-----------------------------------------
patch is against trunk, yes.
> cassandra-cli list <CF> limit number of columns returned
> --------------------------------------------------------
>
> Key: CASSANDRA-3012
> URL: https://issues.apache.org/jira/browse/CASSANDRA-3012
> Project: Cassandra
> Issue Type: Improvement
> Components: Core
> Affects Versions: 1.0.7
> Reporter: Aaron Turner
> Assignee: Dave Brosius
> Priority: Minor
> Labels: cli, limit
> Fix For: 1.1.1
>
> Attachments: cli_list_columncount.diff
>
>
> Right now in the CLI, running: list MyColumnFamily; will return the first 100 rows and quite easily the bazillion columns associated with those rows. Often times you're interested in just the row keys in the CF and less interested in all the columns or perhaps only a subset of columns.
> Hence it would be nice to have the limit option take a second, optional parameter limiting the number of columns to return:
> list MyCF[startkey:] limit 10, 30;
> would limit the columns per row to 30 while limiting the number of rows to 10 and starting at key "startkey". It should also take values 0 (no columns) and -1 (all columns). -1 should also be acceptable as a row limit also denoting "all rows" rather then requiring the user to type a large positive number.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (CASSANDRA-3012) cassandra-cli list limit
number of columns returned
Posted by "Dave Brosius (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-3012?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dave Brosius updated CASSANDRA-3012:
------------------------------------
Attachment: (was: cli_list_columncount.diff)
> cassandra-cli list <CF> limit number of columns returned
> --------------------------------------------------------
>
> Key: CASSANDRA-3012
> URL: https://issues.apache.org/jira/browse/CASSANDRA-3012
> Project: Cassandra
> Issue Type: Improvement
> Components: Core
> Affects Versions: 1.0.7
> Reporter: Aaron Turner
> Assignee: Dave Brosius
> Priority: Minor
> Labels: cli, limit
> Fix For: 1.1.1
>
> Attachments: cli_list_columncount.diff
>
>
> Right now in the CLI, running: list MyColumnFamily; will return the first 100 rows and quite easily the bazillion columns associated with those rows. Often times you're interested in just the row keys in the CF and less interested in all the columns or perhaps only a subset of columns.
> Hence it would be nice to have the limit option take a second, optional parameter limiting the number of columns to return:
> list MyCF[startkey:] limit 10, 30;
> would limit the columns per row to 30 while limiting the number of rows to 10 and starting at key "startkey". It should also take values 0 (no columns) and -1 (all columns). -1 should also be acceptable as a row limit also denoting "all rows" rather then requiring the user to type a large positive number.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-3012) cassandra-cli list limit
number of columns returned
Posted by "Pavel Yaskevich (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-3012?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13215180#comment-13215180 ]
Pavel Yaskevich commented on CASSANDRA-3012:
--------------------------------------------
How about syntax like 'list <cf>[...] limit X (columns Y)?' that will allow to just skip using 'columns Y' block when you want to return all columns and make syntax more intuitive because 'limit 10, 30' could be treated as limit min 10 max 30 rows?...
> cassandra-cli list <CF> limit number of columns returned
> --------------------------------------------------------
>
> Key: CASSANDRA-3012
> URL: https://issues.apache.org/jira/browse/CASSANDRA-3012
> Project: Cassandra
> Issue Type: Improvement
> Components: Core
> Affects Versions: 1.0.7
> Reporter: Aaron Turner
> Assignee: Dave Brosius
> Priority: Minor
> Labels: cli, limit
> Fix For: 1.1.1
>
> Attachments: cli_list_columncount.diff
>
>
> Right now in the CLI, running: list MyColumnFamily; will return the first 100 rows and quite easily the bazillion columns associated with those rows. Often times you're interested in just the row keys in the CF and less interested in all the columns or perhaps only a subset of columns.
> Hence it would be nice to have the limit option take a second, optional parameter limiting the number of columns to return:
> list MyCF[startkey:] limit 10, 30;
> would limit the columns per row to 30 while limiting the number of rows to 10 and starting at key "startkey". It should also take values 0 (no columns) and -1 (all columns). -1 should also be acceptable as a row limit also denoting "all rows" rather then requiring the user to type a large positive number.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (CASSANDRA-3012) cassandra-cli list limit
number of columns returned
Posted by "Jonathan Ellis (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-3012?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jonathan Ellis updated CASSANDRA-3012:
--------------------------------------
Reviewer: xedin
Fix Version/s: 1.1.1
Assignee: Dave Brosius
(I'm assuming this is against trunk?)
> cassandra-cli list <CF> limit number of columns returned
> --------------------------------------------------------
>
> Key: CASSANDRA-3012
> URL: https://issues.apache.org/jira/browse/CASSANDRA-3012
> Project: Cassandra
> Issue Type: Improvement
> Components: Core
> Affects Versions: 1.0.7
> Reporter: Aaron Turner
> Assignee: Dave Brosius
> Priority: Minor
> Labels: cli, limit
> Fix For: 1.1.1
>
> Attachments: cli_list_columncount.diff
>
>
> Right now in the CLI, running: list MyColumnFamily; will return the first 100 rows and quite easily the bazillion columns associated with those rows. Often times you're interested in just the row keys in the CF and less interested in all the columns or perhaps only a subset of columns.
> Hence it would be nice to have the limit option take a second, optional parameter limiting the number of columns to return:
> list MyCF[startkey:] limit 10, 30;
> would limit the columns per row to 30 while limiting the number of rows to 10 and starting at key "startkey". It should also take values 0 (no columns) and -1 (all columns). -1 should also be acceptable as a row limit also denoting "all rows" rather then requiring the user to type a large positive number.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (CASSANDRA-3012) cassandra-cli list limit
number of columns returned
Posted by "Dave Brosius (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-3012?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dave Brosius updated CASSANDRA-3012:
------------------------------------
Attachment: cli_list_columncount.diff
> cassandra-cli list <CF> limit number of columns returned
> --------------------------------------------------------
>
> Key: CASSANDRA-3012
> URL: https://issues.apache.org/jira/browse/CASSANDRA-3012
> Project: Cassandra
> Issue Type: Improvement
> Components: Core
> Affects Versions: 0.8.3
> Reporter: Aaron Turner
> Priority: Minor
> Labels: cli, limit
> Attachments: cli_list_columncount.diff
>
>
> Right now in the CLI, running: list MyColumnFamily; will return the first 100 rows and quite easily the bazillion columns associated with those rows. Often times you're interested in just the row keys in the CF and less interested in all the columns or perhaps only a subset of columns.
> Hence it would be nice to have the limit option take a second, optional parameter limiting the number of columns to return:
> list MyCF[startkey:] limit 10, 30;
> would limit the columns per row to 30 while limiting the number of rows to 10 and starting at key "startkey". It should also take values 0 (no columns) and -1 (all columns). -1 should also be acceptable as a row limit also denoting "all rows" rather then requiring the user to type a large positive number.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (CASSANDRA-3012) cassandra-cli list limit
number of columns returned
Posted by "Dave Brosius (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-3012?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dave Brosius updated CASSANDRA-3012:
------------------------------------
Attachment: cli_list_columncount.diff
add help messages too.
list cf limit 100, 0;
etc.
> cassandra-cli list <CF> limit number of columns returned
> --------------------------------------------------------
>
> Key: CASSANDRA-3012
> URL: https://issues.apache.org/jira/browse/CASSANDRA-3012
> Project: Cassandra
> Issue Type: Improvement
> Components: Core
> Affects Versions: 1.0.7
> Reporter: Aaron Turner
> Assignee: Dave Brosius
> Priority: Minor
> Labels: cli, limit
> Fix For: 1.1.1
>
> Attachments: cli_list_columncount.diff
>
>
> Right now in the CLI, running: list MyColumnFamily; will return the first 100 rows and quite easily the bazillion columns associated with those rows. Often times you're interested in just the row keys in the CF and less interested in all the columns or perhaps only a subset of columns.
> Hence it would be nice to have the limit option take a second, optional parameter limiting the number of columns to return:
> list MyCF[startkey:] limit 10, 30;
> would limit the columns per row to 30 while limiting the number of rows to 10 and starting at key "startkey". It should also take values 0 (no columns) and -1 (all columns). -1 should also be acceptable as a row limit also denoting "all rows" rather then requiring the user to type a large positive number.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (CASSANDRA-3012) cassandra-cli list limit
number of columns returned
Posted by "Dave Brosius (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-3012?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dave Brosius updated CASSANDRA-3012:
------------------------------------
Attachment: cli_list_columncount_2.diff
ok, new syntax
list cf limit 30;
list cf limit 30 columns 5;
list cf limit 30 columns 5 reversed;
list cf columns 3;
list cf columns 5 reversed;
> cassandra-cli list <CF> limit number of columns returned
> --------------------------------------------------------
>
> Key: CASSANDRA-3012
> URL: https://issues.apache.org/jira/browse/CASSANDRA-3012
> Project: Cassandra
> Issue Type: Improvement
> Components: Core
> Affects Versions: 1.0.7
> Reporter: Aaron Turner
> Assignee: Dave Brosius
> Priority: Minor
> Labels: cli, limit
> Fix For: 1.1.1
>
> Attachments: cli_list_columncount.diff, cli_list_columncount_2.diff
>
>
> Right now in the CLI, running: list MyColumnFamily; will return the first 100 rows and quite easily the bazillion columns associated with those rows. Often times you're interested in just the row keys in the CF and less interested in all the columns or perhaps only a subset of columns.
> Hence it would be nice to have the limit option take a second, optional parameter limiting the number of columns to return:
> list MyCF[startkey:] limit 10, 30;
> would limit the columns per row to 30 while limiting the number of rows to 10 and starting at key "startkey". It should also take values 0 (no columns) and -1 (all columns). -1 should also be acceptable as a row limit also denoting "all rows" rather then requiring the user to type a large positive number.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira