MultiColumnFold processor Using SQL in DSS flow

dakakiran

Hi Everyone,

When i am trying to fold multiple columns through "fold multiple columns" processor its througing error as below :

In-database (SQL)
Not supported settings for 'MultiColumnFold' processor: Not translatable to SQL

Is there any workaround ?? or any other Processor to be used ??

Regards

Kiran

Clément_Stenac

Hi,

Only a subset of processors can be used in-database (see https://doc.dataiku.com/dss/latest/preparation/engines.html#details-on-the-in-database-sql-engine for details).

Reshaping processors, and notably the "fold multiple columns" cannot be used in-database. You will need to revert to the "DSS / Local stream" engine for this particular recipe.

While the local stream engine is slower when running on SQL databases, it can execute all processors, which the "in-database" engine cannot do.