let's assume i have a managed and external table in s3, i am using RDS for storing my metadata , i have a EC2 instance and i am running a query
my questions are:
1 .The EC2 instance will have a master node and some core nodes say 3 core nodes.The master node should have the meta data right?.so how it will get the metadata from RDS and what will happen to the changes that i made in metadat if i lost the cluster?
2. The data is stored in s3 , so if i am working with managed table the data should be on any one of the core node right? then based on what parameter master node will decide which core node to assign the task