amazon-redshift-utils icon indicating copy to clipboard operation
amazon-redshift-utils copied to clipboard

v_generate_tbl_ddl : Invalid operation: value too long for type character varying(798)

Open vare7 opened this issue 2 years ago • 1 comments

I am getting similar error. Error screenshot: https://i.imgur.com/CglvPh1.png

SQL Statement: select ddl from admin.v_generate_tbl_ddl where schemaname = 'schema_name_goes_here';

vare7 avatar Sep 01 '22 12:09 vare7

Hi, thanks for the report. That view is quite a big view, in that it joins together lots of information. This makes it harder to work out what is going on and which section is generating the error. Are you able to run each of the selects individually from the view definition? By this I mean the view is a UNION of lots of queries, if you are able to run each query individually that might help us track down which statement is causing the issue. Thank you

timjell avatar Sep 13 '22 01:09 timjell