Return information about hive unsupported views and tables during listing

[pajaks]

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]

user get empty results. This should be improved.

what would you expect instead?

BTW are you aware of https://github.com/trinodb/trino/issues/6551 and https://github.com/trinodb/trino/issues/6551#issuecomment-903798696 in particular?

[pajaks]

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.