After importing csv file into killrvideo.videos_by_actor table.. i tried counting import count by select count(*) .. It gave me result but with some messages. Can someone please explain why did i see these messages. Also, saw some upsert.
Following is my table structure. Can someone please help on what mistakes i made on choosing primary key.
CREATE TABLE killrvideo.videos_by_actor (
actor text,
added_date timestamp,
video_id timeuuid,
character_name text,
description text,
encoding frozen<video_encoding>,
tags set<text>,
title text,
user_id uuid,
PRIMARY KEY (actor, added_date, video_id)
) WITH CLUSTERING ORDER BY (added_date DESC, video_id ASC)
cqlsh:killrvideo> COPY videos_by_actor (actor, added_date, video_id, character_name, description, encoding, tags, title, user_id) FROM 'videos_by_actor.csv' WITH HEADER = true; Using 1 child processes Starting copy of killrvideo.videos_by_actor with columns [actor, added_date, video_id, character_name, description, encoding, tags, title, user_id]. Processed: 81659 rows; Rate: 701 rows/s; Avg. rate: 1475 rows/s 81659 rows imported from 1 files in 55.377 seconds (0 skipped).
cqlsh:killrvideo> select count(*) from videos_by_actor ; count ------- 81574 (1 rows) Warnings : Aggregation query used without partition key Read 7489 live rows and 7489 tombstone cells for query SELECT * FROM killrvideo.videos_by_actor WHERE token(actor) >= token(Douglas Bristow) LIMIT 7489 (see tombstone_warn_threshold) Read 7489 live rows and 7489 tombstone cells for query SELECT * FROM killrvideo.videos_by_actor WHERE token(actor) >= token(Peter Jason) LIMIT 7489 (see tombstone_warn_threshold) Read 7489 live rows and 7489 tombstone cells for query SELECT * FROM killrvideo.videos_by_actor WHERE token(actor) >= token(Ingeborga Dapkūnaitė) LIMIT 7489 (see tombstone_warn_threshold) Read 7489 live rows and 7489 tombstone cells for query SELECT * FROM killrvideo.videos_by_actor WHERE token(actor) >= token(Christopher Stone) LIMIT 7489 (see tombstone_warn_threshold) Read 7489 live rows and 7489 tombstone cells for query SELECT * FROM killrvideo.videos_by_actor WHERE token(actor) >= token(Françoise Yip) LIMIT 7489 (see tombstone_warn_threshold) Read 7489 live rows and 7489 tombstone cells for query SELECT * FROM killrvideo.videos_by_actor WHERE token(actor) >= token(Emilio Estevez) LIMIT 7489 (see tombstone_warn_threshold) Read 7489 live rows and 7489 tombstone cells for query SELECT * FROM killrvideo.videos_by_actor WHERE token(actor) >= token(Alberto Viruena) LIMIT 7489 (see tombstone_warn_threshold) Read 7489 live rows and 7489 tombstone cells for query SELECT * FROM killrvideo.videos_by_actor WHERE token(actor) >= token(Peter Crook) LIMIT 7489 (see tombstone_warn_threshold) Read 7489 live rows and 7489 tombstone cells for query SELECT * FROM killrvideo.videos_by_actor WHERE token(actor) >= token(Aasif Mandvi) LIMIT 7489 (see tombstone_warn_threshold) Read 7489 live rows and 7489 tombstone cells for query SELECT * FROM killrvideo.videos_by_actor WHERE token(actor) >= token(Richard Jordan) LIMIT 7489 (see tombstone_warn_threshold) Read 6584 live rows and 6584 tombstone cells for query SELECT * FROM killrvideo.videos_by_actor WHERE token(actor) >= token(Maura Tierney) LIMIT 7489 (see tombstone_warn_threshold)
