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.
You can do the following to change the location of data for the table:
ALTER TABLE <table_name> SET location '<location_in_cluster_2>';