The version of sqlparse released a few days ago seems to cause clickhouse-cli (0.3.8) to not start, giving a ValueErrror.
File "/home/jrolfe/.pyenv/versions/3.11.3/bin/clickhouse-cli", line 33, in <module>
sys.exit(load_entry_point('clickhouse-cli==0.3.8', 'console_scripts', 'clickhouse-cli')())
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/jrolfe/.pyenv/versions/3.11.3/lib/python3.11/site-packages/click/core.py", line 1130, in __call__
return self.main(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/jrolfe/.pyenv/versions/3.11.3/lib/python3.11/site-packages/click/core.py", line 1055, in main
rv = self.invoke(ctx)
^^^^^^^^^^^^^^^^
File "/home/jrolfe/.pyenv/versions/3.11.3/lib/python3.11/site-packages/click/core.py", line 1404, in invoke
return ctx.invoke(self.callback, **ctx.params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/jrolfe/.pyenv/versions/3.11.3/lib/python3.11/site-packages/click/core.py", line 760, in invoke
return __callback(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/jrolfe/.pyenv/versions/3.11.3/lib/python3.11/site-packages/clickhouse_cli/cli.py", line 580, in run_cli
cli.run(query, data_input)
File "/home/jrolfe/.pyenv/versions/3.11.3/lib/python3.11/site-packages/clickhouse_cli/cli.py", line 201, in run
if not self.connect():
^^^^^^^^^^^^^^
File "/home/jrolfe/.pyenv/versions/3.11.3/lib/python3.11/site-packages/clickhouse_cli/cli.py", line 114, in connect
response = self.client.query('SELECT version();', fmt='TabSeparated')
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/jrolfe/.pyenv/versions/3.11.3/lib/python3.11/site-packages/clickhouse_cli/clickhouse/client.py", line 156, in query
query = sqlparse.format(query, strip_comments=True).rstrip(';')
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/jrolfe/.pyenv/versions/3.11.3/lib/python3.11/site-packages/sqlparse/__init__.py", line 59, in format
return ''.join(stack.run(sql, encoding))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/jrolfe/.pyenv/versions/3.11.3/lib/python3.11/site-packages/sqlparse/engine/filter_stack.py", line 26, in run
stream = lexer.tokenize(sql, encoding)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/jrolfe/.pyenv/versions/3.11.3/lib/python3.11/site-packages/sqlparse/lexer.py", line 155, in tokenize
return Lexer.get_default_instance().get_tokens(sql, encoding)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/jrolfe/.pyenv/versions/3.11.3/lib/python3.11/site-packages/sqlparse/lexer.py", line 52, in get_default_instance
cls._default_intance.default_initialization()
File "/home/jrolfe/.pyenv/versions/3.11.3/lib/python3.11/site-packages/sqlparse/lexer.py", line 59, in default_initialization
self.set_SQL_REGEX(keywords.SQL_REGEX)
File "/home/jrolfe/.pyenv/versions/3.11.3/lib/python3.11/site-packages/sqlparse/lexer.py", line 78, in set_SQL_REGEX
self._SQL_REGEX = [
^
File "/home/jrolfe/.pyenv/versions/3.11.3/lib/python3.11/site-packages/sqlparse/lexer.py", line 80, in <listcomp>
for rx, tt in SQL_REGEX
^^^^^^
ValueError: too many values to unpack (expected 2)
The version of sqlparse released a few days ago seems to cause clickhouse-cli (0.3.8) to not start, giving a ValueErrror.
Full traceback:
Easily solved with a
pip install sqlparse==0.4.3, but probably deserves a proper fix.