Announcing the winners & finalists of the Dataiku Frontrunner Awards 2021! Read their inspiring stories

FilterOnDateRange to SQL

Solved!
davidmakovoz
Level 4
FilterOnDateRange to SQL

I'm running a FilterOnDateRange preprocessing step and getting the following message:

Not supported settings for 'FilterOnDateRange' processor: Not translatable to SQL

I'm just curious, why isn't it translatable to sequel?

I can definitely use a where condition 

where column_name > date1 and column_name < date2

What am I missing?

0 Kudos
1 Solution
davidmakovoz
Level 4
Author

Btw, I figured out a work-around this problem.

I added a column with the number of days from the original date column till 'now', which can be done in-database. And then just applied the date range condition in terms of the number of days. 

View solution in original post

0 Kudos
3 Replies
Clément_Stenac
Dataiker
Dataiker

Hi,

Only a small subset of processors can be automatically translated to SQL by DSS. Translation for this particular processor is not currently implemented, so if you use this processor, the processing will happen locally instead of fully-in-database.

We are regularly adding new processors and will make sure to take your request into account.

0 Kudos
davidmakovoz
Level 4
Author

I understand that it's not available. I was just a bit surprised that it wasn't implemented, seems like a pretty straightforward mapping from the filter to the SQL command, unless I'm missing something.

0 Kudos
davidmakovoz
Level 4
Author

Btw, I figured out a work-around this problem.

I added a column with the number of days from the original date column till 'now', which can be done in-database. And then just applied the date range condition in terms of the number of days. 

View solution in original post

0 Kudos
Labels (2)
A banner prompting to get Dataiku DSS