[
https://issues.apache.org/jira/browse/CASSANDRA-6773?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Shiti Saxena updated CASSANDRA-6773:
------------------------------------
Description:
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
was:
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
> 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 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)
