Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.