MultiColumnFold processor Using SQL in DSS flow
dakakiran
Dataiku DSS & SQL, Dataiku DSS Core Concepts, Registered Posts: 3 ✭✭✭✭
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
Answers
-
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.