To query data efficiently Redshift uses redshift spectrum for which an external schema needs to be created in hive using the following command.
create external schema hive_schema
from hive metastore database 'hive_db'
uri '172.10.10.10' port 99
iam_role 'arn:aws:iam::123456789012:role/MySpectrumRole'
How to get the uri and port of hive metastore?
Should i add any security groups?
Can someone guide me through the whole procedure?