Durch die Nutzung von AWS re:Post stimmt du den AWS re:Post Nutzungsbedingungen
AWS re:Postre:Post

Amazon PIVOT bug? "column does not exist"

0

I'm trying to use the Amazon PIVOT feature and am encountering what appears to be a bug. See minimal query and output below:

> WITH t1 AS (select 1 as a) select 1 from t1 PIVOT (sum(a) for a in (1)) WHERE ('NaN'::FLOAT = 0);
ERROR:  Query unsupported due to an internal error.
DETAIL:  SQL reparse error.
CONTEXT:  column "nan" does not exist in unnamed_pivot1.

The literals in the where clause don't have anything to do with the pivot, so the error message does not seem accurate. Is this indeed a bug? Please let me know if I can provide any further information. Thanks!

Themen
Analysen
Tags
Amazon Redshift
Sprache
English
mdrach
gefragt vor 2 Jahren1030 Aufrufe
1 Antwort
-1

The literal in the where clause is the problem. The query can't be parsed because there isn't a column named "nan".

Are you trying to check for null with "nan"?

profile pictureAWS
EXPERTE
Jon Roberts
beantwortet vor 2 Jahren
  • mdrach
    vor 2 Jahren

    Sorry, not sure I understand your question. Here's a query that gives the output that I expect. The WHERE clause has nothing to do with the rest of the query in the OP or in this example.

    WITH t1 AS (select 1 as a) select 1 from t1 PIVOT (sum(a) for a in (1)) WHERE ('hello' = 'world');
 ?column?
----------
(0 rows)

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen

Relevanter Inhalt