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.

Sign up for GitHub

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

Jump to bottom

[Feature]: HTTP API #1937

Open
64 of 65 tasks
JinHai-CN opened this issue Sep 29, 2024 · 0 comments
Open
64 of 65 tasks

[Feature]: HTTP API #1937

JinHai-CN opened this issue Sep 29, 2024 · 0 comments
Assignees
@Ami11111
Labels
feature request New feature or request

Comments

@JinHai-CN
Copy link
Contributor

JinHai-CN commented Sep 29, 2024 •
edited
Loading

Database:

  • list databases: '/databases' GET
  • create database: '/databases/{db_name}' POST
  • drop database: '/databases/{db_name}' DELETE
  • show database: '/databases/{db_name}' GET

Table:

  • list tables: '/databases/{db_name}/tables' GET
  • create table: '/databases/{db_name}/tables/{table_name}' POST
  • drop table: '/databases/{db_name}/tables/{table_name}' DELETE
  • show table: '/databases/{db_name}/tables/{table_name}' GET
  • export table: '/databases/{db_name}/table/{table_name}' GET
  • show table columns '/databases/{db_name}/tables/{table_name}/columns' GET
  • alter add column '/databases/{db_name}/tables/{table_name}/columns' POST
  • alter drop column '/databases/{db_name}/tables/{table_name}/columns' DELETE
  • list table segments '/databases/{db_name}/tables/{table_name}/segments' GET
  • show table segment '/databases/{db_name}/tables/{table_name}/segments/{segment_id}' GET
  • list table blocks '/databases/{db_name}/tables/{table_name}/segments/{segment_id}/blocks' GET
  • show table block '/databases/{db_name}/tables/{table_name}/segments/{segment_id}/blocks/{block_id}' GET
  • show table block column '/databases/{db_name}/tables/{table_name}/segments/{segment_id}/blocks/{block_id}/{column_id}' GET

Insert / Delete / Update

  • import: '/databases/{db_name}/tables/{table_name}' PUT
  • insert: '/databases/{db_name}/tables/{table_name}/docs' POST
  • delete: '/databases/{db_name}/tables/{table_name}/docs' DELETE
  • update: '/databases/{db_name}/tables/{table_name}/docs' PUT

Select / Explain

  • select/search: '/databases/{db_name}/tables/{table_name}/docs' GET
  • explain: '/databases/{db_name}/tables/{table_name}/query' GET

Index

  • list indexes: '/databases/{db_name}/tables/{table_name}/indexes' GET
  • show index: '/databases/{db_name}/tables/{table_name}/indexes/{index_name}' GET
  • show index segment: '/databases/{db_name}/tables/{table_name}/indexes/{index_name}/segment/{segment_id}' GET
  • show index chunk of segment: '/databases/{db_name}/tables/{table_name}/indexes/{index_name}/segment/{segment_id}/chunk/{chunk_id}' GET
  • drop index: '/databases/{db_name}/tables/{table_name}/indexes/{index_name}' DELETE
  • create index: '/databases/{db_name}/tables/{table_name}/indexes/{index_name}' POST
  • optimize index: '/databases/{db_name}/tables/{table_name}/indexes/{index_name}' PUT

Config

  • list config: '/configs' GET
  • show config: '/configs/{config_name}' GET
  • set config: '/configs/{config_name}' POST

Variable

  • list global variables: '/variables/global' GET
  • show global variable: '/variables/global/{variable_name}' GET
  • set global variables: '/variables/global' SET
  • list session variables: '/variables/session' GET
  • show session variable: '/variables/session/{variable_name}' GET
  • set session variables: '/variables/session' SET

