Support Questions

Find answers, ask questions, and share your expertise

How to drop table in cluster 2 for which location is in cluster 1


Hey all, i created a table in cluster 2, where the create table statement had the location in another cluster (i was stupid in not realizing this). So now how do I drop the table in cluster 2 without the table getting affected in cluster 1?

Or is there anyway to modify the location so i can point it to cluster 2?

So when i tried to drop the table it says that it is expecting the location to be in cluster 2.

Appreciate the feedback.


Master Collaborator

You can do the following to change the location of data for the table:

ALTER TABLE <table_name> SET location '<location_in_cluster_2>';
Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.