Discover all of the brand-new features and improvements to existing capabilities in the Dataiku 11.3 updateLET'S GO

Map Storage Type and Window Visual Recipies

Solved!
tgb417
Map Storage Type and Window Visual Recipies

I've been working with standard local CSV files as datasets rather than database-connected data sets recently.  In doing this I've run into a problem with the window recipe.  On simple data types I can "retreive" a column.  However, for the “map” data type the button to retrieve the column that is of type map is grayed out.

anyone know why this is?  Is there a work around?

Image: Window recipe grayed out [retrieve] button for just the variable to type Java map.Image: Window recipe grayed out [retrieve] button for just the variable to type Java map.

 

 

--Tom
0 Kudos
1 Solution
ZachM
Dataiker

Hi @tgb417,

I was able to reproduce this issue on my end using DSS 11.0.1. It appears to be a limitation of visual-recipe aggregations. They only support basic types (string, int, double, boolean, date).
You can work around the issue by manually setting the type of the affected column to "string" in a Prepare recipe before the Window recipe:
E32D8601-5640-4FA7-B2C0-B565C892D32C_1_105_c.jpeg

 

 
I also logged this as a feature request on your behalf for further review and consideration by our product team.
 
Thanks,
Zach

View solution in original post

2 Replies
ZachM
Dataiker

Hi @tgb417,

I was able to reproduce this issue on my end using DSS 11.0.1. It appears to be a limitation of visual-recipe aggregations. They only support basic types (string, int, double, boolean, date).
You can work around the issue by manually setting the type of the affected column to "string" in a Prepare recipe before the Window recipe:
E32D8601-5640-4FA7-B2C0-B565C892D32C_1_105_c.jpeg

 

 
I also logged this as a feature request on your behalf for further review and consideration by our product team.
 
Thanks,
Zach
tgb417
Author

@ZachM 

Thanks for the insights and work around.

 

--Tom