cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Joe Stein <crypt...@gmail.com>
Subject Using tab in CQL COPY DELIMITER
Date Sat, 04 Jan 2014 23:20:36 GMT
Hi, trying to use a tab delimiter when copying out of c* (2.0.4) and
getting an error

cqlsh:test> CREATE TABLE airplanes (
           ...   name text PRIMARY KEY,
           ...   manufacturer ascii,
           ...   year int,
           ...   mach float
           ... );
cqlsh:bombast> INSERT INTO airplanes   (name, manufacturer, year, mach)
VALUES ('P38-Lightning', 'Lockheed', 1937, 7);
cqlsh:bombast> COPY airplanes (name, manufacturer, year, mach) TO
'temp.tsv' WITH DELIMITER = '\t';
"delimiter" must be an 1-character string

any ideas how to use tabs as a delimiter?  Thanks!!!!

/*******************************************
 Joe Stein
 Founder, Principal Consultant
 Big Data Open Source Security LLC
 http://www.stealth.ly
 Twitter: @allthingshadoop <http://www.twitter.com/allthingshadoop>
********************************************/

Mime
View raw message