[
https://issues.apache.org/jira/browse/CASSANDRA-19985?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Brad Schoening updated CASSANDRA-19985:
---------------------------------------
Description:
Existing CQLSH output formatting provides tabular formatting using grid-like
separators and text alignment which is designed for user readability.
When CQL is run for non-interactive tasks as part of a pipeline this formatting
complicates the machine processing of the output. As an example,
[Sqlite|https://www.sqlite.org/cli.html] has a command line flag -mode to
switch between tablular, csv, and several other supported formats.
This enhancement will provide a new mode argument which will initially offer
tabular and csv output formats. Tabular will remain the default so there will
be no change for existing users. In the future, other modes such as json and
insert could be added.
{noformat}
--mode={tabular, csv}
Specify an output display format. The default is tabular.
{noformat}
The existing Copy To can be used for exporting to CSV, but it doesn't allow for
query criteria.
In cqlshmain.py, the EXPAND CQLSH option which uses print_formatted_result()
for result output is an example of alternative formatting.
was:
Existing CQLSH output formatting provides tabular formatting using grid-like
separators and text alignment which is designed for user readability.
When CQL is run for non-interactive tasks as part of a pipeline this formatting
complicates the machine processing of the output. As an example,
[Sqlite|https://www.sqlite.org/cli.html] has a command line flag -mode to
switch between tablular, csv, and several other supported formats.
This enhancement will provide a new mode argument which will initially offer
tabular and csv output formats. Tabular will remain the default so there will
be no change for existing users. In the future, other modes such as json and
insert could be added.
{noformat}
--mode={tabular, csv}
Specify an output display format. The default is tabular.
{noformat}
The existing Copy To can be used for exporting to CSV, but it doesn't allow for
query criteria.
> Enhance CQLSH to support machine-readable output formatting
> -----------------------------------------------------------
>
> Key: CASSANDRA-19985
> URL: https://issues.apache.org/jira/browse/CASSANDRA-19985
> Project: Apache Cassandra
> Issue Type: New Feature
> Components: CQL/Interpreter
> Reporter: Brad Schoening
> Priority: Normal
>
> Existing CQLSH output formatting provides tabular formatting using grid-like
> separators and text alignment which is designed for user readability.
> When CQL is run for non-interactive tasks as part of a pipeline this
> formatting complicates the machine processing of the output. As an example,
> [Sqlite|https://www.sqlite.org/cli.html] has a command line flag -mode to
> switch between tablular, csv, and several other supported formats.
> This enhancement will provide a new mode argument which will initially offer
> tabular and csv output formats. Tabular will remain the default so there will
> be no change for existing users. In the future, other modes such as json and
> insert could be added.
> {noformat}
> --mode={tabular, csv}
> Specify an output display format. The default is tabular.
> {noformat}
> The existing Copy To can be used for exporting to CSV, but it doesn't allow
> for query criteria.
> In cqlshmain.py, the EXPAND CQLSH option which uses print_formatted_result()
> for result output is an example of alternative formatting.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
