0: jdbc:ignite:thin://127.0.0.1/> select * from cache1;
+--------------------------------+--------------------------------+--------------------------------+
|               ID               |              AGID              |              VAL               |
+--------------------------------+--------------------------------+--------------------------------+
| 1                              | 100                            | 10-15                          |
| 2                              | 100                            | 17-20                          |
| 3                              | 100                            | 30-50                          |
| 4                              | 101                            | 10-15                          |
| 5                              | 101                            | 17-20                          |
+--------------------------------+--------------------------------+--------------------------------+
5 rows selected (0.007 seconds)
0: jdbc:ignite:thin://127.0.0.1/> (select * from cache1 where agid = 100 limit 2) union (select * from cache1 where agid = 101 limit 2);
+--------------------------------+--------------------------------+--------------------------------+
|               ID               |              AGID              |              VAL               |
+--------------------------------+--------------------------------+--------------------------------+
| 4                              | 101                            | 10-15                          |
| 2                              | 100                            | 17-20                          |
| 5                              | 101                            | 17-20                          |
| 1                              | 100                            | 10-15                          |
+--------------------------------+--------------------------------+--------------------------------+
4 rows selected (0.005 seconds)