cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Shiti Saxena (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CASSANDRA-6773) Delimiter not working for special characters in COPY command from CQLSH
Date Wed, 26 Feb 2014 12:16:22 GMT

     [ https://issues.apache.org/jira/browse/CASSANDRA-6773?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Shiti Saxena updated CASSANDRA-6773:
------------------------------------

    Labels: CQL CQL3  (was: CQL CQL3 patch)

> Delimiter not working for special characters in COPY command from CQLSH
> -----------------------------------------------------------------------
>
>                 Key: CASSANDRA-6773
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-6773
>             Project: Cassandra
>          Issue Type: Bug
>            Reporter: Shiti Saxena
>              Labels: CQL, CQL3
>
> COPY command from CQLSH which can be used to load data from CSV files is not working
with option delimiter='\t'
> cqlsh>CREATE TABLE airplanes (
> name text PRIMARY KEY,
> manufacturer ascii,
> year int,
> mach float
> );
> cqlsh>INSERT INTO airplanes   (name, manufacturer, year, mach)   VALUES ('P38-Lightning',
'Lockheed', 1937, 7);
> cqlsh> SELECT * FROM airplanes;   
> name          | mach | manufacturer | year 
> --------------+------+--------------+------  
> P38-Lightning |  0.7 |     Lockheed | 1937
> cqlsh> COPY airplanes (name, manufacturer, year, mach) TO 'temp.tsv' WITH DELIMITER
= '\t';
> "delimiter" must be an 1-character string
> cqlsh> COPY airplanes (name, manufacturer, year, mach) FROM 'temp.csv' WITH DELIMITER
= '\t';
> "delimiter" must be an 1-character string



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)

Mime
View raw message