Skip to content

Add combining http parameters with queries, new handler for accessing tables as files #64336

Draft
nooblose wants to merge 7 commits intoClickHouse:masterfrom
nooblose:master
Draft

Add combining http parameters with queries, new handler for accessing tables as files #64336
nooblose wants to merge 7 commits intoClickHouse:masterfrom
nooblose:master

Conversation

@nooblose
Copy link
Copy Markdown
Contributor

@nooblose nooblose commented May 24, 2024

Changelog category:

  • New Feature

Changelog entry:

Added a new handler with tabular prefix, which supports accessing tables as files. The URL path contains the name of the database, tables, and an optional format

Added combining HTTP requests with query parameters such as where, select, etc

Added new parameter execute, which indicates whether the request should be executed or returned in text format

Documentation entry for user-facing changes

Queries like tabular/database/table.csv are now supported, which are equal to the SQL query SELECT * FROM database.table FORMAT CSV

Additional parameters can be specified in the path, such as select, columns, where, order, which are combined with the query. For example tabular/table?columns=a,b&where=a>1&order=a ASC, b DESC is equel to SELECT a,b FROM table WHERE a > 1 ORDER BY a ASC, b DESC.

Also support column names in query as filters (only = and >=/<= operations) like ?a=2&b<=3&c>=5

Resolves #46925

Information about CI checks: https://clickhouse.com/docs/en/development/continuous-integration/

CI Settings

NOTE: If your merge the PR with modified CI you MUST KNOW what you are doing
NOTE: Checked options will be applied if set before CI RunConfig/PrepareRunConfig step

Run these jobs only (required builds will be added automatically):

  • Integration Tests
  • Stateless tests
  • Stateful tests
  • Unit tests
  • Performance tests
  • All with aarch64
  • All with ASAN
  • All with TSAN
  • All with Analyzer
  • All with Azure
  • Add your option here

Deny these jobs:

  • Fast test
  • Integration Tests
  • Stateless tests
  • Stateful tests
  • Performance tests
  • All with ASAN
  • All with TSAN
  • All with MSAN
  • All with UBSAN
  • All with Coverage
  • All with Aarch64

Extra options:

  • do not test (only style check)
  • disable merge-commit (no merge from master before tests)
  • disable CI cache (job reuse)

Only specified batches in multi-batch jobs:

  • 1
  • 2
  • 3
  • 4

@rschu1ze
Copy link
Copy Markdown
Member

?

@nooblose
Copy link
Copy Markdown
Contributor Author

?

No need to look at this pull request yet ))

@nooblose nooblose changed the title add execute queries by ast Add combining http parameters with queries, new handler for accessing tables as files May 24, 2024
@clickhouse-ci
Copy link
Copy Markdown

clickhouse-ci bot commented May 24, 2024

This is an automatic comment. The PR descriptions does not match the template.

Please, edit it accordingly.

The error is: More than one changelog category specified: 'New Feature', 'Improvement'

@clickhouse-ci
Copy link
Copy Markdown

clickhouse-ci bot commented May 24, 2024

This is an automatic comment. The PR descriptions does not match the template.

Please, edit it accordingly.

The error is: Changelog entry required for category 'New Feature'

2 similar comments
@clickhouse-ci
Copy link
Copy Markdown

clickhouse-ci bot commented May 24, 2024

This is an automatic comment. The PR descriptions does not match the template.

Please, edit it accordingly.

The error is: Changelog entry required for category 'New Feature'

@clickhouse-ci
Copy link
Copy Markdown

clickhouse-ci bot commented May 24, 2024

This is an automatic comment. The PR descriptions does not match the template.

Please, edit it accordingly.

The error is: Changelog entry required for category 'New Feature'

@alexey-milovidov
Copy link
Copy Markdown
Member

@rschu1ze, now there is some sense in starting to look...

@alanpaulkwan
Copy link
Copy Markdown

Any chance we can start testing this? I would love it for sharing some data with collaborators.

@alexey-milovidov
Copy link
Copy Markdown
Member

I want this feature - it will be very handy! But this PR is abandoned, and we should finish it first.

@clickhouse-gh
Copy link
Copy Markdown
Contributor

clickhouse-gh bot commented Sep 17, 2024

Dear @nooblose, this PR hasn't been updated for a while. Will you continue working on it? If not, please close it. Otherwise, ignore this message.

1 similar comment
@clickhouse-gh
Copy link
Copy Markdown
Contributor

clickhouse-gh bot commented Nov 19, 2024

Dear @nooblose, this PR hasn't been updated for a while. Will you continue working on it? If not, please close it. Otherwise, ignore this message.

@alexey-milovidov alexey-milovidov mentioned this pull request Dec 31, 2024
76 tasks
@clickhouse-gh
Copy link
Copy Markdown
Contributor

clickhouse-gh bot commented Jan 21, 2025

Dear @nooblose, this PR hasn't been updated for a while. Will you continue working on it? If not, please close it. Otherwise, ignore this message.

5 similar comments
@clickhouse-gh
Copy link
Copy Markdown
Contributor

clickhouse-gh bot commented Mar 25, 2025

Dear @nooblose, this PR hasn't been updated for a while. Will you continue working on it? If not, please close it. Otherwise, ignore this message.

@clickhouse-gh
Copy link
Copy Markdown
Contributor

clickhouse-gh bot commented May 27, 2025

Dear @nooblose, this PR hasn't been updated for a while. Will you continue working on it? If not, please close it. Otherwise, ignore this message.

@clickhouse-gh
Copy link
Copy Markdown
Contributor

clickhouse-gh bot commented Jul 29, 2025

Dear @nooblose, this PR hasn't been updated for a while. Will you continue working on it? If not, please close it. Otherwise, ignore this message.

@clickhouse-gh
Copy link
Copy Markdown
Contributor

clickhouse-gh bot commented Sep 30, 2025

Dear @nooblose, this PR hasn't been updated for a while. Will you continue working on it? If not, please close it. Otherwise, ignore this message.

@clickhouse-gh
Copy link
Copy Markdown
Contributor

clickhouse-gh bot commented Dec 2, 2025

Dear @nooblose, this PR hasn't been updated for a while. Will you continue working on it? If not, please close it. Otherwise, ignore this message.

@alexey-milovidov alexey-milovidov mentioned this pull request Dec 31, 2025
72 tasks
@clickhouse-gh
Copy link
Copy Markdown
Contributor

clickhouse-gh bot commented Feb 3, 2026

Dear @nooblose, this PR hasn't been updated for a while. Will you continue working on it? If not, please close it. Otherwise, ignore this message.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

Accessing tables as files in HTTP interface

4 participants