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


#1

@arikfr

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.

Thanks
csv:
https://drive.google.com/a/twingo.co.il/file/d/0BxcDRiIDRZliUVBLQnRSeVJGd00/view?usp=sharing
screenshot:


#2

The reason is those rows contain angular brackets (<>), which cause the HTML sanitizer to break. This is a known issue, see: https://github.com/getredash/redash/issues/755

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)