[CASSANDRA-19150] Align values in rows in CQLSH right for numbers, left for text

• Type: Improvement
• Status: In Progress
• Priority: Low
• Resolution: Unresolved
• Fix Version/s: 5.x
• Component/s: CQL/Interpreter
• Change Category: Operability
• Complexity: Low Hanging Fruit
• Platform: All
• Assignee: Arun Ganesh
• Reporter: Stefan Miklosovic

Authors

Arun Ganesh

• Created: 04/Dec/23 11:29
• Updated: 03/Jun/24 12:06

Description

Updated Jan 17 2024 after dev discussion

Change CQLSH to left-align text while continue to right-align numbers.  This will match how Postgres shell and Excel treat alignment of text and number.

-------------

Original

We need to make this

https://github.com/apache/cassandra/blob/trunk/pylib/cqlshlib/cqlshmain.py#L1101

configurable so values in columns are either all on left or on right side of the column (basically change col.rjust to col.ljust).

By default, it would be like it is now but there would be configuration property in cqlsh for that as well as a corresponding CQLSH command (optional), something like

ALIGNMENT LEFT|RIGHT

cc bschoeni

Issue Links

• relates to: CASSANDRA-14572 Expose all table metrics in virtual table
• links to: CQLSH should right-align numbers, left-align text
• links to: GitHub Pull Request #2980
• links to: Trunk PR