Denis Glazachev

Results 121 comments of Denis Glazachev

If this is still relevant, please try the latest release (`v1.1.1.20191108`). Specific fixes were applied there, and the chances are they address this issue.

Is it reproducible with increased `timeout`? See odbc driver config docs.

Could it be that the ClickHouse server terminates the query execution due to memory exhaustion? What are log messages for that query?

`?` has a special meaning in SQL queries in ODBC at least: https://docs.microsoft.com/en-us/sql/odbc/reference/develop-app/statement-parameters. Try escaping like this `\?`.

If I execute: ``` SELECT * FROM url('http://127.0.0.1:12345/?param1=value1', CSV, 'column1 String') ``` In ClickHouse log I see: ``` 2020.08.27 13:05:01.438623 [ 8847190 ] {f75ffb28-4d5e-4aa8-835a-01436fab7e6d} executeQuery: (from [::1]:58836) SELECT * FROM...

You need the preconfigured DSN(s) that point to a running ClickHouse server. Also, check `TEST_DSN_LIST` cmake param.

Да, будет исправлено в #220, однако ждать, что скорость с Unicode конвертациями будет такая же, как у ANSI, не стоит.

Можно еще поэкспериментировать с `CAP_ODBC_BIND_SUPPRESS_WIDE_CHAR`. См. https://help.tableau.com/current/pro/desktop/en-us/odbc_capabilities.htm и https://github.com/ClickHouse/clickhouse-odbc/blob/master/packaging/clickhouse-odbc.tdc.sample

This looks more like a syntax not supported by ClickHouse server itself. Try running these same queries that Tableau generates and ClickHouse ODBC driver retransmits, manually through ClickHouse CLI client.

Try verifying that the driver is installed and DNS is configured correctly, using `iodbctest` utility (comes with `libiodbc`.)