[ https://issues.apache.org/jira/browse/HIVE-16912?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Naveen Gangam updated HIVE-16912: --------------------------------- Resolution: Fixed Fix Version/s: 3.0.0 Status: Resolved (was: Patch Available) Thanks for the review [~aihuaxu]. Fix has been committed to master for 3.0.0. > Improve table validator's performance against Oracle > ---------------------------------------------------- > > Key: HIVE-16912 > URL: https://issues.apache.org/jira/browse/HIVE-16912 > Project: Hive > Issue Type: Sub-task > Components: Hive > Affects Versions: 3.0.0 > Reporter: Naveen Gangam > Assignee: Naveen Gangam > Priority: Minor > Fix For: 3.0.0 > > Attachments: HIVE-16912.2.patch, HIVE-16912.patch > > > Currently, this validator uses DatabaseMetaData.getTables() that takes in the > order of minutes to return because of the number of SYSTEM tables present in > Oracle. > Providing a schema name via a system property would limit the number of > tables being returned and thus improve performance. -- This message was sent by Atlassian JIRA (v6.4.14#64029)