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

[Bug] Delta Lake columns only show in DBeaver/Power BI/etc. in the "default" database #4218

Closed
3 of 4 tasks
nousot-cloud-guy opened this issue Jan 31, 2023 · 2 comments
Closed
3 of 4 tasks

[Bug] Delta Lake columns only show in DBeaver/Power BI/etc. in the "default" database #4218

nousot-cloud-guy opened this issue Jan 31, 2023 · 2 comments
Labels
kind:bug This is a clearly a bug priority:major

Comments

@nousot-cloud-guy
Copy link
Contributor

Code of Conduct

Search before asking

  • I have searched in the issues and found no similar issues.

Describe the bug

When trying to list columns in a Delta Lake table using a tool like DBeaver or Power BI the operation only works if the table is in the "default" database. If the table is in any other database, the operation will fail with a "table or view not found" error.

Affects Version(s)

master/1.6.1

Kyuubi Server Log Output

No response

Kyuubi Engine Log Output

No response

Kyuubi Server Configurations

No response

Kyuubi Engine Configurations

No response

Additional context

No response

Are you willing to submit PR?

  • Yes. I would be willing to submit a PR with guidance from the Kyuubi community to fix.
  • No. I cannot submit a PR at this time.
@nousot-cloud-guy nousot-cloud-guy added kind:bug This is a clearly a bug priority:major labels Jan 31, 2023
@github-actions
Copy link

Hello @nousot-cloud-guy,
Thanks for finding the time to report the issue!
We really appreciate the community's efforts to improve Apache Kyuubi.

@nousot-cloud-guy
Copy link
Contributor Author

nousot-cloud-guy commented Jan 31, 2023 •
edited
Loading

Submitted #4219 for this.

@bowenliang123 bowenliang123 mentioned this issue Feb 3, 2023
Closed
3 tasks
@pan3793 pan3793 closed this as completed in 2b958c6 Feb 6, 2023
pan3793 pushed a commit that referenced this issue Feb 6, 2023
@nousot-cloud-guy @pan3793
[KYUUBI #4218] Using DB and table name when checking Delta table schema.
fa41e3e 
### _Why are the changes needed?_

To close #4218 .
This change ensures BI tools can list columns on Delta Lake tables in all schemas.

<img width="312" alt="image" src="https://user-images.githubusercontent.com/89149767/215793967-722eb5f9-ffe4-4ffb-b7f9-1ded06c146d7.png">

<img width="725" alt="image" src="https://user-images.githubusercontent.com/89149767/215794036-871f005f-1494-487d-90aa-1f99891177c2.png">

### _How was this patch tested?_
- [ ] Add some test cases that check the changes thoroughly including negative and positive cases if possible

- [x] Add screenshots for manual tests if appropriate

- [ ] [Run test](https://kyuubi.readthedocs.io/en/master/develop_tools/testing.html#running-tests) locally before make a pull request

Closes #4219 from nousot-cloud-guy/feature/delta-db-schema.

Closes #4218

5698432 [Alex Wiss-Wolferding] Reversing match order in getColumnsByCatalog.
a6d973a [Alex Wiss-Wolferding] Revert "[KYUUBI #1458] Delta lake table columns won't show up in DBeaver."
20337dc [Alex Wiss-Wolferding] Revert "Using DB and table name when checking Delta table schema."
f7e4675 [Alex Wiss-Wolferding] Using DB and table name when checking Delta table schema.

Authored-by: Alex Wiss-Wolferding <alex@nousot.com>
Signed-off-by: Cheng Pan <chengpan@apache.org>
(cherry picked from commit 2b958c6)
Signed-off-by: Cheng Pan <chengpan@apache.org>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
kind:bug This is a clearly a bug priority:major
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

[KYUUBI #4218] Prefer to use TableCatalog to load tables from session catalog nousot/kyuubi
1 participant
@nousot-cloud-guy