What is ERROR 5238: Unrecognized node type?

Frank_Columnist

What does "ERROR 5238: Unrecognized node type" (followed by a 3 digit code) mean?

A query that appears well formed fails with this error on Vertica 7.0.x, but Class 52 does not appear in the 7.0.x Documentation's SQL State List.

The meaning of node type is clear enough, but under what circumstances would a node type not be recognized?  Is this most likely a bug, a problem with the cluster, a SQL problem, or something else?

Frank_Columnist

This might just be from trying to use a column that DNE.

Frank_Columnist

Indeed, looks like this error resulted from a syntax error in the SQL.  Still not sure what the error code exactly means--that would still be great to find out.

Raul_1

What syntax was used that caused this?

Frank_Columnist

A window range definition 'interval '5' preceding' was ''5'::interval PRECEDING'.  Any word on what the error means?

Gabriel_Gejman

I'm having the same issue. The query works when I use interval '7' preceding but when I put that in a view Vertica changes it to interval '7'::interval preceding and that doesn't work with the same error. Any idea? I also tried interval '7 DAYS' preceding but when creating the view it changes to '7'::interval

id10t

I also tried interval '7 DAYS' preceding

try:

INTERVAL '7 day' DAY

or full format

INTERVAL '7d 0h 0m 0s'

Only 2 interval data type exists: year to month & day to seconds, all others are their subtypes. So a second example isn't require a qualifer, for example you can cast it:

daniel=> select interval '7d 0h 0m 0s' hour ;
 ?column? 
----------
 168
(1 row)

http://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/SQLReferenceManual/DataTypes/Date-Time/Spe...

Gabriel_Gejman

we found out this is a bug and the fix will be included in 7.1SP2. The # is VER-36682