yahel
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:
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 '<Hello>' as test;
-- OR:
select replace(replace('<Hello>', '<', '<'), '>', '>') as test;
(you might need to change replace
to a similar function your database supports)