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

Return information about hive unsupported views and tables during listing #21990

Open
pajaks opened this issue May 16, 2024 · 2 comments
Open

Comments

@pajaks
Copy link
Member

pajaks commented May 16, 2024

In case of fetching information from information_schema with table_name predicate when table/view is not supported (e.g Table SerdeInfo is null) user get empty results. This should be improved.

Example queries (tests in TestHiveMetadataListing):

SELECT table_name FROM information_schema.tables WHERE table_schema = 'test_schema' AND table_name = 'unsupported_table'
SELECT table_name FROM information_schema.views WHERE table_schema = 'test_schema' AND table_name = 'unsupported_view'
@findepi
Copy link
Member

findepi commented May 16, 2024

user get empty results. This should be improved.

what would you expect instead?

BTW are you aware of #6551 and #6551 (comment) in particular?

@pajaks
Copy link
Member Author

pajaks commented May 16, 2024

what would you expect instead?

@ebyhr suggestion was to return table_name from predicate in case of some specific errors like UNSUPPORTED_TABLE_TYPE as we know that such table exists.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Development

No branches or pull requests

2 participants