sql - why when I execute a select query on a view in vertica, do I get "Length for type varchar cannot exceed 65000"? -

i have flextable in vertica , trying create view based on it.

here's create view statement:

create view testview     select             coalesce (                 "user_id",                 "userid",                 "sm.actor.id",                 "sm.participant.userid",                 "sm.userid",                 "sm.uid",                 "sm_c.userid",                 "sm.id" )::varchar userid             flex_table_test     "sm.verb" not null 

i can create view successfully, when execute like:

select * testview limit 10; 

i get:

error 3852: length type varchar cannot exceed 65000

if execute select part of view itself, works fine. tried casting output fields, doesn't seem make of difference.

by default, data in flex tables stored long varbinary has default raw size of 130000. since data longer maximum length varchar (65000), need either truncate result of coalesce or try casting ::long varchar. if latter works, aware vertica not support operations on content type.