This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Working today found a issue where if you group by the same field twice it gives an incorrect result, replicated this with a simple example below. I also tried it on an older version (2021.4.2) and it does not happen there.
WHen goruping by one field, works as expected
When grouping by the same field twice, gives wrong result:
I think that it really do not have any application. But it looks like a bug indeed, sometimes we must summarize grouping a bunch of columns, someone somewhere could put the same column by mistake on the group by and have crazy outputs. 😥
Please do not take this one example as a reason to "disable AMP as much as possible" - with the 2022.1 Release we made AMP the default for new workflows and in most cases it should work fine. The AMP Summarize tool was enhanced with the upcoming 2022.3 Release to handle additional Actions as well as handle this scenario of grouping on duplicate fields. When I run your workflow in a 2022.3 build I no longer get errors with AMP. Both original engine and AMP behave the same now for this scenario.
We have worked hard to identify and address various issues with prior releases since AMP was made available with the 2020.2 GA Release.
Users should consider AMP production ready with some minor remaining issues starting with the 2021.4 Release.
The 2022.3 GA Release will also include 86 more AMP tools (including R and Reporting tools) as well as additional Connector tools which are AMP native.
There will also be an Engines Parity tool available from Gallery to enable bulk comparison by pointing to a folder containing multiple workflows. The workflows will run with original Engine and AMP and provide an output report on whether results match and identify where differences exist if they do not match. This will help users decide which existing workflows can confidently be converted from original Engine to AMP.
Here is some additional information related to AMP that users might find helpful.