Vertica DB: display bug - some columns' values are missing from query's output



Hi Arik,

Following our mail conversation:

I’m using Redash with Vertica DB. When running queries some values are missing from the display.

Attached csv output of my query and screenshot from Redash.



The reason is those rows contain angular brackets (<>), which cause the HTML sanitizer to break. This is a known issue, see:

One possible workaround is to replace the brackets with their HTML escape codes:

select '&lt;Hello&gt;' as test;

-- OR:

select replace(replace('<Hello>', '<', '&lt;'), '>', '&gt;') as test;

(you might need to change replace to a similar function your database supports)