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

Support for information_schema database #4659

Closed
2 tasks
BohuTANG opened this issue Apr 1, 2022 · 2 comments · Fixed by #4672
Closed
2 tasks

Support for information_schema database #4659

BohuTANG opened this issue Apr 1, 2022 · 2 comments · Fixed by #4672
Assignees
Labels
A-query Area: databend query C-feature Category: feature v0.8
Milestone

Comments

@BohuTANG
Copy link
Member

BohuTANG commented Apr 1, 2022

Summary

Some MySQL driver/GUI(like dbeaver) always access information_schema to fetch some meta information, information_schema tables are actually views, after the view(#4628) checked in, it's time to support the information_schema database, let the GUI easy to connect to Databend.

Tasks:

  • Add information_schema database
  • Impl some immutable views for information_schema which dbeaver need
@BohuTANG BohuTANG added A-query Area: databend query v0.8 C-feature Category: feature labels Apr 1, 2022
@BohuTANG
Copy link
Member Author

BohuTANG commented Apr 1, 2022

@TCeason may have some views information what's dbeaver used.

@TCeason
Copy link
Collaborator

TCeason commented Apr 1, 2022

Yes, the dbeaver now needs these views in information_schema:

information_schema.COLUMNS
information_schema.TABLES
INFORMATION_SCHEMA.KEYWORDS

And SQL

  • show full tables (has already support on local)
  • show table status

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
A-query Area: databend query C-feature Category: feature v0.8
Projects
None yet
Development

Successfully merging a pull request may close this issue.

4 participants