Map Storage Type and Window Visual Recipies

Options
tgb417
tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,595 Neuron

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.

Tagged:

Best Answer

  • Zach
    Zach Dataiker, Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered Posts: 153 Dataiker
    Answer ✓
    Options

    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

Answers

  • tgb417
    tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,595 Neuron
    Options

    @ZachM

    Thanks for the insights and work around.

Setup Info
    Tags
      Help me…