pinax-network / substreams-sink-clickhouse

Substreams ClickHouse Sink
MIT License
3 stars 0 forks source link

fix blocks SQL #124

Closed DenisCarriere closed 8 months ago

DenisCarriere commented 8 months ago

Solves issue for:

""" /blocks (e.g. /blocks?chain=eos&module_hash=<...>) fails with this error Error: Syntax error: failed at position 370 ('BY') (line 12, col 84): BY (chain, module_hash) FORMAT JSONEachRow. Expected one of: token, Dot, OR, AND, IS NOT DISTINCT FROM, IS NULL, IS NOT NULL, BETWEEN, NOT BETWEEN, LIKE, ILIKE, NOT LIKE, NOT ILIKE, REGEXP, IN, NOT IN, GLOBAL IN, GLOBAL NOT IN, MOD, DIV, alias, AS, GROUP BY, WITH, HAVING, WINDOW, ORDER BY, LIMIT, OFFSET, FETCH, SETTINGS, UNION, EXCEPT, INTERSECT, INTO OUTFILE, FORMAT, end of query. """