Search code examples
hiveamazon-redshiftcloudera-cdh

How to set up Hive metastore off Redshift

I couldn't find a way to set up a metastore off Redshift for Hive. I am wondering if there is anyone who has tried this. Also since Redshift supports PostgreSQL, maybe it is possible. Please share if you have any experience.

I am new to Hive and am using CDH5.4.

Solution

  • Redshift as DSS isn't suitable to store Hive meta store by definition. Use RDS service for that purpose.