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


Concurrent queries on flex table from java giving strange error — Vertica Forum

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