[HIVE-28349] SHOW TABLES with invalid connector, giving 0 results, instead of failing

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.1.0, 4.0.1
• Component/s: Hive, Standalone Metastore
• Labels: hive-4.0.1-merged hive-4.0.1-must pull-request-available
• Assignee: Sai Hemanth Gantasala
• Reporter: Sai Hemanth Gantasala
• Created: 25/Jun/24 18:51
• Updated: 24/Sep/24 02:15
• Resolved: 25/Jul/24 01:18

Description

SHOW TABLES with invalid connector, giving 0 results, instead of failing

Steps to repro:

drop connector postgres_connector;
create connector postgres_connector type 'postgres' url 'jdbc:postgresql://1.1.1.1:31462' with DCPROPERTIES ("hive.sql.dbcp.username"="root", "hive.sql.dbcp.password"="cloudera");
drop database pg_hive_testing;
create remote database pg_hive_testing using postgres_connector with DBPROPERTIES ("connector.remoteDbName"="postgres");

show tables in pg_hive_testing; 

The last query gives 0 rows (not a failure).

Issue Links

• links to: GitHub Pull Request #5321