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.

Connecting the cluster to Amazon Redshift for creating external schemas in hive

Highlighted

Connecting the cluster to Amazon Redshift for creating external schemas in hive

Explorer

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?

Don't have an account?
Coming from Hortonworks? Activate your account here