maptostring returns null for very large long varbinary

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.


  • 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';
    (1 row)


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


    <output not shared>






Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file