ClickHouse / ClickHouse/clickhouse-odbc
ClickHouse as a Linked Server in MSSQL
- Dominant language
- C
- Stars
- 285
- Forks
- 105
- Avg merge
- 3h 56m
- Merged PRs (30d)
- 3
Description
I have installed a driver and created linked server in Microsoft SQL Server 2005.
I successfully connected to it and can get some data (please see attached data)

but when I try run any query then I receive following errors:
`SELECT * FROM OPENQUERY([BIGDATA], 'SELECT CounterID FROM perf.CounterDetails')`
Msg 7357, Level 16, State 2, Line 1
Cannot process the object "SELECT CounterID FROM perf.CounterDetails". The OLE DB provider "MSDASQL" for linked server "BIGDATA" indicates that either the object has no columns or the current user does not have permissions on that object.
`select * from BIGDATA..perf.CounterData`
Msg 7312, Level 16, State 1, Line 1
Invalid use of schema or catalog for OLE DB provider "MSDASQL" for linked server "BIGDATA". A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog or schema.
`select * from [BIGDATA].perf..CounterData`
Msg 7313, Level 16, State 1, Line 1
An invalid schema or catalog was specified for the provider "MSDASQL" for linked server "BIGDATA".
Contributor guide
Research direction
No source file or test is named. Start by reproducing the OPENQUERY and four-part-name examples through the ClickHouse ODBC driver from Microsoft SQL Server 2005, then inspect how schema, catalog, and column metadata are exposed; done means the reported queries work or the unsupported limitation is clearly documented.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100