Support of ClickHouse server version 18.12.17 revision 54407 about clickhouse-sqlalchemy

[xzkostyan]

Hi.

You can try execute simple statement from clickhouse-driver

from clickhouse_driver import Client
c = Client('host', port=port)
c.execute('select 1')

It worked for me with server version 18.12.17.

Can you provide stacktrace after testing connectivity?

[Matt-Texier]

log server side:

2018.09.21 10:19:37.689855 [ 732 ] <Trace> TCPHandlerFactory: TCP Request. Address: [::ffff:XX.XXX.XXX.XXX]:55840
2018.09.21 10:19:37.690133 [ 732 ] <Debug> TCPHandler: Connected ClickHouse python-driver version 1.1.0, revision: 54337, database: default, user: default.
2018.09.21 10:19:37.710842 [ 732 ] {78b5422b-2398-47de-a786-19a3d7bc0e7a} <Debug> executeQuery: (from [::ffff:XX.XXX.XXX.XXX]:55840) select 1
2018.09.21 10:19:37.711277 [ 732 ] {78b5422b-2398-47de-a786-19a3d7bc0e7a} <Trace> InterpreterSelectQuery: FetchColumns -> Complete
2018.09.21 10:19:37.711388 [ 732 ] {78b5422b-2398-47de-a786-19a3d7bc0e7a} <Debug> executeQuery: Query pipeline:
Expression
 Expression
  One

2018.09.21 10:19:37.711825 [ 3148 ] {78b5422b-2398-47de-a786-19a3d7bc0e7a} <Trace> ThreadStatus: Thread 3148 exited
2018.09.21 10:19:37.711944 [ 463 ] <Trace> SystemLog (system.query_thread_log): Flushing system log
2018.09.21 10:19:37.712065 [ 732 ] {78b5422b-2398-47de-a786-19a3d7bc0e7a} <Information> executeQuery

python side (client):

>>> from clickhouse_driver import Client
>>> c = Client('XXX.XXX.XXX.XX', port=9000)
>>> c.execute('select 1')
[(1,)]
>>> 

Which tend to demonstrate that it is a superset issue ... isn't it ?

Thanks Matt.

[Matt-Texier]

Closing issue ... troubleshooting what's the issue in superset ... sorry for this useless issue.