Board 12.6.0.1 : The JOIN function is not supported anymore

Julien CARDON
Julien CARDON Customer
Fourth Anniversary 100 Comments 25 Likes Level 100: Foundations of Building in Board
edited August 2023 in Platform

Hello,

In Patch 12.6.0.1, as per the release notes :

Dataflow : The JOIN function is not supported anymore and should not be used in the Dataflow configurations

⇒ Could you please explain if there is a change in the code related to JOIN() function : All dataflow with join() will now fail ? or it is for information purposes only ?

I'm in v12.6, and I would like to know if my dataflow using JOIN() will work as expected in v12.6.0.1

regards,

julien

Answers

  • Krisztina Zappert
    Krisztina Zappert Active Partner
    Second Anniversary 25 Likes 25 Up Votes 10 Comments

    I have a follow-up question - I only know of a JOIN funciton in the data readers, where can I find this JOIN in dataflows?

  • Julien CARDON
    Julien CARDON Customer
    Fourth Anniversary 100 Comments 25 Likes Level 100: Foundations of Building in Board

    yes, it's not documented but known by board consultants when using Board 10.

    I think a lot of DEVs are still using this function

    My question now how to check quickly on each DB + Capsule which procedure has JOIN() dataflow

  • Samson Sunny
    Samson Sunny Employee, Community Captain
    25 Answers 100 Comments Third Anniversary 25 Likes

    Hi Julien & Krisztina,

    Yes the JOIN syntax has been used since B10 but has been deprecated since the adoption of Board 12. They most likely won't work from the new 12.6 patch. Use the normal multiplication with the extend calculation as they offer better performance.

    Thanks,

    Samson.

  • Andrea Contaldo
    Andrea Contaldo Employee
    Fourth Anniversary Level 100: Foundations of Building in Board 5 Likes Name Dropper

    Hi Julien & Krisztina,

    Thanks for your feedback.

    In 12.6 main release it was indeed found as an issue causing dataflows containing JOIN syntax to fail. This issue has been fixed in the 12.6.0.1 patch release.

    As my colleague Samson mentioned the usage of JOIN syntax is not required anymore since the adoption of Board 12. From B12 we do not require customers and consultants to know these complex syntaxes and setups , it is instead Board itself to choose the most appropriate dataflow algorithm based on cubes dimensions/dataflow configuration.

    This means that, if the conditions for a JOIN algorithm are in place, Board will automatically run the dataflow in JOIN without the need for you to specify the syntax. On the contrary , if there is a better algorithm to execute that dataflow Board will choose that one.

    Up until 12.6 the JOIN syntax was anyway still forcing the dataflow in JOIN mode, even if this was not the most efficient algorithm to use.

    With this patch release , if present in the dataflow formula, the JOIN syntax will be ignored and Board will run the dataflow with the most appropriate algorithm. So no need for adjusting all the dataflows in your application if you upgrade to this patch.

    Following your comments we will change the release notes to make this more explicit.

    Andrea

  • Federico Cazzalini
    Federico Cazzalini Employee
    Fourth Anniversary 5 Answers 25 Up Votes 10 Comments
    https://community.board.com/discussion/comment/15239#Comment_15239

    Thanks @Andrea C.

    it is absolutely important to keep in mind - as you said - that from B12 we do not require customers and consultants to know these complex syntaxes and setups , it is instead Board itself to choose the most appropriate dataflow algorithm based on cubes dimensions/dataflow configuration.

    but I would like to highlight this important part:
    In 12.6.0.0.85662 main release it was indeed found as an issue causing dataflows containing JOIN syntax (explicit formula JOIN() written in the dataflow) to fail.

    This issue has been fixed in the 12.6.0.1.87034 patch release.

    ciao!
    federico

Categories