[
https://issues.apache.org/jira/browse/CASSANDRA-6773?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Shiti Saxena updated CASSANDRA-6773:
------------------------------------
Attachment: trunk-6773.txt
> 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
> Assignee: Shiti Saxena
> Priority: Trivial
> Labels: CQL, CQL3
> Attachments: trunk-6773.txt
>
>
> 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.2#6252)
