ClickHouse / ClickHouse/clickhouse-odbc

ClickHouse as a Linked Server in MSSQL

Open
#215 8 comments 0 reactions 0 assignees View on GitHub
MSSQL need info
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)
![linked_server](https://user-images.githubusercontent.com/33670268/69711217-b8c11800-1111-11ea-8dd4-5d00fd71b2fb.png)
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.