Cannot disable index table #177
Description
This config
[common]
listen = ":9090"
max-cpu = 8
[clickhouse]
url = "http://192.168.1.1:8123/?readonly=2&database=data"
index-table = ""
data-timeout = "1m0s"
index-timeout = "1m0s"
tagged-table = ""
[[data-table]]
table = "metrics"
reverse = false
rollup-conf = "none"
rollup-default-precision = 60
rollup-default-function = "avg"
[logging]
file = "stdout"
level = "info"
gives an error when graphite-clickhouse tries to select from an empty string:
[2021-12-13T15:30:20.609Z] INFO [http] access {"request_id": "9978c7e58ff3bf4b3a85666200edb1f7", "time": 0.001986003, "method": "GET", "url": "/metrics/find/?local=1&format=pickle&query=scripts.dsp_scripts.rate_updater.%2A&from=1639409120&until=1639409420", "peer": "192.168.1.1:20498", "client": "", "status": 500}
[2021-12-13T15:30:20.616Z] ERROR [metrics-find] query {"request_id": "457e96cd203c42eb27f3e38b8821f864", "query": "SELECT Path FROM WHERE (Level=4) AND (Path LIKE 'scripts.dsp\\\\_scripts.reporter.%') GROUP BY Path FORMAT TabSeparatedRaw", "read_rows": "0", "read_bytes": "0", "written_rows": "0", "written_bytes": "0", "total_rows_to_read": "0", "error": "clickhouse response status 400: Code: 62. DB::Exception: Syntax error: failed at position 39 ('('): (Path LIKE 'scripts.dsp\\\\_scripts.reporter.%') GROUP BY Path FORMAT TabSeparatedRaw. Expected one of: UNION, LIMIT, SAMPLE, WHERE, WINDOW, INNER, end of query, HAVING, GROUP BY, INTO OUTFILE, EXCEPT, OFFSET, LEFT ARRAY JOIN, PREWHERE, JOIN, ORDER BY, array join, SETTINGS, ARRAY JOIN, INTERSECT, FORMAT, WITH, table, table function, subquery or list of joined tables, FINAL. (SYNTAX_ERROR) (version 21.11.4.14 (official build))\n", "time": 0.00144845}
What is the proper way to disable the index table?