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!

Concurrent queries on flex table from java giving strange error

I have a normal flex table with a __raw__ column. I am attempting a query that looks something like this:

 

SELECT MAPTOSTRING(__raw__)

FROM MY_TABLE

WHERE VERSION = (

SELECT MAX(CAST(VERSION AS FLOAT))

FROM MY_TABLE INNER_QUERY

)

AND TITLE = 'TITLE'

ORDER BY AUTHOR;

 

Version, Title and Author are all keys held in the JSON saved in the binary __raw__ column. This query runs fine when run from DbVisualizer or a standalone query from a tomcat server. My problem is that multiple REST calls making this query on different parameterized titles throw the VJDBC Error 3854 AKA:

 

[Vertica][VJDBC](3854) ERROR: Length of a string in a return type must be greater than zero

 

I cannot seem to find any useful information on this error nor can I determine the root cause of it. Can anyone help?

Comments

Leave a Comment

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