[jira] [Created] (CASSANDRA-6773) Delimiter not working for special characters in COPY command from CQLSH

["Shiti Saxena (JIRA)" <ji...@apache.org>]

Shiti Saxena created CASSANDRA-6773:
---------------------------------------

             Summary: 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


COPY command from CQLSH which can be used to load data from CSV files was 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)