是否可以在同一集群中的两个不同的AWS Redshift数据库之间运行联接? [英] Is it possible to run a join between two different AWS Redshift Databases in the same cluster?
问题描述
只是想知道这是否可能?我看到一些较旧的链接指出,从2015年左右开始,这是不可能的,但是想知道是否现在,以及是否有任何可用文件指出是/否.谢谢!
just wondering if this is possible? I see some older links stating this is not possible from 2015 or so but wondering if it is now and if there is any available documentation that states yay/nay. Thanks!
推荐答案
不可能查询通过这与基于Amazon Redshift的PostgreSQL相同.请参阅:从两个单独的数据库中合并结果
This is the same for PostgreSQL, on which Amazon Redshift was based. See: Joining Results from Two Separate Databases
虽然PostgreSQL具有dlink
模块,该模块可以连接单独的数据库(在同一集群中或在其他集群上),但不对于Amazon Redshift不可用.
While PostgreSQL has the dlink
module that can join separate databases (on the same cluster or otherwise), this capability is not available for Amazon Redshift.
这篇关于是否可以在同一集群中的两个不同的AWS Redshift数据库之间运行联接?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!