I am discovering DSS and this is my test use case:
1- Connect to a single PostgresSQL table ( around 4 millions record)
2- Add a recipe to add a column (XYZ) and output the managed filesystem.
3-Create a pivot table to calculate an average of a mesure ( speed) ( 1 dimension( the new XYZ) - 5 possible values)
4- Get the answer based on the full dataset
So I build the recipe and then go to the dataset=>chart OR the analyse=> chart to design the pivot table. It works fine with the 10000 row sample but, when i ask for the full dataset sample ( DSS engine) . It throws an error 500 after 5 to 15 minutes.