We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Error 3305 Vertica PARTITION BY Query — Vertica Forum

Error 3305 Vertica PARTITION BY Query

I encountered an error while running a UDTF with a PARTITION BY. 


The connection was created using RJDBC and JDBC sepparately. The query structure follows the format

"SELECT myUDF([columns] USING PARAMETERS [parameter list]) OVER(PARTITION BY [column]) FROM [table/subquery];"



([Vertica][VJDBC](3305) ERROR: Exception during Stats deserialization:invalid signature)
Calls:myfunction --> valueClassTest -> is -> is -> .local -> .verify.JDBC.result


The second line only appears when I used RJDBC since it's a query ran from within an R script.



Any help?



NOTE: THIS DOESN'T HAPPEN BY REMOVING PARTITION BY. ON OTHER PARTITION BY QUERIES IT HAS WORKED CORRECTLY.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file