I’ve never been a big fan of the “COPY” statement.
My preference for stuff like this (though I am definitely in the minority I
think!) — particularly for the amount of data you’re talking about — is to use
the open source tool “cassandradump” — which is similar to mysqldump but for
cassandra.
Hi Alain,
That is exactly what I did yesterday in the end. I ran the selects and
output the results to a file, I ran some greps on that file to leave myself
with just the data rows removing any white space and headers.
I then copied this data into a notepad on my local machine and saved it as
a c
> Does anyone have any ideas of what I can do to generate inserts based on
> primary key numbers in an excel spreadsheet?
A quick thought:
What about using a column of the spreadsheet to actually store the SELECT
result and generate the INSERT statement (and I would probably do the
DELETE too) c
Hi All,
I have a problem that I'm trying to work out and can't find anything online
that may help me.
I have been asked to delete 4K records from a Column Family that has a
total of 1.8 million rows. I have been given an excel spreadsheet with a
list of the 4K PRIMARY KEY numbers to be deleted.
