Skip to content

Instantly share code, notes, and snippets.

@stockholmux

stockholmux/aggregate.redisearch Secret

Last active May 30, 2018 15:00
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save stockholmux/acf93cd407bae01e6048c66cdbe1e694 to your computer and use it in GitHub Desktop.
Save stockholmux/acf93cd407bae01e6048c66cdbe1e694 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
aggregate.redisearch
FT.AGGREGATE shipments "@box_area:[300 +inf]"
APPLY "year(@shipment_timestamp / 1000)" AS shipment_year
GROUPBY 1 @shipment_year REDUCE COUNT 0 AS shipment_count
SORTBY 2 @shipment_count DESC
LIMIT 0 3
APPLY "format(\"%sk+ Shipments\",floor(@shipment_count / 1000))" AS shipment_count
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment