Cassandra copy command is giving OverflowError

[AI Rumman]

Hi,

This is my first post here. I am copying my writings from

https://stackoverflow.com/questions/46354677/cassandra-copy-command-is-giving-overflowerror


I am new with Cassandra and running DataStax Cassandra 4.8.14.

My cluster is as:

3 nodes - cassandra

3 nodes - solr search by DataStax

Table:

CREATE TABLE keyspace1.table1 (
    id bigint,
    is_dir boolean,
    dir text,
    name text,
    created_date timestamp,
    size bigint,
    solr_query text,
    status text,
    PRIMARY KEY (id, is_dir, dir, name)
) WITH CLUSTERING ORDER BY (is_dir ASC, dir ASC, name ASC)
    AND bloom_filter_fp_chance = 0.01
    AND caching = '{"keys":"ALL", "rows_per_partition":"NONE"}'
    AND comment = ''
    AND compaction = {'class':
'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'}
    AND compression = {'sstable_compression':
'org.apache.cassandra.io.compress.LZ4Compressor'}
    AND dclocal_read_repair_chance = 0.1
    AND default_time_to_live = 0
    AND gc_grace_seconds = 864000
    AND max_index_interval = 2048
    AND memtable_flush_period_in_ms = 0
    AND min_index_interval = 128
    AND read_repair_chance = 0.0
    AND speculative_retry = '99.0PERCENTILE';
CREATE CUSTOM INDEX keyspace1_table1_created_date_index ON
keyspace1.table1 (created_date) USING
'com.datastax.bdp.search.solr.Cql3SolrSecondaryIndex';
CREATE CUSTOM INDEX keyspace1_table1_size_index ON keyspace1.table1
(size) USING 'com.datastax.bdp.search.solr.Cql3SolrSecondaryIndex';
CREATE CUSTOM INDEX keyspace1_table1_solr_query_index ON
keyspace1.table1 (solr_query) USING
'com.datastax.bdp.search.solr.Cql3SolrSecondaryIndex';
CREATE CUSTOM INDEX keyspace1_table1_status_index ON keyspace1.table1
(status) USING 'com.datastax.bdp.search.solr.Cql3SolrSecondaryIndex';

Command executed:

COPY keyspace1.table1 TO '/tmp/table1.csv';

I was trying to execute copy command and got the following error:

<stdin>:10:Error for (None, -9207222088349382333): OverflowError -
date value out of range (will try again later attempt 1 of 5)
<stdin>:10:Error for (-2699117314734179807, -2639913056120220671):
NoHostAvailable - ('Unable to complete the operation against any
hosts', {}) (permanently given up after 95000 rows and 1 attempts)
<stdin>:10:Error for (4414337294902011474, 4418434771303296337):
NoHostAvailable - ('Unable to complete the operation against any
hosts', {}) (will try again later attempt 1 of 5)
<stdin>:10:Error for (-835790340821162882, -820685939947495393):
NoHostAvailable - ('Unable to complete the operation against any
hosts', {}) (permanently given up after 49000 rows and 1 attempts)

Can anyone please tell me what it means?

Thanks.