[ https://issues.apache.org/jira/browse/HIVE-19831?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16876461#comment-16876461 ]
Rajkumar Singh commented on HIVE-19831: --------------------------------------- I think this will filter the database on which user don't have auth https://github.com/apache/hive/blob/fcd4721591e0ba7d9ba24821f9528dadb7ec16fd/standalone-metastore/metastore-common/src/main/java/org/apache/hadoop/hive/metastore/HiveMetaStoreClient.java#L1830 > Hiveserver2 should skip doAuth checks for CREATE DATABASE/TABLE if > database/table already exists > ------------------------------------------------------------------------------------------------ > > Key: HIVE-19831 > URL: https://issues.apache.org/jira/browse/HIVE-19831 > Project: Hive > Issue Type: Improvement > Components: HiveServer2 > Affects Versions: 1.2.1, 2.1.0 > Reporter: Rajkumar Singh > Assignee: Rajkumar Singh > Priority: Minor > Labels: pull-request-available > Fix For: 4.0.0 > > Attachments: HIVE-19831.01.patch, HIVE-19831.patch > > > with sqlstdauth on, Create database if exists take TOO LONG if there are too > many objects inside the database directory. Hive should not run the doAuth > checks for all the objects within database if the database already exists. -- This message was sent by Atlassian JIRA (v7.6.3#76005)