Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

External data support #34

Open
i-sinister opened this issue Jun 18, 2020 · 2 comments
Open

External data support #34

i-sinister opened this issue Jun 18, 2020 · 2 comments
Assignees
Labels
enhancement New feature or request investigation Additional investigation required

Comments

@i-sinister
Copy link

Is is possible to add support for external data for the queries? According to clickhouse documentation HTTP api supports it:

$ cat /etc/passwd | sed 's/:/\t/g' > passwd.tsv
$ curl -F '[email protected];' 'http://localhost:8123/?query=SELECT+shell,+count()+AS+c+FROM+passwd+GROUP+BY+shell+ORDER+BY+c+DESC&passwd_structure=login+String,+unused+String,+uid+UInt16,+gid+UInt16,+comment+String,+home+String,+shell+String'

For example command object could have a collection of objects representing "external data" - a class with name, schema and a callback that accepts writer and generates data

@DarkWanderer
Copy link
Owner

It should not be a problem API-wise (they can be represented as table-valued parameters), but I'm not sure how well it will work with the HTTP API, as I use POST body to pass query. Will need to investigate

@DarkWanderer DarkWanderer added the enhancement New feature or request label Jun 22, 2020
@DarkWanderer DarkWanderer self-assigned this Sep 20, 2020
@DarkWanderer DarkWanderer added the investigation Additional investigation required label Sep 27, 2020
@hohaftf
Copy link

hohaftf commented Feb 13, 2024

+1 for this feature

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request investigation Additional investigation required
Projects
None yet
Development

No branches or pull requests

3 participants