pirsch-analytics / pirsch

Pirsch is a drop-in, server-side, no-cookie, and privacy-focused analytics solution for Go.
https://pirsch.io
GNU Affero General Public License v3.0
928 stars 43 forks source link

v3.7 is_bot query #253

Closed Kugelschieber closed 2 years ago

Kugelschieber commented 2 years ago
[ERROR] Error reading average session duration   err=code: 62, message: Syntax error: failed at position 963 ('is_bot') (line 14, col 358): is_bot < 5 
                        AND duration_seconds != 0
                        GROUP BY day
                        HAVING sum(sign) > 0
                        ORDER BY day
                        WITH FILL FROM toDate(toDateTime('2022-03-02 00:00:00', 'UTC. Expected one of: UNION, LIMIT, WINDOW, DoubleColon, LIKE, GLOBAL NOT IN, HAVING, AS, DIV, IS, UUID, GROUP BY, OR, EXCEPT, QuestionMark, OFFSET, BETWEEN, NOT LIKE, MOD, AND, alias, ORDER BY, SETTINGS, IN, ILIKE, INTERSECT, Dot, NOT ILIKE, WITH, NOT, token, NOT IN, GLOBAL IN domain_id=142