Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

Highlighted

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

Explorer

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.

1 REPLY 1

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

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>';
Don't have an account?
Coming from Hortonworks? Activate your account here