Instance operation and metrics

  • show buffer: '/instance/buffer' GET Add HTTP APIs #1996
  • show profiles: '/instance/profiles' GET Add HTTP APIs #1996
  • show memindex: '/instance/memindex' GET Add HTTP APIs #1996
  • show queries: '/instance/queries' GET Add HTTP APIs #1996
  • show query: '/instance/queries/{query_id}' GET
  • show transactions: '/instance/transactions' GET
  • show transaction: '/instance/transactions/{transaction_id}' GET
  • show logs: '/instance/logs' GET
  • show delta checkpoint: '/instance/delta_checkpoint' GET
  • show global checkpoint: '/instance/global_checkpoint' GET
  • show objects: '/instance/objects' GET
  • show object: '/instance/objects/{object_name}' GET
  • show files in object: '/instance/files' GET
  • show memory: '/instance/memory' GET
  • show memory objects: '/instance/memory/objects' GET
  • show memory allocation: '/instance/memory/allocation' GET
  • force global checkpoint: '/instance/flush' POST
  • compact table: '/instance/table/compact' POST

Cluster admin

  • set node role: '/admin/node/current' POST
  • list node variables: '/admin/variables' GET
  • list node configs: '/admin/configs' GET
  • show node variable: '/admin/variables/{var_name}' GET
  • list nodes: '/admin/nodes' GET
  • show node: '/admin/node/{node_name}' GET
  • show current node: '/admin/node/current' GET
  • remove node: '/admin/node/{node_name}' DELETE
