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

feat: explain analyze graphical #1261

Merged
merged 7 commits into from
Oct 14, 2024
Merged

Conversation

Maricaya
Copy link
Contributor

@Maricaya Maricaya commented Sep 27, 2024

I am a student that from Open Source Promotion Plan 2024. Add explain analyze graphical for BendSQL.

Copy link

vercel bot commented Sep 27, 2024

The latest updates on your projects. Learn more about Vercel for Git ↗︎

Name Status Preview Comments Updated (UTC)
databend ✅ Ready (Inspect) Visit Preview 💬 Add feedback Oct 14, 2024 1:31pm

@soyeric128
Copy link
Collaborator

MacBook-Air:Desktop eric$ bendsql
Welcome to BendSQL 0.19.2-1e338e1(2024-07-17T09:02:28.323121000Z).
Connecting to localhost:8000 as user root.
Connected to Databend Query v1.2.642-nightly-dd45c198ba(rust-1.81.0-nightly-2024-09-29T22:09:33.443401294Z)

root@localhost:8000/default> EXPLAIN ANALYZE GRAPHICAL select 1;
error: APIError: ResponseError with 1005: error:
  --> SQL:1:17
  |
1 | EXPLAIN ANALYZE GRAPHICAL select 1
  |                 ^^^^^^^^^ unexpected `GRAPHICAL`, expecting `PARTIAL`, `GRANT`, `REPLACE`, `ROLLBACK`, `DROP`, `BEGIN`, `VACUUM`, `UNDROP`, `CREATE`, `RENAME`, `IGNORE_RESULT`, `ATTACH`, `REFRESH`, `OPTIMIZE`, `EXPLAIN`, `PRESIGN`, `DESCRIBE`, `TRUNCATE`, `SHOW`, `KILL`, `DESC`, `LIST`, `COPY`, `CALL`, `FROM`, `INTERSECT`, `TABLE`, `UNION`, `ORDER`, `LIMIT`, `ALTER`, `MERGE`, `SELECT`, `VALUES`, `COMMIT`, `EXISTS`, `REMOVE`, `REVOKE`, `ANALYZE`, `EXECUTE`, `WITH`, `ABORT`, `EXCEPT`, `UPDATE`, `(`, `OFFSET`, `SET`, `SYSTEM`, `USE`, `INSERT`, `DELETE`, or `UNSET`


root@localhost:8000/default>

@Chasen-Zhang
Copy link
Member

Chasen-Zhang commented Sep 30, 2024

MacBook-Air:Desktop eric$ bendsql
Welcome to BendSQL 0.19.2-1e338e1(2024-07-17T09:02:28.323121000Z).
Connecting to localhost:8000 as user root.
Connected to Databend Query v1.2.642-nightly-dd45c198ba(rust-1.81.0-nightly-2024-09-29T22:09:33.443401294Z)

root@localhost:8000/default> EXPLAIN ANALYZE GRAPHICAL select 1;
error: APIError: ResponseError with 1005: error:
  --> SQL:1:17
  |
1 | EXPLAIN ANALYZE GRAPHICAL select 1
  |                 ^^^^^^^^^ unexpected `GRAPHICAL`, expecting `PARTIAL`, `GRANT`, `REPLACE`, `ROLLBACK`, `DROP`, `BEGIN`, `VACUUM`, `UNDROP`, `CREATE`, `RENAME`, `IGNORE_RESULT`, `ATTACH`, `REFRESH`, `OPTIMIZE`, `EXPLAIN`, `PRESIGN`, `DESCRIBE`, `TRUNCATE`, `SHOW`, `KILL`, `DESC`, `LIST`, `COPY`, `CALL`, `FROM`, `INTERSECT`, `TABLE`, `UNION`, `ORDER`, `LIMIT`, `ALTER`, `MERGE`, `SELECT`, `VALUES`, `COMMIT`, `EXISTS`, `REMOVE`, `REVOKE`, `ANALYZE`, `EXECUTE`, `WITH`, `ABORT`, `EXCEPT`, `UPDATE`, `(`, `OFFSET`, `SET`, `SYSTEM`, `USE`, `INSERT`, `DELETE`, or `UNSET`


root@localhost:8000/default>

This feature databend has not been sent up yet, try again after a while,documents will not be merged into the main branch for the time being @soyeric128

@PsiACE
Copy link
Member

PsiACE commented Sep 30, 2024

If this feature is only available in bensql, we need to mark it up in the documentation.

@Chasen-Zhang
Copy link
Member

If this feature is only available in bensql, we need to mark it up in the documentation.

cc @Maricaya

-> FROM supplier,
-> lineitem l1,
-> orders,
-> nation
Copy link
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

@Maricaya I wonder if these arrows can be removed ?

@Chasen-Zhang Chasen-Zhang merged commit 96c503d into databendlabs:main Oct 14, 2024
3 checks passed
@soyeric128
Copy link
Collaborator

Please add the version this command was introduced. Example:

import FunctionDescription from '@site/src/components/FunctionDescription';

<FunctionDescription description="Introduced or updated: v1.2.345"/>

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.

4 participants