I created a 3 NC cluster on a single machine, using the attached cluster configuration (local3.xml) and instance configuration (asterix-configuration.xml). The CSV files for the datasets are attached. Then I ran the following query.
The query fails with the following exception:
It seems the issue is related to the "distinct by". I have tried the following query also and it works:
But I have no clue why "distinct by" is related to the resource ID.
Also, the original query works when I only have two NCs.