En utilisant AWS re:Post, vous acceptez les AWS re:Post Conditions d’utilisation
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!

Sujets
Analytique
Balises
Amazon Redshift
Langue
English
mdrach
demandé il y a 2 ans1030 vues
1 réponse
-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
EXPERT
Jon Roberts
répondu il y a 2 ans
  • mdrach
    il y a 2 ans

    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)

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions

Contenus pertinents