Bug in prepare recipe with compute time difference

Options
Ioannis
Ioannis Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 28 ✭✭✭✭✭

While using the time difference from prepare recipe I get this weird error. All values on preview seem right but when I run the recipe I get a const value.

Untitled.png


Operating system used: Windows

Tagged:

Answers

  • Alexandru
    Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,209 Dataiker
    Options

    Hi @imanousar
    ,
    Can you confirm the engine you are running the recipe with? Do you get the expected results if you use the DSS engine?


    Thanks,

  • Ioannis
    Ioannis Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 28 ✭✭✭✭✭
    Options

    I'm using SQL in Database since this our fastest engine in our case.

  • Alexandru
    Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,209 Dataiker
    Options

    Which SQL database are you using exactly? Can you confirm if the DSS engine has the expected results? It would be best if you can raise support with the job diagnostics so we can look further into this.

  • Ioannis
    Ioannis Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 28 ✭✭✭✭✭
    Options

    DSS engine is ok. I'm using Snowflake.

  • Ioannis
    Ioannis Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 28 ✭✭✭✭✭
    Options

    The same happens with other stuff in prepare recipes like using formulas, dss engine gives the correct resutl. In SQL database engine shows in preview the correct result and the output is wrong.

Setup Info
    Tags
      Help me…