Andrew Grosser created CASSANDRA-20809:
------------------------------------------
Summary: COPY TO.. Crashes cassandra node
Key: CASSANDRA-20809
URL: https://issues.apache.org/jira/browse/CASSANDRA-20809
Project: Apache Cassandra
Issue Type: Bug
Reporter: Andrew Grosser
When I use COPY TO for a 4GB table, and I use copy to the server/node crashes
and is unreachable.
Using:
cqlsh -e "copy xxx.metadata to 'metadata.csv' with header = true AND
MAXBATCHSIZE=5;"
I'm using this schema:
```
CREATE TABLE metadata (
oid timeuuid,
obj text,
mtype text,
ref timeuuid,
offset int,
has_mbd_grnt32_8 boolean,
has_mbd_gtesml boolean,
mbd_grnt32_8 vector<float, 50265>,
mbd_gtesml vector<float, 384>,
model text,
result text,
rtype text,
updated_at timestamp,
rcats set<text>,
rprops map<text, text>,
rscores map<text, int>,
tags map<text, text>,
tokens set<text>,
PRIMARY KEY ((oid, obj, mtype), ref, offset)
) WITH CLUSTERING ORDER BY (ref DESC, offset ASC)
CREATE CUSTOM INDEX metadata_mbd_grnt32_8_idx ON metadata (mbd_grnt32_8) USING
'StorageAttachedIndex' WITH OPTIONS = \{'similarity_function': 'dot_product'};
CREATE CUSTOM INDEX metadata_mbd_gtesml_idx ON metadata (mbd_gtesml) USING
'StorageAttachedIndex' WITH OPTIONS = \{'similarity_function': 'dot_product'};
CREATE CUSTOM INDEX metadata_rcats_idx ON metadata (values(rcats)) USING
'org.apache.cassandra.index.sai.StorageAttachedIndex' WITH OPTIONS = \{'ascii':
'true', 'case_sensitive': 'true', 'normalize': 'true'};
CREATE CUSTOM INDEX metadata_ref_idx ON metadata (ref) USING
'org.apache.cassandra.index.sai.StorageAttachedIndex';
CREATE CUSTOM INDEX metadata_rprops_entries_idx ON metadata (entries(rprops))
USING 'org.apache.cassandra.index.sai.StorageAttachedIndex';
CREATE CUSTOM INDEX metadata_rprops_keys_idx ON metadata (keys(rprops)) USING
'org.apache.cassandra.index.sai.StorageAttachedIndex' WITH OPTIONS = \{'ascii':
'true', 'case_sensitive': 'true', 'normalize': 'true'};
CREATE CUSTOM INDEX metadata_rprops_values_idx ON metadata (values(rprops))
USING 'org.apache.cassandra.index.sai.StorageAttachedIndex' WITH OPTIONS =
\{'ascii': 'true', 'case_sensitive': 'true', 'normalize': 'true'};
CREATE CUSTOM INDEX metadata_rscores_entries_idx ON metadata (entries(rscores))
USING 'org.apache.cassandra.index.sai.StorageAttachedIndex';
CREATE CUSTOM INDEX metadata_rscores_keys_idx ON metadata (keys(rscores)) USING
'org.apache.cassandra.index.sai.StorageAttachedIndex' WITH OPTIONS = \{'ascii':
'true', 'case_sensitive': 'true', 'normalize': 'true'};
CREATE CUSTOM INDEX metadata_rscores_values_idx ON metadata (values(rscores))
USING 'org.apache.cassandra.index.sai.StorageAttachedIndex';
CREATE INDEX metadata_tags_entries_idx ON metadata (entries(tags));
CREATE INDEX metadata_tags_keys_idx ON metadata (keys(tags));
CREATE INDEX metadata_tags_values_idx ON metadata (values(tags));
CREATE CUSTOM INDEX metadata_tokens_idx ON metadata (values(tokens)) USING
'org.apache.cassandra.index.sai.StorageAttachedIndex' WITH OPTIONS = \{'ascii':
'true', 'case_sensitive': 'true', 'normalize': 'true'};
```
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
