cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "umang shah" <>
Subject problem with copy command and heap size
Date Fri, 27 Jun 2014 04:01:40 GMT

1) i am using below commands for coping data


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';


if table is not containing any field with uuid data-type above commands are
working fine but if it is containig data-type as a uuid then it is giving me

below error


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. 


Below is the description of my column-family


CREATE TABLE standardevents (

  uuid uuid PRIMARY KEY,

  data text,

  name text,

  time text,

  tracker text,

  type text,

  userid text


  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'};


2) Facing problem of Heap is 0.8116662666877581 full


checked the logs getting below messages (line 142) Heap is 0.8116662666877581 full.  You may need
to reduce memtable and/or cache sizes.  Cassandra will now flush up to the
two largest memtables to free up memory.  Adjust flush_largest_memtables_at
threshold in cassandra.yaml if you don't want Cassandra to do this
automatically (line 3512) Unable to reduce heap usage since there are
no dirty column families


i checked the file currently it is occuping 



HEAP_NEWSIZE="800M" which i guess is maximum.


because of this constanly getting heap size error on every command.


View raw message