Shard-Query 2.5 has been a long time coming, but the release is finally officially out the door.
There are numerous changes from the last major release including:
- Improved parser – fully handles complex expressions
- LOAD DATA INFILE support and S3 support
- Semi-join materialization for IN and NOT IN subqueries
- Improved support for subqueries in the FROM clause
- INSERT .. SELECT and CREATE TABLE .. SELECT support
- Ability to do range lookups on the shard key (IN/BETWEEN/etc)
- Improved proxy – supports SHOW commands too
- Support for all MySQL SELECT dialect including WITH ROLLUP
- Custom aggregate function support
- Asynchronous query support
- Numerous bug fixes
You can find it …
[Read more]