将 UNPIVOT 从 SQL Server 转换为 Redshift

Question

我有一个来自SQL Server的脚本，我需要将其转换为Redshift

这是脚本的一部分，我遇到了麻烦

UNPIVOT
(
SeatCharge
FOR Description IN (
PM_Core,
PM_RCM,
PM_Advanced_RCM,
PM_Payroll,
PM_DXM,
PM_Messaging,
PM_Tasks,
Clinical_Core,
Clinical_Data_Collection,
Clinical_Auditing_Tools,
Clinical_Group_Sessions,
Clinical_ABC_Data,
Clinical_AGA,
LMS_Core,
HRIS_PTO,
LMS_Course_Groups,
PM_Reach_Me,
PM_Redshift,
HRIS_Benefits,
HRIS_Assets)
)u

如何正确将其转换为红移？

Answer 1

您可以尝试使用union all在亚马逊红移中进行UNPIVOT

SELECT  PM_Core SeatCharge
FROM yourTable
union all
SELECT PM_RCM 
FROM yourTable
union all
SELECT PM_Advanced_RCM 
FROM yourTable
union all 
SELECT PM_Payroll 
FROM yourTable
union all 
SELECT PM_DXM 
FROM yourTable
....

注意

当您这样做时UNPIVOT需要确保UNPIVOT列数据类型相同。