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
Same problem here. Any updates on this?
Got the Same Issue? Any update please.
This problem has been fixed as of 7.2.3-4. There used to be a problem with concurrent accesses to a map when querying virtual columns.
See note for VER-47352 at:
https://my.vertica.com/docs/ReleaseNotes/7.2.x/Vertica_7.2.x_Release_Notes.htm#7.2.3-4