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.

Share:
10,206
Helping Hand..
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, 2022

Comments

  • Helping Hand..
    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'};