cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aleksey Yeschenko (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-4594) COPY TO and COPY FROM don't default to consistent ordering of columns
Date Tue, 18 Sep 2012 19:00:08 GMT

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

Aleksey Yeschenko commented on CASSANDRA-4594:
----------------------------------------------

The issue is now gone.
                
> COPY TO and COPY FROM don't default to consistent ordering of columns
> ---------------------------------------------------------------------
>
>                 Key: CASSANDRA-4594
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4594
>             Project: Cassandra
>          Issue Type: Bug
>         Environment: Happens in CQLSH 2, may or may not happen in CQLSH 3
>            Reporter: Tyler Patterson
>            Assignee: paul cannon
>            Priority: Minor
>              Labels: cqlsh
>             Fix For: 1.1.6
>
>
> Here is the input:
> {code}                                                         
> CREATE KEYSPACE test WITH strategy_class = 'SimpleStrategy' AND strategy_options:replication_factor
= 1;
> USE test;                                                                       
>                                                                                 
> CREATE TABLE airplanes (                                                        
>                 name text PRIMARY KEY,                                          
>                 manufacturer ascii,                                             
>                 year int,                                                       
>                 mach float                                                      
>             );                                                                  
>                                                                                 
> INSERT INTO airplanes (name, manufacturer, year, mach) VALUES ('P38-Lightning', 'Lockheed',
1937, '.7');
>                                                                                 
> COPY airplanes TO 'temp.cfg' WITH HEADER=true;                                  
>                                                                                 
> TRUNCATE airplanes;                                                                
>                                                                                    
> COPY airplanes FROM 'temp.cfg' WITH HEADER=true;                                
>                                                                                    
> SELECT * FROM airplanes;
> {code}
> Here is what happens when executed. Note how it tried to import the float into the int
column:
> {code}
> cqlsh:test> DROP KEYSPACE test;                                                  
             
> cqlsh:test> CREATE KEYSPACE test WITH strategy_class = 'SimpleStrategy' AND strategy_options:replication_factor
= 1;
> cqlsh:test> USE test;                                                            
          
> cqlsh:test>                                                                      
             
> cqlsh:test> CREATE TABLE airplanes (                                            
>         ...                 name text PRIMARY KEY,                              
>         ...                 manufacturer ascii,                                 
>         ...                 year int,                                           
>         ...                 mach float                                          
>         ...             );                                                      
> cqlsh:test>                                                                     
> cqlsh:test> INSERT INTO airplanes (name, manufacturer, year, mach) VALUES ('P38-Lightning',
'Lockheed', 1937, '.7');
> cqlsh:test>                                                                     
> cqlsh:test> COPY airplanes TO 'temp.cfg' WITH HEADER=true;                      
> 1 rows exported in 0.003 seconds.                                               
> cqlsh:test> TRUNCATE airplanes;                                                 
> cqlsh:test>                                                                     
> cqlsh:test> COPY airplanes FROM 'temp.cfg' WITH HEADER=true;                    
> Bad Request: unable to make int from '0.7'                                      
> Aborting import at record #0 (line 1). Previously-inserted values still present.
> 0 rows imported in 0.002 seconds.
> {code}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message