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