@JinHai-CN JinHai-CN added the feature request New feature or request label Sep 29, 2024
@infiniflow infiniflow deleted a comment Sep 29, 2024
@Ami11111 Ami11111 mentioned this issue Sep 29, 2024
Merged
2 tasks
JinHai-CN pushed a commit that referenced this issue Sep 29, 2024
@Ami11111
More show commad for http (#1939)
4834a90 
### What problem does this PR solve?

- add show and set command for session variables for http
- fix show global variables bug 

Issue link:#1937

### Type of change

- [x] Bug Fix (non-breaking change which fixes an issue)
- [x] New Feature (non-breaking change which adds functionality)
@JinHai-CN JinHai-CN changed the title HTTP API: More SHOW and SET command [Feature]: HTTP API Sep 29, 2024
@JinHai-CN JinHai-CN pinned this issue Sep 29, 2024
@vsian vsian mentioned this issue Oct 10, 2024
Merged
2 tasks
JinHai-CN pushed a commit that referenced this issue Oct 10, 2024
@vsian
Http admin part2 (#2002)
fc8bb4b 
### What problem does this PR solve?

_HTTP APIs for admin mode: set node role, list node variables, list node
configs, show node variable_

Issue link: #1937 

### Type of change

- [x] New Feature (non-breaking change which adds functionality)
- [x] Documentation Update

---------

Signed-off-by: vsian <[email protected]>
This was referenced Oct 10, 2024
Merged
Merged
JinHai-CN pushed a commit that referenced this issue Oct 10, 2024
@vsian
http instance apis : logs, delta_checkpoint, global_checkpoint (#2010)
cfbc37b 
### What problem does this PR solve?

3 HTTP instance APIs:
- show logs (not documented)
- show delta checkpoints  (not documented)
- show full checkpoints (not documented)

Issue link: #1937 

### Type of change

- [x] New Feature (non-breaking change which adds functionality)
JinHai-CN pushed a commit that referenced this issue Oct 11, 2024
@vsian
HTTP APIs : SHOW QUERY, SHOW TRANSACTIONS, SHOW TRANSACTION (#2007)
f9bcc48 
### What problem does this PR solve?

New HTTP APIs of:

- SHOW QUERY {QUERY_ID} (not documented)
- SHOW TRANSACTIONS
- SHOW TRANSACTION

Issue link: #1937 

### Type of change

- [x] New Feature (non-breaking change which adds functionality)
- [x] Documentation Update

---------

Signed-off-by: vsian <[email protected]>
@vsian vsian mentioned this issue Oct 11, 2024
Merged
3 tasks
JinHai-CN pushed a commit that referenced this issue Oct 11, 2024
@vsian
new HTTP APIs : SHOW OBJECTS, SHOW OBJECT, SHOW FILES (#2013)
6fb6a1e 
### What problem does this PR solve?

new HTTP APIs :
- SHOW OBJECTS (Documented)
- SHOW OBJECT (Documented)
- SHOW FILES (Documented)

Add docs:
- SHOW LOGS
- SHOW DELTA CHECKPOINTS
- SHOW FULL CHECKPOINTS

Fix:
infinity::ShowObject will cause segfault.

Issue link: #1937 

### Type of change

- [x] Bug Fix (non-breaking change which fixes an issue)
- [x] New Feature (non-breaking change which adds functionality)
- [x] Documentation Update
@vsian vsian mentioned this issue Oct 11, 2024
Merged
1 task
JinHai-CN pushed a commit that referenced this issue Oct 11, 2024
@vsian
HTTP APIs : SHOW MEMORY, SHOW MEMORY OBJECTS, SHOW MEMORY ALLOCATION (#…
5113cd1 
…2016)

### What problem does this PR solve?

HTTP APIs :
- SHOW MEMORY  (not docuemented)
- SHOW MEMORY OBJECT (not documented)
-  SHOW MEMORY ALLOCATION (not documented)

Issue link: #1937 

### Type of change

- [x] New Feature (non-breaking change which adds functionality)
@vsian vsian mentioned this issue Oct 14, 2024
Merged
1 task
JinHai-CN pushed a commit that referenced this issue Oct 14, 2024
@vsian
instance HTTP APIs : ForceCheckpoint, CompactTable (#2036)
b7706b5 
### What problem does this PR solve?

New HTTP APIs for instance:
- Force GlobalCheckpoint. (Not documented.)
- Compact Table. (Not documented.)

Issue link: #1937 

### Type of change

- [x] New Feature (non-breaking change which adds functionality)
@vsian vsian mentioned this issue Oct 14, 2024
Merged
1 task
JinHai-CN pushed a commit that referenced this issue Oct 14, 2024
@vsian @writinwaters
HTTP APIs document (#2039)
19e1a34 
### What problem does this PR solve?

Add documents for folloing HTTP APIs:
- Show memory
- Show memory objects
- Show memory allocation
- Force global checkpoint
- Compact table

Issue link: #1937 

### Type of change

- [x] Documentation Update

---------

Co-authored-by: writinwaters <[email protected]>
@vsian vsian mentioned this issue Oct 14, 2024
Merged
1 task
JinHai-CN pushed a commit that referenced this issue Oct 14, 2024
@vsian
Add examples for HTTP instance APIs. (#2043)
1873ed5 
### What problem does this PR solve?

Add examples for HTTP instance APIs.

Issue link: #1937 

### Type of change

- [x] Other (please describe): examples.
This was referenced Oct 16, 2024
Closed
Merged
JinHai-CN pushed a commit that referenced this issue Oct 16, 2024
@vsian
More HTTP examples. (#2054)
92eab12 
### What problem does this PR solve?

New HTTP examples:
- Show table segments
- Show table blocks
- Drop table columns
- Show index segments
- Show index chunk
- Show table block
- Show table block block column

Issue link: #1937

### Type of change

- [x] Other (please describe): examples change.
vsian added a commit to vsian/infinity that referenced this issue Oct 18, 2024
@vsian
More HTTP examples. (infiniflow#2054)
f28b8d2 
### What problem does this PR solve?

New HTTP examples:
- Show table segments
- Show table blocks
- Drop table columns
- Show index segments
- Show index chunk
- Show table block
- Show table block block column

Issue link: infiniflow#1937

### Type of change

- [x] Other (please describe): examples change.
@zjbpaul1317 zjbpaul1317 mentioned this issue Oct 24, 2024
Merged
1 task
JinHai-CN pushed a commit that referenced this issue Oct 25, 2024
@zjbpaul1317
Add HTTP API (#2098)
3c48adb 
### What problem does this PR solve?

_Briefly describe what this PR aims to solve. Include background context
that will help reviewers understand the purpose of the PR._

Issue link:#[HTTP API
1937](#1937)]

### Type of change

- [x] New Feature (non-breaking change which adds functionality)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@Ami11111 Ami11111

Labels
feature request New feature or request
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@JinHai-CN @Ami11111