External Data
Maintainers usually reply within 1 day
Nobody has claimed this yet.
Assessment
- Difficulty
- 5/5
- Estimated time
- Over a week
- Newbie friendliness
- 25/100
Research direction
Start by reading the ClickHouse.Driver API and comparing the requested behavior with the mentioned Command.ExternalTables property. Review the existing HttpClient approach using _structure and _format=CSV URL parameters with CSV in FormData, and determine the API shape needed for external tables in SELECT or INSERT queries. Done means the supported behavior and an example are clearly defined.
Written by the indexing model from the issue text.
Description
Hi!
Is it possible to use External Data tables through ClickHouse.Driver?
Previously, I used HttpClient directly and added something like that into the URL
"string.Format("&{0}_structure={1}&{0}_format=CSV", TableName, GetDataStructure())", then main data went into FormData as CSV attachment.
This approach allows to send temp tables data with the main SELECT or INSERT query, and I need it as oxygen.
I see that third party libraries have a property for this Command.ExternalTables, but I don't see something similar here. Could you help with an example or advice?
Thanks in advance.
- Dominant language
- C#
- Stars
- 100
- Forks
- 26
- Avg merge
- 20h 24m
- Merged PRs (30d)
- 7
Getting set up
- No Dockerfile or Docker Compose file
- Has a pull request template
- Read the contributing guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from ClickHouse/clickhouse-cs
-
bug
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
ClickHouse/clickhouse-cs#714 ·
Maintainers usually reply within 1 day
-
HTTP client: DateTime64(9) silently stores a wrapped (wrong) value for dates outside 1677-2262Possibly taken @polyglotAI-bot claimed this today. Open
Difficulty 2/5 1-3 hours Newbie friendliness 82/100
ClickHouse/clickhouse-cs#711 ·
Maintainers usually reply within 1 day
-
bug
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
ClickHouse/clickhouse-cs#689 ·
Maintainers usually reply within 1 day
-
Every query fails with Code 164 (READONLY) for a readonly = 1 user: the driver always sends enable_http_compression and input_format_binary_read_json_as_string as settingsPossibly taken @polyglotAI-bot claimed this 30 days ago. Open
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
ClickHouse/clickhouse-cs#659 · 1 comment ·
Maintainers usually reply within 1 day
-
ClickHouseDecimal: Floor() rounds negative non-integers toward zero (-1.5 → -1, server floor gives -2)Possibly taken @polyglotAI-bot claimed this 30 days ago. Openbug
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
ClickHouse/clickhouse-cs#645 · 1 assignee ·
Maintainers usually reply within 1 day
All issues in ClickHouse/clickhouse-cs
Similar issues
-
Difficulty 2/5 1-3 hours Newbie friendliness 68/100
Facepunch/sbox-public#12305 ·
Maintainers usually reply within 5 days
-
Difficulty 2/5 1-3 hours Newbie friendliness 68/100
JiaFeiMiao-K-Cat/DiscImageStudio#205 ·
Maintainers usually reply within 1 day
-
bug keep-fresh
Difficulty 2/5 1-3 hours Newbie friendliness 68/100
Flow-Launcher/Flow.Launcher#4744 ·
Maintainers usually reply within 1 day
-
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
flyingpie/windows-terminal-quake#419 ·
Maintainers usually reply within 1 day
-
enhancement help wanted
Difficulty 2/5 1-3 hours Newbie friendliness 82/100