Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
What if i drop all the projections on a table
Hi All, Maybe a naive question. What if I drop all the projections (including the super projections) on a table ? Would I be losing data ? On a side note how do I identify if a projection is a super projection from the entries in the projections table. The reason I ask all this is while trying the function move_partitions_to_table I get the error that some of the projections are unsegmented. On checking the schema, all the super projections (covering all the columns) seem to be having the unsegmented option (Most of them are confined to a single node , just one is using all nodes which implies replication). I want to delete those unsegmented projections and create them with the segmented option, however I fear that I might be deleting some data permanently. Thanks, Ravi.