RE: [EXTERNAL] Cassandra copy command is giving OverflowError

[Mohapatra, Kishore]

Try this.

COPY keyspace1.table1 TO '/tmp/table1.csv' WITH PAGETIMEOUT=40 AND PAGESIZE=20;

Thanks

Kishore Mohapatra
Principal Operations DBA
Seattle, WA
Email : kishore.mohapa...@nuance.com<mailto:kishore.mohapa...@nuance.com>


From: AI Rumman [mailto:rumman...@gmail.com]
Sent: Thursday, September 21, 2017 11:24 PM
To: user@cassandra.apache.org
Subject: [EXTERNAL] Cassandra copy command is giving OverflowError


Hi,

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

https://stackoverflow.com/questions/46354677/cassandra-copy-command-is-giving-overflowerror<https://urldefense.proofpoint.com/v2/url?u=https-3A__stackoverflow.com_questions_46354677_cassandra-2Dcopy-2Dcommand-2Dis-2Dgiving-2Doverflowerror&d=DwMFaQ&c=djjh8EKwHtOepW4Bjau0lKhLlu-DxM1dlgP0rrLsOzY&r=O20_rcIS1QazTO3_J10I1cPIygxnuBZ4sUCz1TS16XE&m=WVMxYLsaSHTdagCzuPZ_weE2J4Hq1UK7pl-QUvvm-Qk&s=OSU0O7iolFVo5R76vXgSBXzY33AbVkHUF4lCBVb8jz4&e=>

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.