Functions, count conditions & more
Lots of new features:
- Long awaited function support! You can now use a slew of functions anywhere that an expression is accepted.
concat
,contains
,parseDate
, andsubstring
are useful for strings. Most math functions you can think of are there as well. (Huge thanks to @tstack) - Bug fix from v.014.0, division will now promote both values to floats (previous code used integer division in some cases).
round
can be used to get back the old behavior. (@rcoh) - Sort now accepts arbitrary expressions, eg.
sort by length(message)
. This is part of a larger effort to accept expressions anywhere that currently accepts a column name. One of the few remaining holdouts is thefields
operator. (@rcoh) count
now supports an optional argument to conditionally count certain records: (@rcoh)
* | json | count(status == 200) as ok, count as all | ok / all as success_ratio
The build is running now & 0.15.0 has been pushed to crates.io -- binaries should be hot off the presses shortly.