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!
Hi,
we are currently migrating some external tables into a new database and rely on the admin view
v_generate_external_tbl_ddlto 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