copy one table to another in cassandra
10,206
It turned out that this is a known bug in Cassandra 1.2.2.
The same commands work fine in 2.0.x, so an upgrade will fix the problem.
Author by
Helping Hand..
Pentaho BI-ETL Developer.. Pentaho Trainer.. Reach me out @ [email protected] LinkedIn : https://in.linkedin.com/in/umang-shah-771b0a62 Blog : https://shahumang.wordpress.com/
Updated on June 04, 2022Comments
-
Helping Hand.. almost 2 years
i want to copy data from standardevents to standardeventstemp.. below steps i am doing
COPY events.standardevents (uuid, data, name, time, tracker, type, userid) TO 'temp.csv'; truncate standardevents; COPY event.standardeventstemp (uuid, data, name, time, tracker, type, userid) FROM 'temp.csv';
but i am getting below error after 3rd step
Bad Request: Invalid STRING constant (3a1ccec0-ef77-11e3-9e56-22000ae3163a) for name of type uuid
aborting import at column #0, previously inserted values are still present.
can anybody explain the cause of this error and how can i resolve this
datatype of uuid is uuid the rest of the datatypes are varchar
CREATE TABLE standardevents ( uuid uuid PRIMARY KEY, data text, name text, time text, tracker text, type text, userid text ) WITH bloom_filter_fp_chance=0.010000 AND caching='KEYS_ONLY' AND comment='' AND dclocal_read_repair_chance=0.000000 AND gc_grace_seconds=864000 AND read_repair_chance=0.100000 AND replicate_on_write='true' AND populate_io_cache_on_flush='false' AND compaction={'class': 'SizeTieredCompactionStrategy'} AND compression={'sstable_compression': 'SnappyCompressor'};