[ https://issues.apache.org/jira/browse/HIVE-16912?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16051947#comment-16051947 ]
Aihua Xu commented on HIVE-16912: --------------------------------- So this property is new which should be set in order to take advantage of the performance benefit? Since we have the connection URL to the database like {{javax.jdo.option.ConnectionURL: jdbc:oracle:thin:@saturn:1521:solarsid}}, probably we can automatically get the database name? > 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 > Attachments: 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)