Skip to main content

Error 3305 Vertica PARTITION BY Query

  • May 24, 2014
  • 0 replies
  • 4 views

Said_Montiel
Forum|alt.badge.img+1
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.