You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Shiti Saxena (JIRA)" <ji...@apache.org> on 2014/02/26 13:14:23 UTC
[jira] [Updated] (CASSANDRA-6773) Delimiter not working for special
characters in COPY command from CQLSH
[ 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)