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?
