v_generate_external_tbl_ddl generates invalid ddl

Hi,

we are currently migrating some external tables into a new database and rely on the admin view `v_generate_external_tbl_ddl` to reconstruct the DDL. However, in some cases it seems that the view generates faulty SQL statements. We do not know when this happens but it might be related to complex data types like arrays / structs.

Here is an example:

In each case we found it seems to be that at least the data type & the closing brackets are missing.
Help would be appreciated!

kind regards
Maik

Start by inspecting the admin view v_generate_external_tbl_ddl and reproduce the report with external tables that use complex types such as arrays or structs. Compare its generated statements with valid DDL, focusing on missing data types and closing brackets. Done means the view consistently emits executable DDL for the affected cases.

Written by the indexing model from the issue text.