Known issues

You might experience the following issues while using watsonx.data with NPSaaS:

• You may see the following error when dropping columns using an alter statement.

  The following columns have types incompatible with the existing columns in their respective positions : COL3

  For more information, see ALTER TABLE.

  Workaround

  Refer Dropping incompatible column types in ALTER TABLE

• INSERT is only supported for unpartitioned tables. You will not be able to insert into partitioned iceberg tables created by other engines.

• CTAS (CREATE TABLE AS SELECT) within a single SQL statement is not supported when the target table is an iceberg table.

  Workaround

  Create the table and do the insert in separate SQL statements.