Re: Restore a table with dropped columns to a new cluster fails

2020-07-24 Thread Mitch Gitman
er@cassandra.apache.org > *Subject:* [EXTERNAL] Re: Restore a table with dropped columns to a new > cluster fails > > > > I'm reviving this thread because I'm looking for a non-hacky way to > migrate data from one cluster to another using nodetool snapshot and > ssta

RE: Restore a table with dropped columns to a new cluster fails

2020-07-24 Thread Durity, Sean R
: user@cassandra.apache.org Subject: [EXTERNAL] Re: Restore a table with dropped columns to a new cluster fails I'm reviving this thread because I'm looking for a non-hacky way to migrate data from one cluster to another using nodetool snapshot and sstableloader without having to preser

Re: Restore a table with dropped columns to a new cluster fails

2020-07-24 Thread Mitch Gitman
I'm reviving this thread because I'm looking for a non-hacky way to migrate data from one cluster to another using nodetool snapshot and sstableloader without having to preserve dropped columns in the new schema. In my view, that's just cruft and confusion that keeps building. The best idea I can

Re: Restore a table with dropped columns to a new cluster fails

2019-02-19 Thread Jeff Jirsa
You can also manually add the dropped column to the appropriate table to eliminate the issue. Has to be done by a human, a new cluster would have no way of learning about a dropped column, and the missing metadata cannot be inferred. On Tue, Feb 19, 2019 at 10:58 AM Elliott Sims wrote: > When a

Re: Restore a table with dropped columns to a new cluster fails

2019-02-19 Thread Elliott Sims
When a snapshot is taken, it includes a "schema.cql" file. That should be sufficient to restore whatever you need to restore. I'd argue that neither automatically resurrecting a dropped table nor silently failing to restore it is a good behavior, so it's not unreasonable to have the user re-creat