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

[Bug report] EXPLAIN command can not show query optimize details with using Gravitino Trino connector #3800

Closed
Tracked by #3524
diqiu50 opened this issue Jun 6, 2024 · 0 comments · Fixed by #3801
Assignees
Labels
bug Something isn't working

Comments

@diqiu50
Copy link
Contributor

diqiu50 commented Jun 6, 2024

Version

main branch

Describe what's wrong

The EXPLAIN command cannot display query optimization details when using the Gravitino Trino connector

explain select custkey from customer limit 10;
 Trino version: 435
 Fragment 0 [SOURCE]
     Output layout: [custkey]
     Output partitioning: SINGLE []
     Output[columnNames = [custkey]]
        Layout: [custkey:bigint]
       |_   Estimates: {rows: 10 (90B), cpu: 0, memory: 0B, network: 0B}
       |_ _  TableScan[table = gt_mysql:gt_db1:customer]
            Layout: [custkey:bigint]
            Estimates: {rows: 10 (90B), cpu: 90, memory: 0B, network: 0B}
            custkey := custkey

we expected:

 Trino version: 435
 Fragment 0 [SOURCE]
     Output layout: [custkey]
     Output partitioning: SINGLE []
     Output[columnNames = [custkey]]
     |_   Layout: [custkey:bigint]
     |_    Estimates: {rows: 10 (90B), cpu: 0, memory: 0B, network: 0B}
     |_ _  TableScan[table = mysql:gt_db1.customer gt_db1.customer limit=10 columns=[custkey:bigint:BIGINT]]
            Layout: [custkey:bigint]
            Estimates: {rows: 10 (90B), cpu: 90, memory: 0B, network: 0B}
            custkey := custkey:bigint:BIGINT

Error message and/or stacktrace

NO

How to reproduce

Execute EXPLAIN command

Additional context

No response

@diqiu50 diqiu50 added the bug Something isn't working label Jun 6, 2024
@diqiu50 diqiu50 self-assigned this Jun 6, 2024
yuqi1129 pushed a commit that referenced this issue Jun 12, 2024
…ize details (#3801)

### What changes were proposed in this pull request?

The EXPLAIN command cannot display query optimization details when using
the Gravitino Trino connector

### Why are the changes needed?

Fix: #3800

### Does this PR introduce _any_ user-facing change?

NO

### How was this patch tested?

IT
diqiu50 added a commit to diqiu50/gravitino that referenced this issue Jun 13, 2024
… optimize details (apache#3801)

### What changes were proposed in this pull request?

The EXPLAIN command cannot display query optimization details when using
the Gravitino Trino connector

### Why are the changes needed?

Fix: apache#3800

### Does this PR introduce _any_ user-facing change?

NO

### How was this patch tested?

IT
shaofengshi pushed a commit to shaofengshi/gravitino that referenced this issue Jun 24, 2024
… optimize details (apache#3801)

### What changes were proposed in this pull request?

The EXPLAIN command cannot display query optimization details when using
the Gravitino Trino connector

### Why are the changes needed?

Fix: apache#3800

### Does this PR introduce _any_ user-facing change?

NO

### How was this patch tested?

IT
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants