[CASSANDRA-5636] Add row count to select output a la psql

• Type: New Feature
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 2.0 beta 1
• Component/s: Legacy/Tools
• Labels: cqlsh
• Assignee: Aleksey Yeschenko
• Reporter: Jonathan Ellis

Authors

Aleksey Yeschenko

Reviewers

Brandon Williams

• Created: 13/Jun/13 21:01
• Updated: 16/Apr/19 09:32
• Resolved: 14/Jun/13 22:56

Description

This is handy since counting rows that look mostly alike can be painful; it also makes it clear that cqlsh isn't ignoring you when you select something that doesn't exist.

Here is what psql does:

company=> select fname, salary from employee;

fname   |  salary
--------+--------
John    |30000.00
Franklin|40000.00
Alica   |25000.00
Jennifer|43000.00
Ramish  |38000.00
Joyce   |25000.00
Ahmad   |25000.00
James   |55000.00
(8 rows)