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

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