Group By: Interval

Gridsql seems to have an issue when grouping by a interval on a partitioned table;

SQL

Replicated tables do aggregate correctly however.

SQL

Thanks for looking into this.

-Jon

O/P of replicated table

GridSQL -> execute direct on all 'select age(payment_date), count(*) from test GROUP BY 1;'
+-------------------------------+
| age | count | Node |
+-------------------------------+
| 2 mons 27 days | 4 | 1 |
| 2 mons 27 days | 4 | 2 |
| 2 mons 27 days | 4 | 3 |
| 2 mons 27 days | 4 | 4 |
+-------------------------------+

O/P of partitioning table

GridSQL -> execute direct on all 'select age(payment_date), count(*) from test GROUP BY 1;'
+-------------------------------+
| age | count | Node |
+-------------------------------+
| 2 mons 27 days | 2 | 1 |
| 2 mons 27 days | 1 | 2 |
| 2 mons 27 days | 1 | 4 |
+-------------------------------+
3 row(s).

Replicated tables appear on all nodes, with each node containing the exact same data, while in
case of parititioning table data not appear on all nodes.

May be mason/andrei will shade more lights on this.

--
Thanks
Sam

Hi Jon,

This is a bug with the interval data type, thanks for reporting it.
We are working on the fix, it will be available soon.
As a temporary workaround you may try and typecast the result of age() function:

Thanks
Andrei

Hi Jon,

The bug has been fixed and fix is checked in to the CVS.

Andrei