New to Dataiku DSS? Try out our NEW Quick Start Programs today and get onboarded on the product in just one hour! Let's go

MultiColumnFold processor Using SQL in DSS flow

dakakiran
Level 1
MultiColumnFold processor Using SQL in DSS flow

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
0 Kudos
1 Reply
Clément_Stenac
Dataiker
Dataiker

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.

0 Kudos
A banner prompting to get Dataiku DSS