RedShift-不支持的枢轴列类型：文本

发布于 2025-02-13 23:17:58 字数 1024 浏览 3 评论 0原文

我看了这个主题：错误：错误：不支持的Pivot列类型：文本但是不幸的是，这并没有为我提供答案。

我有一个简单的表，看起来如下：

user_id | type | reminder_type | sent_at
----------------------------------------------------
user_a  | MID  | REMINDER_1    | 2022-02-01 15:00:00
user_a  | MID  | REMINDER_2    | 2022-02-15 06:00:00

然后我尝试执行此查询：

SELECT
  *
FROM table
PIVOT (
  MIN(sent_at) FOR reminder_type IN('REMINDER_1', 'REMINDER_2')
)

为了获得以下结果：

user_id | type | reminder_1          | reminder_2
----------------------------------------------------------
user_a  | MID  | 2022-02-01 15:00:00 | 2022-02-15 06:00:00

它给我上述错误：

无法缠绕我的头，AWS文档没有提供有关错误的任何详细信息

原文

I had a look at this topic: ERROR: Unsupported PIVOT column type: text but unfortunately it didn't provide me with an answer.

I have a simple table that looks like the following:

user_id | type | reminder_type | sent_at
----------------------------------------------------
user_a  | MID  | REMINDER_1    | 2022-02-01 15:00:00
user_a  | MID  | REMINDER_2    | 2022-02-15 06:00:00

Then I try to perform this query:

SELECT
  *
FROM table
PIVOT (
  MIN(sent_at) FOR reminder_type IN('REMINDER_1', 'REMINDER_2')
)

In order to get the following result:

user_id | type | reminder_1          | reminder_2
----------------------------------------------------------
user_a  | MID  | 2022-02-01 15:00:00 | 2022-02-15 06:00:00

And it gives me the aforementioned error: