Вступление никому не интересно, поэтому начну сразу с примеров использования


![json-pipe-sql][1]
% cat log.json
{"type": "hit", "client": {"ip": "127.1.2.3"}}
{"type": "hit", "client": {"ip": "127.2.3.4"}}
{"type": "hit", "client": {"ip": "127.3.4.5"}}
{"type": "hit", "client": {"ip": "127.3.4.5"}}
{"type": "hit", "client": {"ip": "127.1.2.3"}}
{"type": "click", "client": {"ip": "127.1.2.3"}}
{"type": "click", "client": {"ip": "127.2.3.4"}}

Выполняем запрос:


% cat log.json | jl-sql 'SELECT client.ip, COUNT(*) AS count WHERE type = "hit" GROUP BY client.ip'
{"client":{"ip":"127.1.2.3"},"count":2}
{"client":{"ip":"127.2.3.4"},"count":1}
{"client":{"ip":"127.3.4.5"},"count":2} [Читать дальше →][2]

[1]: https://habrastorage.org/files/6fb/fc4/506/6fbfc450605a4350bfce24d2ddb54b42.png
[2]: https://habrahabr.ru/post/319722/?utm_source=habrahabr&utm_medium=rss&utm_campaign=feed_posts#habracut