You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Miklos Szurap (Jira)" <ji...@apache.org> on 2022/01/19 13:33:00 UTC

[jira] [Created] (HIVE-25879) MetaStoreDirectSql test query should not query the DBS table

Miklos Szurap created HIVE-25879:
------------------------------------

             Summary: MetaStoreDirectSql test query should not query the DBS table
                 Key: HIVE-25879
                 URL: https://issues.apache.org/jira/browse/HIVE-25879
             Project: Hive
          Issue Type: Bug
            Reporter: Miklos Szurap


The runTestQuery() in the org/apache/hadoop/hive/metastore/MetaStoreDirectSql.java is using a test query
{code:java}
select "DB_ID" from "DBS"{code}
to determine whether the direct SQL can be used.

With larger deployments with many (10k+) Hive databases it would be more efficienct to query a small table instead, for example the "VERSION" table should always have a single row only.



--
This message was sent by Atlassian Jira
(v8.20.1#820001)