从MS Access迁移到Redshift

Question

我想将现有表格移至Amazon Redshift。以下是我在Access中的查询

SELECT [Top NAD Issues by Month Link].[COF Item Number] 
    ,Nz([a.supplier], "NO COF INFO") AS Supplier 
    ,Nz([a.subsystem], "NO COF INFO") AS Subsystem 
    ,[Top NAD Issues by Month Link].[Business Unit Info] 
INTO [Top NAD Issues by Month] 
FROM (
    SELECT [COF Reference].[COF Item Number] 
     ,[COF Reference].Supplier 
     ,[COF Reference].Subsystem 
     ,[COF Reference].[Project Group] 
     ,[COF Reference].Project 
     ,Count([COF Reference].[Claim Number]) AS [CountOfClaim Number] 
    FROM [COF Reference] 
    GROUP BY [COF Reference].[COF Item Number] 
     ,[COF Reference].Supplier 
     ,[COF Reference].Subsystem 
     ,[COF Reference].[Project Group] 
     ,[COF Reference].Project 
    ORDER BY [COF Reference].[COF Item Number] 
    ) a 
RIGHT JOIN [Top NAD Issues by Month Link] ON a.[COF Item Number] = [Top NAD Issues by Month Link].[COF Item Number]; 

什么是Redhisft中的等效查询？

感谢

Answer 1

由于亚马逊红移使用标准的SQL，您可以使用红移相同的查询，显示查询并没有什么特别的（只要你之前已经迁移之前的表[COF参考]和[按月链接排名前NAD问题]