cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Edge (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (CASSANDRA-8935) cqlsh: Make the column order in COPY FROM more apparent
Date Mon, 23 Nov 2015 10:29:11 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-8935?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15021503#comment-15021503
] 

Michael Edge edited comment on CASSANDRA-8935 at 11/23/15 10:28 AM:
--------------------------------------------------------------------

Tyler, just want to confirm that this is what you are thinking of:

{code}
cqlsh:cats> copy cats (block_id, breed, color, short_hair, age) from 'cats.csv';
 
starting copy cats.cats ['block_id', 'breed', 'color', 'short_hair', 'age'].

7 rows imported in 0.324 seconds.
{code}

or this when no columns are specified:

{code}
cqlsh:cats> copy cats  from 'cats.csv';

starting copy cats.cats ['block_id', 'breed', 'color', 'short_hair', 'age'].

7 rows imported in 0.276 seconds.
{code}

If so, I'll upload the patch.



was (Author: michaeledge):
Tyler, just want to confirm that this is what you are thinking of:

{code}
cqlsh:cats> copy cats (block_id, breed, color, short_hair, age) from 'cats.csv';
 
starting copy cats.cats ['block_id', 'breed', 'color', 'short_hair', 'age'].

7 rows imported in 0.324 seconds.
{code}

or this is no columns are specified:

{code}
cqlsh:cats> copy cats  from 'cats.csv';

starting copy cats.cats ['block_id', 'breed', 'color', 'short_hair', 'age'].

7 rows imported in 0.276 seconds.
{code}

If so, I'll upload the patch.


> cqlsh: Make the column order in COPY FROM more apparent
> -------------------------------------------------------
>
>                 Key: CASSANDRA-8935
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-8935
>             Project: Cassandra
>          Issue Type: Improvement
>          Components: Tools
>            Reporter: Tyler Hobbs
>            Priority: Trivial
>              Labels: cqlsh
>             Fix For: 2.1.x
>
>
> When running {{COPY FROM}}, we should print the order of columns that we're expecting
to make it more obvious when the data is not properly aligned.  Otherwise, the user will simply
see a type or syntax error and have to try to decipher it.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message