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?
What is ERROR 5238: Unrecognized node type?
This might just be from trying to use a column that DNE.
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.
What syntax was used that caused this?
A window range definition 'interval '5' preceding' was ''5'::interval PRECEDING'. Any word on what the error means?
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
I also tried interval '7 DAYS' precedingtry:
INTERVAL '7 day' DAYor 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 ;http://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/SQLReferenceManual/DataTypes/Date-Time/Spe...
?column?
----------
168
(1 row)
we found out this is a bug and the fix will be included in 7.1SP2. The # is VER-36682
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
