Skip to main content

maptostring returns null for very large long varbinary

  • March 31, 2016
  • 1 reply
  • 7 views

knbny

I have a flex table with many different sizeslong varbinary items inserted ( 15 - 100,000 bytes). My problem is that I cannot apply maptostring on the very long ones - it is coming up null for the larger items in my table. I think the problem may be that they are longer than the max sized varchar. I have checked the actual text contained in these rows and they are showing 37000 characters of json strings as text, which would be greater than the maximum varchar. Any help would be appreciated.

1 reply

Gayatri_R
Forum|alt.badge.img
  • Participating Frequently
  • March 31, 2016

Hi

 

What version of Vertica are you running? I just tried this on 7.2.1 and it seems to work

 

select length(maptostring(__raw__)) from dc_requests_issued_raw where transaction_id = '58546795184345156';
 length
--------
  54397
(1 row)

 

select maptostring(__raw__) from dc_requests_issued_raw where transaction_id = '58546795184345156';

 

<output not shared>

 

Regards

Gayatri