CREATE TABLE failed because column exceeds the maximum of 1024 columns

KNIME Analytics Platform
1

Hello Community,
DB writer node has the following error: CREATE TABLE failed because column exceeds the maximum of 1024 columns.
This is SQL Server Maximum Columns limit (1024) and the table I am about to create is pivot-table (therefore so many columns). The solution in KNIME (pivoting) seems to be very easy beacuse of Pivot node, but the problem is writing the data back in Database.
Any ideas how the problem can be solved?
Thanks in advance.

1 Like
2

Hi @volsebna ,
from my understanding the problem lays not on the KNIME nodes’ side but rather on the restriction of the SQL Server.

Quick search tells me that having so many columns in a database might be not a best practice. Could you try to redesign the database structure after pivoting or avoid pivoting it in the first place? Or elaborate what do you try to achieve with pivoting? Then, maybe we could find a solution on how achieve what you want with KNIME Analytics Platform.

Best,
Daria

1 Like