---
name: netezza-watsonxdata_ki
title: Known issues
description: ''
last-updated: 2023-09-11
---

> ## Documentation Index
> The table of contents for this documentation set is at https://cloud.ibm.com/docs/netezza?format=markdown
> The index for all IBM Cloud docs is at: https://cloud.ibm.com/docs/llms.txt
> Use these files to discover more information as needed.

{:new_window: target="_blank"}
{:shortdesc: .shortdesc}
{:screen: .screen}
{:pre: .pre}
{:table: .aria-labeledby="caption"}
{:codeblock: .codeblock}
{:tip: .tip}
{:download: .download}
{:important: .important}
{:caption: .caption}
{:note: .note}

# Known issues
{: #watsonx.data_knownissues}

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](https://www.ibm.com/docs/en/netezza?topic=npsscr-alter-table-2).

    **Workaround**

    Refer [Dropping incompatible column types in ALTER TABLE](https://www.ibm.com/docs/en/watsonx/watsonxdata/1.1.x?topic=watsonxdata-known-issues-limitations#Knwnissulimit2__dl_yms_hfl_2bc)

- **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.