The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
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.
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.
0